Invalid object name during cube processing

Products

• Information Centric Analytics

Issue/Introduction

The Risk Fabric cube processing step (16) of the nightly RiskFabric Processing job fails and logs the following error message:

Executed as user: <domain>\<account>. ...lts xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults"><root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"><Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception"><Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Invalid object name 'vLDW_ActionPlanAssignedToQueueDim'., 42S02." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3240034316" Description="Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Action Plan Assigned To Queue', Name of 'Action Plan Assigned To Queue' was being processed." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3239837702" Description="Server: The current operation was cancelled because another operation in the transaction failed." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Invalid object name 'vRF_DateDim'., 42S02." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3240034316" Description="Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Configuration Issue Due Date', Name of 'Configuration Issue Due Date' was being processed." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3240034317" Description="Errors in the OLAP storage engine: An error occurred while the 'Configuration Issue Due Month' attribute of the 'Configuration Issue Due Date' dimension from the 'RiskFabric' database was being processed." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Invalid object name 'vRF_EventCharacteristicUserServiceAccountDim'., 42S02." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3240034316" Description="Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Authentication Event User Service Account', Name of 'Authentication Event User Service Account' was being processed." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Invalid object name 'vLDW_DARFileDim'., 42S02." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3240034316" Description="Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DAR File', Name of 'DAR File' was being processed." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Invalid object name 'vRF_DateDim'., 42S02." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3240034316" Description="Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Action Plan SLA Start Date', Name of 'Action Plan SLA Start Date' was being processed." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3240034317" Description="Errors in the OLAP storage engine: An error occurred while the 'Action Plan SLA Start Day Of Week' attribute of the 'Action Plan SLA Start Date' dimension from the 'RiskFabric' database was being processed." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Invalid object name 'vRF_DateDim'., 42S02." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3240034316" Description="Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Action Plan SLA Start Date', Name of 'Action Plan SLA Start Date' was being processed." Source="Microsoft An...  The step failed.

Environment

Version : 6.x

Component : Cube

Cause

The connection string pointing to the RiskFabric relational database data source for the RiskFabric cube does not specify an initial catalog value.

Resolution

Update the connection string by following this procedure:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Analysis Services server hosting the RiskFabric OLAP cube
3. In Object Explorer, navigate to Databases > RiskFabric > Data Sources
4. Right-click the RiskFabric data source and select Properties
   The Data Source Properties - RiskFabric window will open
5. Under the General heading, select the Connection String and click the ellipsis to the right of the string
   The Connection Manager window will open
6. From the Provider dropdown menu, select Microsoft OLE DB Driver for SQL Server
7. Enter the name of the server hosting SQL Server and the RiskFabric relational database
   NOTE: If the database is hosted in a named instance, specify the instance name with a trailing \<instance-name>
8. From the Initial catalog dropdown menu, select the RiskFabric relational database
9. Click the OK button to save your settings and close the Connection Manager window
10. Click the OK button to save your settings and close the Data Source Properties - RiskFabric window