SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Problem during Partner replication CRM -> ISU - Dump SAPSQL_ARRAY_INSERT_DUPREC

Former Member

‎2013 Jun 11 9:10 AM

0 Kudos
139

Hello guys

We are faced to a problem since our ECC6 migration. Indeed, some BDOCS of partner replication are falling in error because of the dump SAPSQL_ARRAY_INSERT_DUPREC. The function BUPA_MAP_SAVE_CUST_TABS is falling in error on this statement

IF NOT IT_CUST_INSERT[] IS INITIAL.

  INSERT CRMKUNNR FROM TABLE IT_CUST_INSERT[].

ENDIF.

That is strange is that when we are reprocessing this BDOC, it will process successfully.

I have checked the number range in CRM and ISU environments and the customization is OK (number ranges are defined as external in ISU system)

Last thing : this problem is random -> Sometimes it's working, sometimes not...

Has anybody been faced to this kind of problem ? Does someone know how to solve this issue ?

Thanks a lot for your help

1 REPLY 1

AmlanBanerjee
Active Contributor

‎2013 Jun 12 3:21 AM

0 Kudos
80

Hi Vincent,

From the error that you are getting, I think that the system is unable to create the Business partner no. in IS-U.

I think is that the BP's for which you are getting this error are already created in IS-U system.So you are getting this dump SAPSQL_ARRAY_INSERT_DUPREC

If that is the issue, I would suggest you to check what is the last BP number that has been created in IS-U with the particular no. range.

Once you find that out, set that a the current number of the BP number range interval in both IS-U and CRM and then try to re-process the BDOCs.

Hope it helps...

Thanks,

Amlan