1624636 - BPC 10 NW Short Dump ITAB_DUPLICATE_KEY when creating a new report in BPC Excel Client

Symptom

When creating a new report in BPC Excel Client the following dump appears.

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> 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://gblonnw16.bluefinsolutions.com:8000/sap/bpc/query/TJC_RESOURCE2/ResourcePlan was not called due to an error. </p> </td> </tr> <tr> <td>   </td> </tr> <tr> <td class="emphasize"> <strong> Note: </strong> <br> <ul> <li> The following error occurred in system <% =SYSYSID%> : <b> There is already a line with the same key. </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: WEB_CONVERT_SYMDIM_AXISDIM of program CL_UJO_QUERY_BASE=============CP<BR>Method: WEB_RUN_AXIS_QUERY_SYMM of program CL_UJO_QUERY_BASE=============CP<BR>Method: IF_UJO_QUERY~RUN_AXIS_QUERY_WEB of program CL_UJO_QUERY_BASE=============CP<BR>Method: RUN_AXIS_QUERY of program CL_UJXO_QUERY_READ============CP<BR>Method: DO_POST of program CL_UJXO_QUERY=================CP<BR>Method: HANDLE_REQUEST of program CL_BPC_REST_RES===============CP<BR>Method: /POA/IF_REST_RESOURCE_2~POST of program CL_BPC_REST_RES===============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 PC1 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 gblonnw16_PC1_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 6 in transaction ST11 on the application server gblonnw16_PC1_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 class="note"> Error code: ICF-IE-http -c: 200 -u: TCOLGATE -l: <% =SYLANGU%> -s: PC1 -i: <% =INSTANCEID%> -w: 6 -d: 20110818 -t: 122027 -v: RABAX_STATE -e: ITAB_DUPLICATE_KEY -X: 000C29FA7AC01ED0B2B18258CEACB277_000C29FA7AC01ED0B2B18258C9CAB277_1 -x: 128CC9E075C6F16B9277000C29FA7AC0 </p> <br/> <p> HTTP 500 - Internal Server Error <br/> <p> Your SAP Internet Communication Framework Team </p> </td> </tr> </table> </body> </html>

At the back-end the following short dump can be found

Category ABAP Programming Error
Runtime Errors ITAB_DUPLICATE_KEY
ABAP Program CL_UJO_QUERY_BASE=============CP
Application Component EPM-BPC-NW

Short text
There is already a line with the same key.

What happened?
Error in the ABAP application program.
The current ABAP program "CL_UJO_QUERY_BASE=============CP" had to be interrupted because it contains
a statement that cannot be executed.

Source Code Extract
i_appset_id = if_ujo_query~d_appset_id
i_application_id = if_ujo_query~d_appl_id
i_dimension_id = ls_symm_dim-name ).
IF lo_md_reader IS NOT INITIAL AND lo_md_query IS NOT INITIAL.
lo_md_query->set_sel_attr( lt_attr ).
lo_md_query->set_sel_members( lt_mem_name ).
lo_md_reader->read(
EXPORTING io_read_opt = lo_md_query
IMPORTING er_data = l_data ).
ENDIF.
CATCH cx_uj_static_check INTO lx_exp.
RAISE EXCEPTION TYPE cx_ujo_read
EXPORTING
previous = lx_exp.
ENDTRY.
"render result
FIELD-SYMBOLS: <lt_member> TYPE STANDARD TABLE.
IF l_data IS NOT INITIAL.
ASSIGN l_data->* TO <lt_member>.
INSERT LINES OF <lt_member> INTO TABLE lth_mem_desc.
CLEAR lt_symm_out_mems.
LOOP AT lt_symm_out_mems_det ASSIGNING <ls_mem>.
CLEAR ls_mem_simple.
MOVE-CORRESPONDING <ls_mem> TO ls_mem_simple.
APPEND ls_mem_simple TO lt_symm_out_mems.
<ls_mem>-displayname = <ls_mem>-member.
READ TABLE lth_mem_desc ASSIGNING <ls_mem_desc> WITH TABLE KEY id = <ls_mem>-membe
IF sy-subrc = 0.
IF <ls_mem_desc>-description <> ''.
<ls_mem>-displayname = <ls_mem_desc>-description.
ENDIF.
IF ls_symm_dim-name EQ 'MEASURES'.
<ls_mem>-is_calc = abap_false.
ELSE.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver

Product

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver

Keywords

duplicate, error, members, report, cannot, dump, BPC, 10, SBOP PC. , KBA , 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.