cancel
Showing results for 
Search instead for 
Did you mean: 

Dump while executing rate ISU - SAPSQL_ARRAY_INSERT_DUPREC

former_member768137
Discoverer
0 Kudos

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 .

Accepted Solutions (1)

Accepted Solutions (1)

PieterB
Explorer
0 Kudos

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
Discoverer
0 Kudos

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

Answers (1)

Answers (1)

srinivasankh
Contributor
0 Kudos

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
Discoverer
0 Kudos

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.