SAP Knowledge Base Article - Preview

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


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 was not called due to an error. </p> </td> </tr> <tr> <td> &nbsp; </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> &nbsp; </td> </tr> <tr> <td> <p> &nbsp; </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

Date and Time          18.08.2011 07:50:09





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 ).






              EXPORTING io_read_opt = lo_md_query


              IMPORTING er_data = l_data






        CATCH cx_uj_static_check INTO lx_exp.


          RAISE EXCEPTION TYPE cx_ujo_read




              previous = lx_exp.






      "render result






      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.






            IF ls_symm_dim-name EQ 'MEASURES'.


              <ls_mem>-is_calc = abap_false.







  • SAP Business Planning and Consolidation (BPC) version 10 for the NetWeaver (NW) platform - server and client.


SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver


duplicate, error, members, report, cannot, dump, BPC, 10, SBOP PC. , KBA , EPM-BPC-NW-XLS , Report on EPM-XLS* , 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.