Does any one has an idea why it fails while writing data in to partition.
I have only one partition which is default. I am using Molap.
The data is unable to cache from relational db to the cube partition.
The rrror from the profiler:
Started building processing schedule.
Finished building processing schedule.
Processing of the 'XYZ_20081102' cube has started..
Starting to write data of the 'XYZ_INCR_UPDATE_TEMP_2d232_' partition.
The job completed with failure.
Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: An unexpected exception occurred. Errors in the OLAP storage engine: An error occurred while processing the 'XYZ_INCR_UPDATE_TEMP_2d232_' partition of the 'XYZ' measure group for the 'XYZ' cube from the XYZ database. Server: The operation has been cancelled.
The analysis service terminates after 4-5 retries caching the data.
I could also observer Proactive caching is not properly working in sql serer 2008 when using polling.
Any thoughs or advice is appreciated
View Complete Post