June 13, 2018 at 3:21 am
This is strange behaviour with only one cube out of 40 cubes. The cube has been set up which has partition and works when I process manually in SSDT. Then the SSIS package set up to refresh the cube data every day via SQL Job which fails. The first thing normally we do is manually run the cube and one of the dimension or partition will give an error because of data inconsistency in fact and dimension (or some error). In this case the cube always works manually and therefore there is no data inconsistency. When I refresh the cube manually in SSDT and then run the SSIS job, the job works without any problem.
The error I get is:
Description: Errors in the OLAP storage engine: An error occurred while processing the 'xxx' partition of the 'xxx' measure group for the 'xxx' cube from the xxx database
How do I rectify this issue?
June 18, 2018 at 4:01 am
Just to update so it can be useful for other members.
This was resolved by processing all dimensions in the SSIS package first and then processing cubes with Process Full Options.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply