Start a new topic

EPM: Error "Object reference not set to an instance of an object"

Symptom:

When attempting to open an existing connection or creating a new connection in the EPM Add-in, the following error is displayed:

"Object reference not set to an instance of an object".


Reproducing the Issue:

- Launch Microsoft Excel.
- In the EPM tab, select Log On and select an existing connection or create a new one.
- The error message is displayed.


The following errors are collected in the tbllogs table:

 

==============[System Error Tracing]==============

[System  Name] : /SAP/BPC/Appsets.svc

[Message Type] : ErrorMessage

[Job Name]     : GetAppsets

[DateTime]     : 05/05/2016 10:57:25

[UserId]       : BPC10SQL12\bpc_sysadmin

[Exception] 

    DetailMsg  : {System.NullReferenceException: Object reference not set to an instance of an object.

   at SAP.BPC.Services.Webservice.Security.CheckAccessSecurity(String appsetName, String applicationName, Boolean withApplications)

   at SAP.BPC.Services.Webservice.Appsets.GetAppsets(Int32 level)}

==============[System Error Tracing  End ]==============

 

 

==============[System Exception Tracing]==============

[System  Name] : /SAP/BPC/Appsets.svc

[Message Type] : ErrorMessage

[Job Name]     : CheckAccessSecurity

[DateTime]     : 05/05/2016 10:57:25

[UserId]       : BPC10SQL12\bpc_sysadmin

[Exception] 

    DetailMsg  : {You are not authorized to access this system; contact your system administrator(UserID: [BPC10SQL12\bpc_sysadmin], Appset: [], Application: [])}

==============[System Exception Tracing  End ]==============

 

 

==============[System Exception Tracing]==============

[System  Name] : CacheManager

[Message Type] : ErrorMessage

[Job Name]     : AppsetAccess.GetDataFromCache()

[DateTime]     : 05/05/2016 10:57:25

[UserId]       : BPC10SQL12\BPC_SYSADMIN

[Exception] 

    DetailMsg  : {The output data(AppsetAccess) is nothing: appsetName:ENVIRONMENTSHELL}

==============[System Exception Tracing  End ]==============

 

 

==============[System Error Tracing]==============

[System  Name] : CacheManager

[Message Type] : ErrorMessage

[Job Name]     : AppsetAccess.GetDataFromCache()

[DateTime]     : 05/05/2016 10:57:25

[UserId]       : BPC10SQL12\BPC_SYSADMIN

[SqlException] 

    Type      : System.Data.SqlClient.SqlException

    Errors    : System.Data.SqlClient.SqlErrorCollection

    Class     : 16

    LineNumber: 1

    Message   : {Invalid object name 'ENVIRONMENTSHELL.dbo.tblAppAccess'.}

    Number    : 208

    Procedure : 

    Server    : BPC10SQL12

    State     : 1

    Source    : .Net SqlClient Data Provider

    TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean)

    HelpLink  : 

==============[System Error Tracing  End ]==============

 

 

==============[System Error Tracing]==============

[System  Name] : CacheManager

[Message Type] : ErrorMessage

[Job Name]     : AppsetAccess.GetDataFromDatabase()

[DateTime]     : 05/05/2016 10:57:25

[UserId]       : BPC10SQL12\bpc_sysadmin

[SqlException] 

    Type      : System.Data.SqlClient.SqlException

    Errors    : System.Data.SqlClient.SqlErrorCollection

    Class     : 16

    LineNumber: 1

    Message   : {Invalid object name 'ENVIRONMENTSHELL.dbo.tblAppAccess'.}

    Number    : 208

    Procedure : 

    Server    : BPC10SQL12

    State     : 1

    Source    : .Net SqlClient Data Provider

    TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean)

    HelpLink  : 

==============[System Error Tracing  End ]==============

 

 

==============[System Error Tracing]==============

[System  Name] : CacheManager

[Message Type] : ErrorMessage

[Job Name]     : AppsetAccess.UpdateApplicationAccess()

[DateTime]     : 05/05/2016 10:57:25

[UserId]       : BPC10SQL12\bpc_sysadmin

[SqlException] 

    Type      : System.Data.SqlClient.SqlException

    Errors    : System.Data.SqlClient.SqlErrorCollection

    Class     : 16

    LineNumber: 1

    Message   : {Invalid object name 'ENVIRONMENTSHELL.dbo.tblAppAccess'.}

    Number    : 208

    Procedure : 

    Server    : BPC10SQL12

    State     : 1

    Source    : .Net SqlClient Data Provider

    TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean)

    HelpLink  : 

==============[System Error Tracing  End ]==============

 

Cause:

The EnvironmnetShell database does not exist.


Resolution:

Restore the EnvironmentShell database from backup.

 
Login or Signup to post a comment