SAP Knowledge Base Article - Preview

2228401 - BPC 10.x: ExecuteScalar requires an open and available Connection. The connection's current state is closed.

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

SAP Business Planning and Consolidation 10.1, version for Microsoft

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.