0

I have a SQL Job that processes some data to be loaded into an Analysis Cube. When the Job is run is fails with the following message:

Message
Executed as user: NT Service\SQLSERVERAGENT. ...mlns="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="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft SQL Server 2017 Analysis Services" HelpFile="" />
<Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001." Source="Microsoft SQL Server 2017 Analysis Services" HelpFile="" /><Error ErrorCode="3239182436" Description="Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DS_Finance', Name of 'DS_Finance'." Source="Microsoft SQL Server 2017 Analysis Services" HelpFile="" />
<Error ErrorCode="3240034316" Description="Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'FilterVAT', Name of 'FilterVAT' was being processed." Source="Microsoft SQL Server 2017 Analysis Services" HelpFile="" />
<Error ErrorCode="3240034317" Description="Errors in the OLAP storage engine: An error occurred while the 'DataSource' attribute of the 'FilterVAT' dimension from the 'coreCubes_Finance_IASB' database was being processed." Source="Microsoft SQL Server 2017 Analysis Services" HelpFile="" />
<Error ErrorCode="3239837702" Description="Server: The current operation was cancelled because another operation in the transaction failed." Source="Microsoft SQL Server 2017 Analysis Services" HelpFile="" /><Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001." Source="Microsoft SQL Server 2017 Analysis Services" HelpFile="" />
<Error ErrorCode="3239182436" Description="Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DS_Finance', Name of 'DS_Finance'." Source="Microsoft SQL Server 2017 Analysis Services" HelpFile="" />
<Error ErrorCode="3240034316" Description="Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'FilterVAT', Name of 'FilterVAT' was being processed." Source="Microsoft SQL Server 2017 Analysis Services" HelpFile="" />
<Error ErrorCode="3240034317" Description="Errors in the OLAP storage engine: An error occurred while the 'DocNum' attribute of the 'FilterVAT' dimension from the 'coreCubes_Finance_IASB' database was being processed." Source="Microsoft SQL Server 2017 Analysis Services" HelpFile="" />
<Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [53]. ; 08001." Source="Microsoft SQL Server 2017 Analysis Services" HelpFile="" />
<Er...  The step failed.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.