cancel
Showing results for 
Search instead for 
Did you mean: 

Archive inspection plan error : SAPSQL_ARRAY_INSERT_DUPREC

Former Member
0 Kudos

Hi everybody,

I have configured archiving SARA for object QM_PLAN to archive our inspection plan. This configuration is run well when we archive a limited number of inspection plans less than 10.000.

But we encounter error when we archive inspection plan more than 10.000 (let say 30.000) with the error message SAPSQL_ARRAY_INSERT_DUPREC when inserting record into table ADMI_VARIA refering the abap dump log like below :

====================================================

008830 IF sy-subrc IS INITIAL. " LOOP was entered at least once

-


> INSERT admi_varia FROM TABLE lt_admi_varia.

008850 IF NOT sy-subrc IS INITIAL

008860 AND sy-batch IS NOT INITIAL.

008870 MESSAGE s244.

008880 ENDIF.

008890 ENDIF.

=====================================================

Any help to solve this problem would be very appreciate

best regards,

nsa

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Nursaid,

Please check the following note:

Note 831989 - Measurement documents: program termination when archiving

The note should solve your problem

Rergards,

Ammey Kesarkar

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Nursaid,

This dump occurs commonly when there is an overflow in terms number of records that can be inserted in a table in a single go.

And Ammey´s observation hits the nail on thee coffin.

Can you give details like the report name or the include name where this error is coming.

Regards.

Ruchit.

Message was edited by:

Ruchit Khushu

Former Member
0 Kudos

Hi All,

Thanks for your quick reply.

Ammey, I have asked my abaper to investigate this table whether we can do something for the solution or not. And for the note 831989, we have implemented this note but didn't solve the problem.

Ruchit, here are the program and include where this problem is hapened :

main program = RCPREWR1

include = LARCHF01

Meanwhile, I asked my developer to copy the program and make some modification on this. And create new archive object for this new program, and we'll try to archive the same number of inspection plan.

I'll let you know the result then.

Thanks,

nsa

Former Member
0 Kudos

Hello Nursaid,

I explored the table ADMI_VARIA and noticed:

The field SEQUENCE (RKZ_RECNR) is of data type NUMC with maximum of 4 characters.

This means that it can hold values from 0000 to 9999 (i.e. 10,000 records)

I 'think' the contains of the table ADMIN_VARIA must be refreshed before it exceeds 10,000 records. (Please consult with an ABAP developer)

***Please note: The above I 'assume' this could be the problem

Regards,

Ammey Kesarkar