Dump:SAPSQL_ARRAY_INSERT_DUPREC in program SAPLCOM_PARTNER_DU

[Former Member]

Hello All,

In CRM service ticket-during save we are getting below dump and this dump occurs only first time and next time the save works correctly in the same ticket.

Can any one please suggest any note/fix to this issue as it looks a standard issue.

Dump details:

Category               ABAP Programming Error

Runtime Errors         SAPSQL_ARRAY_INSERT_DUPREC

Except.                CX_SY_OPEN_SQL_DB

ABAP Program           SAPLCOM_PARTNER_DU

Application Component  CRM-BF-PD

   Error in the ABAP Application Program

   The current ABAP program "SAPLCOM_PARTNER_DU" had to be termin

    has

   come across a statement that unfortunately cannot be executed.

Source code:

Function Module:COM_PARTNER_UPDATE_DU

   55   FIELD-SYMBOLS: <values>           TYPE ANY,

   56                  <address>          TYPE crmt_partner_address,

   57                  <fs_insert_record> TYPE crmd_partner,

   58                  <fs_addr_ref_data> TYPE crmt_partner_address_reference.

   59

   60   FIELD-SYMBOLS: <wa_to_proceed>    TYPE ANY,

   61                  <table_to_proceed> TYPE ANY TABLE.

   62

   63   DATA: wa_to_proceed TYPE REF TO data.

   64   DATA: lt_wa_table   TYPE REF TO data.

   65

   66 *** MAINTAIN PARTNER RECORDS *******************************************

   67

   68 ***   records to insert

   69   IF NOT it_partner_records_to_insert IS INITIAL.

   70

>>>>>     INSERT crmd_partner FROM TABLE it_partner_records_to_insert.

   72     IF sy-subrc NE 0.

   73       MESSAGE a002(com_partner) WITH gc_object_name_partner.

   74     ENDIF.

   75

   76   ENDIF.

Thank you in Advacne,

Best Regards,

Karthik

[kapilpatil]

Hello Karthik,

How is the service ticket created in your scenario? Is there a custom development (UI or API or BADI) for service ticket ?

Thanks,

Kapil

[Former Member]

Hello Kapil,

The service ticket is created by email by ERMS. Currently i see there is no custom development done.

Thank you,

Best Regards,

Karthik

[kapilpatil]

As mentioned by you there is no custom development,

I would advise you to put a break point in FM order maintain, check the partners in the import parameter if there are any duplicates.

I hope this helps.

Thanks,

Kapil