SAP Knowledge Base Article - Preview

1820002 - BPC: Exception: ExecuteScalar requires an open and available Connection

Symptom

When launching the SAP Planning and Consolidation (BPC) web page, the following error is displayed:

Server Error in '/OSoft' Application. (Server Error in '/SAP/BPC/WEB' Application for BPC MS 10.0)
________________________________________
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.Exception: 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:

[Exception: ExecuteScalar requires an open and available Connection.
The connection's current state is closed.]
    Microsoft.VisualBasic.CompilerServices.Container.InvokeMethod(Method
TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags
Flags) +199 Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object
Instance, Type Type, String MemberName, Object[] Arguments, String[]
ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack) +443 OSoft.Consumers.ZFP.WebBase.Utility.GetLastUserApp(CPMUser& mUser,
String strAppServerURL, String strSecurity, String strContext, Boolean
bServerPathReset) +1419
    OSoft.Consumers.ZFP.WebBase.PageBase.Page_Init(Object sender,
EventArgs e) +1906
    System.EventHandler.Invoke(Object sender, EventArgs e) +0
    System.Web.UI.Control.OnInit(EventArgs e) +99 System.Web.UI.Page.OnInit(EventArgs e) +12
    OSoft.Consumers.ZFP.WebBase.PageBase.OnInit(EventArgs e) +12 System.Web.UI.Control.InitRecursive(Control namingContainer) +333 System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+378


Read more...

Environment

  • SAP Business Planning and Consolidation for Microsoft 7.X SPXX
  • SAP Business Planning and Consolidation for Microsoft 10.0 SPXX

Product

SAP Business Planning and Consolidation 10.0, version for Microsoft ; SAP Business Planning and Consolidation 5.0, version for Microsoft ; SAP Business Planning and Consolidation 5.1, version for Microsoft ; SAP Business Planning and Consolidation 7.0, version for Microsoft ; SAP Business Planning and Consolidation 7.5, version for Microsoft ; SAP BusinessObjects Planning and Consolidation 5.0, version for Microsoft

Keywords

executescalar requires an open and available connection. the connection's current state is closed, Server Error in '/SAP/BPC/WEB' Application, ExecuteScalar , 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.