SAP Knowledge Base Article - Preview

1903917 - BPC: MSAS Query Timeout Expired and Operation Canceled errors in msmdsrv.log file

Symptom

In BPC some data is not appearing correctly in reports. Values which should have been modified by the execution of logic (e.g. Execute Formulas package, Default Formulas package, or by otherwise running script logic) do not appear as the correct values. It appears that the logic has not been run.

The following type of information is found in the 'msmdsrv.log' file:

Message: OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00. (Source: \\?\C:\MSSQLServer\MSAS10_50.MSSQLSERVER\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210003)
Message: OLE DB error: OLE DB or ODBC error: Operation canceled; HY008. (Source: \\?\D:\MSSQLServer\MSAS10_50.MSSQLSERVER\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210003)

[System Name] : OLAPServerHandler
[Message Type] : ErrorMessage
[Job Name] : Olap9Manager : CopyOlapDB
[Exception]
DetailMsg : {Microsoft.AnalysisServices.OperationException: 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; TCP Provider: No connection could be made because the target machine actively refused it.
; 08001.


Read more...

Environment

  • SAP Business Planing and Consolidation, version for Microsoft

Product

SAP Business Planning and Consolidation 10.0, version for Microsoft ; SAP Business Planning and Consolidation 10.1, version for Microsoft

Keywords

query,timeout,exceeded,expired,cancelled,canceled,MSAS,SSAS,SQL Server,Analysis Services,Analysis Server,OLAP , KBA , EPM-BPC-MS , Microsoft Version , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.