Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Refresh errors with SSAS cubes

Good day! 

 

We have a series of programmed Power BI files in on-premise Power BI Report Server. These reports obtain information from SSAS cubes in ImportData connection mode. The same report can run successfully or with errors within minutes (from 14 executions last night of 7 different reports, 4 failed and 10 were successful).

The errors we're having are: 

 

{"SessionID":"15aba707-298d-4dcf-9f97-a0fd30d0168c","Errors":[{"ErrorCode":-1055784932,"Message":"AnalysisServices: Server: The operation was cancelled because of locking conflicts.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null}]}
{"SessionID":"6a57b0cd-6411-411a-8cfc-abb000c36654","Errors":[{"ErrorCode":-1055784932,"Message":"AnalysisServices: Server: The operation was cancelled because of locking conflicts.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null}]}
{"SessionID":"c3e2fcea-67cf-4764-838f-75929ccc6d0a","Errors":[{"ErrorCode":-1055784932,"Message":"AnalysisServices: Server:  The operation was cancelled because of locking conflicts.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null}]}
{"SessionID":"05be2e40-cfde-4451-8615-c69472389e94","Errors":[{"ErrorCode":-1055784934,"Message":"AnalysisServices: Server:  The operation was cancelled because of locking conflicts.. The exception was raised by the IDataReader interface.","CallStack":null}]}

We found information about the first error code ("1055784932"), that corresponded to several connections in one file with different case-sensitive names. We corrected this error and now the file is refreshing correctly most of the time (previously always failed). 

We haven't found any information about the second error code ("1055784934"). 

 

A couple of Power BI refresh processes executed at the same time that the some dimensions and cubes were processing. However, the processed cubes are not used in the report (maybe some common dimensions). 

 

Is there any error code guide we can refer to? Is it necessary to raise a ticket with Microsoft? Has anyone seen these errors before?

 

Regards! 

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.