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.
Version : 6.x
Component : Cube
The connection string pointing to the RiskFabric relational database data source for the RiskFabric cube does not specify an initial catalog value.
Update the connection string by following this procedure:
RiskFabric
OLAP cubeRiskFabric
relational database\<instance-name>
RiskFabric
relational database