sql-serverssisssasmdxolap-cube

Server: The operation was cancelled because of locking conflicts (Analysis Services)

I have a report application that is connected to an Olap cube in Analysis Services and every time that the application query the cube while the cube is processing I'm getting these errors:

1-Server:The operation was cancelled because of locking conflicts.

2-'MSOLAP' failed with no error message available, result code: E_FAIL(0x80004005)

The cube is updating every 10 minutes through a SQL Agent job with SSIS package that contain Analysis Services Processing task and the application is querying the cube every 15 minutes.

I was wondering if there is any option that I can set in the SSIS package or in the Cube.

enter image description here

enter image description here

Solution

  • If you want to avoid this problem I suggest you process a copy of the cube on another instance or server and then synchronise the processed cube to the server queried by your application.

    This will prevent future locking problems and be invisible to the end user.