SSAS: Server: The current operation was cancelled because another operation in the transaction failed.

Question

Hello, I'm creating dimensions in SSAS and I was successful with the two other dimensions tables but only this one is giving me an error when processing it.

the error is
Server: The current operation was cancelled because another operation in the transaction failed.

Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Loan', Name of 'Dim Loan' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Credit Card Authorization' attribute of the 'Dim Loan' dimension from the 'RMG_CUBE_2020' database was being processed.

OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.

Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_Dim_Loan', Column: 'Purpose_of_Loan', Value: 'Investment'. The attribute is 'Purpose Of Loan'.

I checked my data and I don't have any duplicates in the primary key, while with the investment row was repeated intentionally in that column 'Purpose_of_Loan',
this column is not primary key or unique so I'm not sure why I'm getting this error

can you please tell me what I'm I doing wrong in here?

Answer 1

Hi,

There is the general support article for this error, you could see the solution in it see if it helps: Error message when processing a dimension Check about the case sensitive case in the article.

regards,
Lukas