SAPSQL_ARRAY_INSERT_DUPREC runtime error

Updated May 18, 2018

BAPI BUPA FS CREATE FROM DATA2

Hello SAP Experts,

While creating a business partners using function module BUPA_CREATE_FROM_DATA or using the BAPI BAPI_BUPA_FS_CREATE_FROM_DATA2. The BAPI BAPI_BUPA_FS_CREATE_FROM_DATA2 also gets processed during up-gradation of IDocs of the BUPAFS_FS_CREATE_FRM_DATA2 message types. But due to the validation error in the central partner data the creation of business partner fails at first instance. Now after trying to repeat the creation of the business partner with the correct data a runtime error SAPSQL_ARRAY_INSERT_DUPREC occurs.

Comments

13 Dec 2016 5:04 pm Jyoti Pandey Helpful Answer

The error you are facing occurred because the entry already exists in the table BP001 for the business partner to be created, but an entry does not exist in the table BUT000.These invalid entries in the table BP001 are caused due to the gap in the validation logic while creating new business partners using the BAPI channel.
Therefore to solve this issue please delete all the existing invalid entries from the table BP001 using the attached report Z_DEL_BP001_WO_BUT000.

13 Dec 2016 5:05 pm Abhijeet Mudgal Helpful Answer
Please follow the instruction below in order to resolve this error:
1. Please apply the correction from SAP document 2254012.
2. Now delete the invalid entries from the table BP001 using the attached report Z_DEL_BP001_WO_BUT000.
3. After deleting the invalid entries please import the relevant support package or apply the attached corrections instructions.