Symptom
The following error is displayed when loading the Business Planning and Consolidation web page:
Server Error in '/SAP/BPC/WEB' Application. ExecuteScalar requires an open and available Connection. The connection's current state is closed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: ExecuteScalar requires an open and available Connection. The connection's current state is closed.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
Stack Trace:
[InvalidOperationException: ExecuteScalar requires an open and available Connection. The connection's current state is closed.] System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) +6664089 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +151 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +107 System.Data.SqlClient.SqlCommand.ExecuteScalar() +270 OSoft.Services.Platform.UserDataBase.SQLDataHelper.GetDataScalar(String sQuery) +249 OSoft.Services.Platform.UserDataBase.DataSwitch.GetDataScalar(CommandType commandType, String sQuery) +237 OSoft.Services.Application.AuthHelper.CMSAuthManager.GetAppSettingsFromDatabase() +1187 OSoft.Services.Application.AuthHelper.CMSAuthManager..ctor() +1921 OSoft.Services.Application.AuthHelper.CMSAuthManager.Instance() +143 BPC.Web._Default.Page_Load(Object sender, EventArgs e) +512 System.Web.UI.Control.LoadRecursive() +71 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3178 |
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18449
When attempting to establish a connection using the EPM add-in the following error is displayed:
ExecuteScalar requires an open and available Connection. The connection's current state is closed.
Read more...
Environment
- SAP Business Planning and Consolidation version 10 for Microsoft
Product
Keywords
KBA , EPM-BPC-MS , Microsoft Version , EPM-XLS , EPM Excel Client , 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.