Process Dimension FailedThe operation was cancelled because of locking conflicts

[former_member223775]

Dear All,

One of our user has failed in running process dimension stated “[PACCOUNT_E].[#TOTAL_OER] Server: The operation was cancelled because of locking conflicts”.

Try to find any info but seem cannot find any much on it. Any advice or guide very much appreciated as where should I start looking for the root cause for the error.

Regards

[Former Member]

This error is returned by the MS SSAS server.

Can the user try to process again? Is the same error coming up?

Also try adjusting the  ForceCommitTimeout  and CommitTimeout  after reading this:

SSAS Locking: CommitTimeout and ForceCommitTimeout | Christian Wade's Blog

and this:

The operation was cancelled because of locking conflicts.