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

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.

• SAP Business Planing and Consolidation, version for Microsoft

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