SRM Dump SAPSQL_ARRAY_INSERT_DUPREC

[Former Member]

Hi All,

We are experiencing an SRM 7 dump as per below details. The update failure is also visible in SM13.

The dump causes DB update termination in SM13 and ST22 with below duplicate error.

I have implemented SAP note 0001685125 but looks like it will only resolve failure on update module BBP_PDatt_DB_UPDATE.

Notes 1667379 & 0001573235 are obsolete and dealing with the problem on modules; BBP_ITEMLIST_DB_UPDATE, BBP_HEADER_DB_UPDATE, BBP_PDBUP_DB_UPDATE where the problem is still occurring.

Category:                     ABAP Programming Error

Runtime Errors:            SAPSQL_ARRAY_INSERT_DUPREC

Except:                        CX_SY_OPEN_SQL_DBABAP

Program                       SAPLBBP_PDIAD

Application Component  SRM-EBP

Date and Time               04.09.2012 17:09:52

Short text   

The ABAP/4 Open SQL array insert results in duplicate database records.

What happened?   

Error in the ABAP Application Program    

The current ABAP program "SAPLBBP_PDIAD" had to be terminated because it has come across a statement that unfortunately cannot be executed.

Error analysis An exception occurred that is explained in detail below.   

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught in procedure "BBP_ITEMLIST_DB_UPDATE" "(FUNCTION)", nor was it propagated by a RAISING clause.   

Since the caller of the procedure could not have anticipated that the exception would occur, the current program is terminated.   

The reason for the exception is: If you use an ABAP/4 Open SQL array insert to insert a record in the database and that record already exists with the same key, this results in a termination.

How to correct the error

Use an ABAP/4 Open SQL array insert only if you are sure that none of the records passed already exists in the database.    

If the error occures in a non-modified SAP program, you may be able to find an interim solution in an SAP Note.   

If you have access to SAP Notes, carry out a search with the following keywords:    

"SAPSQL_ARRAY_INSERT_DUPREC" "CX_SY_OPEN_SQL_DB"   

"SAPLBBP_PDIAD" or "LBBP_PDIADU08"   

"BBP_ITEMLIST_DB_UPDATE"

[former_member212854]

Hi Mike,

This error occurs when you try to update the database table with a duplicate record which already exists in the database.

Could you please tell me on what transaction are you facing this error ?

regards,

Ashwin.

[Former Member]

Hi Ashwin,

Thanks for the prompt response.

The problem occurs when an SRM PO gets approved automatically through the Process Controlled Workflow in SRM 7. At the end of the automatic approval the system updates the database as per update modules mentioned above but those updates sometimes fail. I did not place this on the workflow forum because I thought the failure is on the update modules as per above mentioned notes.

I also confirmed with the functional team and they said they did not change any number ranges. The dumps only started happening on Monday 27/08/2012.

Kind regards,

Michael.