Symptom
The following error occurs in the trace file log in SAP Business Planning and Consolidation, version for Microsoft during the create OLAP database step when copying an environnment:
==============[System Error Tracing]==============
[System Name] : OLAPServerHandler
[Message Type] : ErrorMessage
[Job Name] :
[DateTime] :
[UserId] :
[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.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'AppDef', Name of 'AppDef'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of '', Name of '' was being processed.
Server: The current operation was cancelled because another operation in the transaction failed.
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. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'AppDef', Name of 'AppDef'.
Read more...
Environment
SAP Business Planning and Consoidation, version for Microsoft
Product
Keywords
error "ExecuteScalar requires an open and available Connection. The connection's current state is closed , open BPC web, BPC MS, reseult fail Olap9Manager : CopyOlapDB dynamic port {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. , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.