Friday, March 13, 2020

EPM add-in error: 500 Internal server error

While using EPM add-in in MS Excel there is, a quite common error called 500 Internal server error that may distract a users. It is appearing right away when the user just choose connection. Thus, the user even is not connected to BPC server.

As per error log (which looks like this - see below) there is no obvious reason for that error.

2020-03-12 10:47:46,829|ERROR|BPCProxy|FPMXLClient.BPCProxy.Common.Wcf.InterceptorChannelFactory`1+InterceptorRequestChannel.Request||||||19|The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Negotiate'.#

2020-03-12 10:47:51,252|ERROR|BPC10Connection|FPMXLClient.Connection.RESTConnection.LoadDimensions||||||VSTA_Main|An error has occured on the server#

2020-03-12 10:47:51,342|ERROR|BPC10Connection|FPMXLClient.Connection.RESTConnection.LoadMetaData||||||VSTA_Main|An error has occured on the server#
2020-03-12 10:47:51,362|ERROR|Connection|FPMXLClient.Connection.ConnectionManager.LoadMetaData||||||VSTA_Main|An error has occured on the server#

2020-03-12 10:47:51,631|ERROR|BPCProxy|FPMXLClient.BPCProxy.Session.SessionServiceHelper.Logoff||||||VSTA_Main|<!DOCTYPE html PUBLIC"-//W3C//DTD HTML 4.01Transitional//EN"><html><head><title> Logoff Message </title><META http-equiv="Content-Type" content="text/html;charset=UTF-8"><style type="text/css"> body { font-family:tahoma,helvetica,sans-serif;color:#333333;background-color:#FFFFFF; }td { font-family:tahoma,helvetica,sans-serif;font-size:70%;color:#333333; }h1 { font-family:tahoma,helvetica,sans-serif;font-size:160%;font-weight:bold;margin-top:15px;margin-bottom:3px;color:#003366; }h2 { font-family:verdana,helvetica,sans-serif;font-size:120%;font-style:italic;font-weight:bold;margin-top:6px;margin-bottom:6px;color:#999900; }p { font-family:tahoma,helvetica,sans-serif;color:#333333;margin-top:4px;margin-bottom:4px; }ul { font-family:tahoma,helvetica,sans-serif;color:#333333;list-style-type:square;margin-top:8px;margin-bottom:8px; }li { font-family:tahoma,helvetica,sans-serif;color:#33333;margin-top:4px; }.emphasize { color:#333333;background-color:#C8E3FF;padding:5px;}.note { color:#CC6600; }a { font-family:tahoma,helvetica,sans-serif;text-decoration:underline;color:#336699; }a:visited { color:#001166; }a:hover { text-decoration:none; } </style></head><body><table cellpadding="0" cellspacing="0" border="0" width="100%"><tr><td><h1> Logoff </h1><br><h2> What has happened? </h2><p> You logged off from the system. </p></td></tr><tr><td> </td></tr><tr><td class="emphasize"><strong> Note </strong><br><ul><li> The logoff took place 20200312 at 094751 system time. </li><li> Close all the windows in your browser and delete the "temporary Internet files" (Internet Explorer) and "private data" (Firefox). <BR> Depending on your browser setting, this deletion of data can take place automatically when you close the browser. </td></tr><tr></tr><tr><td><p></ul><br/><p class="note"></p><p> HTTP 200 - OK <br><p> Your SAP Internet Communication Framework Team#

2020-03-12 10:47:51,646|ERROR|Connection|FPMXLClient.Connection.ConnectionManager.CreateConnection||||||VSTA_Main|An error has occured on the server#

2020-03-12 10:48:49,726|ERROR|BPCProxy|FPMXLClient.BPCProxy.Common.Wcf.InterceptorChannelFactory`1+InterceptorRequestChannel.Request||||||19|The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Negotiate'.#

It is worth to check if there is a dump related to this error – in backend in t-code ST22. Normally there is the ABAP dump which may indicate what is root cause of the error. In this case, there is related to error in the hierarchy. In the details of the dump there is even BPC dimension tech name and hierarchy ID listed. The details like this lead to the error. In my case, I just needed to delete broken hierarchy.

Runtime Errors         ASSERTION_FAILED
ABAP Program           CL_UJAM_HIERARCHY_STORE=======CP
Application Component  EPM-BPC-NW-ADM
Date and Time          12.03.2020 10:00:25
Short Text
    The ASSERT condition was violated.

No comments: