AX Business Intelligence/Cube troubleshooting
Posted on: May 19, 2011 | By: SuperUser Account | Microsoft Dynamics AX/365
“Cannot execute the required database operation. The SQL database has issued an error.”
When selecting ‘BI project generation options’ in AX 2009, to regenerate the SSAS project, this error message is received. There were a couple other posts on the internet for this exact error, each had a different resolution, although one was similar to this case where troubleshooting through the SQL Server and Windows Error log files helped resolve the problem.
In reviewing the SQL Server and Windows Event log files, I was able to determine the problem was records in the ‘BIUdmRoles’ table that didn’t match records in the ‘User groups’ form. For some reason this table isn’t getting updated when the ‘Update BI Data’ function on the ‘OLAP Administration’ form is run.
Through the AOT, I deleted all records in the ‘BIUdmRoles’ table that didn’t have a match in the ‘User groups’ form. Additionally, I reviewed a couple extra companies, and it appeared the data in the table and displayed on the form was consistent across companies, so it was not necessary to compare and delete for every company.