Dump while executing rate ISU - SAPSQL_ARRAY_INSERT_DUPREC

[former_member768137]

Hi guys,

We are using SAP_BASIS 731 release

SAP_APPL 606 release

IS-UT 606 release

While I am creating rate with variant program as QUANTI01, I am facing the dump as below while saving the rate.

Please give the solution .

[PieterB · Accepted solution]

Hello,

2 potential causes are:

1) Number range: please check the following OSS-note 1047915 - Runtime error SAPSQL_ARRAY_INSERT_DUPREC when creating rate - SAP ONE Support Launchpad

2) Due to manual manipulations in the rate tables the by the number range defined number is already existing in the table. Solution: adapt the actual number in the number range or delete the existing line (if possible)

Some months ago I had the same issue at a client of mine and this was caused by the incorrect manipulations in the tables.

Regards,

Pieter

[former_member768137 · Accepted solution]

Thank you error is resolved when I checked this note -1047915

[srinivasankh]

Hi,

Can you ensure you don’t have any custom user exits/code throughout? If no custom code then I would suggest you to raise with SAP OSS message. Another option is to debug and find out on what scenario duplicated records are getting generated.

Thanks,

Srini

[former_member768137]

No custom user exit/code exists, I do not want to raise SAP OSS message as it takes many level of approvals.

Please can you tell few scenarios where duplicate records can be generated.