SAP Knowledge Base Article - Preview

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.

dump.jpg

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> &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

SourceCde

 

                    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.

 

 


Read more...

Environment

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

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