cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with EPM add in - refresh button throwing an error

former_member244687
Participant
0 Kudos

Hi Experts

I have an issue with my refresh function in EPM Addin, The current version is BPC 10.0 SP27 Patch 2 .NET4 ,

My vba code is

Sub Refresh()

Dim ACC As New EPMAddInAutomation ACC.RefreshActiveSheet

End Sub

DETAILS :

One or more errors occurred. The execution of report Default Report failed. Please contact your administrator. Internal Server Error

<!DOCTYPE html PUBLIC"-//W3C//DTD HTML 4.01Transitional//EN"> <html> <head> <title> 500 Internal Server Error </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> Error when processing your request </h1> <br> <h2> What has happened? </h2> <p> The URL http://ppnopp.ss.net:8000/sap/bpc/query/INDIANA/PP was not called due to an error. </p> </td> </tr> <tr> <td> </td> </tr> <tr> <td> <strong> Note: </strong> <br> <ul> <li> The following error occurred in system <% =SYSYSID%> : <b> SQL error 1654 while accessing table RSDDSTATINFO. </b> </li> </ul> <ul> <li> The error occurred on the application server <% =INSTANCEID%> and in the work process <% =WORKPROCESSID%> . </li> </ul> <ul> <li> The termination type was: RABAX_STATE </li> </ul> <ul> <li> The ABAP call stack was: <br> Method: __INSERT_INFO of program CL_RSDD_STATOLAP==============CP<BR>Method: _INSERT_EVDATA_DB of program CL_RSDD_STATOLAP==============CP<BR>Method: STA_NEW_EVENT_END of program CL_RSDD_STATOLAP==============CP<BR>Method: _STAT_EVENT_RSDRI_END of program CL_RSDRI_INFOPROV=============CP<BR>Method: READ of program CL_RSDRI_INFOPROV=============CP<BR>Function: RSDRI_INFOPROV_READ of program SAPLRSDRI<BR>Method: RUN_RSDRI_QUERY_CORE of program CL_UJO_QUERY_BASE=============CP<BR>Method: IF_UJO_QUERY~RUN_RSDRI_QUERY of program CL_UJO_QUERY_BASE=============CP<BR>Method: TRY_RSDRI_QUERY of program CL_UJO_QUERY_BASE=============CP<BR>Method: RUN_SIMPLE_SYMM_AXIS_QUERY of program CL_UJO_QUERY_BASE=============CP<BR> </li> </ul> </td> </tr> <tr> <td> </td> </tr> <tr> <td> <p> </p> <h2> What can I do? </h2> <ul> <li> If the termination type was RABAX_STATE, you can find more information about the cause of termination insystem QB1 in transaction ST22. </li> </ul> <ul> <li> If the termination type was ABORT_MESSAGE_STATE, you can find more information about the cause of termination on the application server snuspq04_QB1_00 in transaction SM21. </li> </ul> <ul> <li> If the termination type was ERROR_MESSAGE_STATE, you can find more information in the trace file for the work process 12 in transaction ST11 on the application server snuspq04_QB1_00 . In some situations, you may also need to analyze the trace files of other work processes. </li> </ul> <ul> <li> If you do not yet have a user ID, contact your system administrator. </li> </ul> <br/> <p> Error code: ICF-IE-http -c: 142 -u: NDALV84 -l: <% =SYLANGU%> -s: QB1 -i: <% =INSTANCEID%> -w: 12 -d: 20180102 -t: 111626 -v: RABAX_STATE -e: DBIF_RSQL_SQL_ERROR -X: C9996E4387C41ED7BBF2A7309637100D_C9996E4387C41ED7BBF2A73092C4900C_1 -x: 5A4AD197147F38B5E10000000A80331C </p> <br/> <p> HTTP 500 - Internal Server Error <br/> <p> Your SAP Internet Communication Framework Team </p> </td> </tr> </table> </body> </html>

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

You are using absolutely outdated SP for both BPC and BW. Upgrade is required. I remember the same issues 5 years ago (solved by upgrade).

Answers (4)

Answers (4)

former_member244687
Participant
0 Kudos

Please find - SAP_BW - 730 - 0009 - SAPKW73009SAP - Business Warehouse

thanks

former_member186338
Active Contributor
0 Kudos

Sorry, but looks like you don't read my requests!

What is your BPC SP?

former_member244687
Participant
0 Kudos

HI Vadim

Please find the full components

former_member244687
Participant
0 Kudos
Thanks Vadim..BW 7.3 and BPC 10.0
former_member186338
Active Contributor
0 Kudos

Not only version but SP also!

former_member244687
Participant
0 Kudos

No I am getting the same error, even when I use the refresh button. The refresh action is not working

former_member186338
Active Contributor
0 Kudos

Then VBA has no relation to the issue! Check you model and environment, are you able to refresh other reports?

former_member186338
Active Contributor
0 Kudos

P.S. Provide bpc and BW version and SP.

former_member186338
Active Contributor
0 Kudos

P.P.S. I am not talking about EPM version!!!

former_member186338
Active Contributor
0 Kudos

Can you refresh the same report using standard refresh button instead of VBA?