Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

RunTime Error SAPSQL_ARRAY_INSERT_DUPREC

Hi,

After we have made a client copy from our production to our quality system which we use to test our customizing and developments, we are having a trouble on our quality system when we run transactions VA01 and VL01N because when the system is making updates to the database records we get a message like this:

SAPoffice express info

Express document "Update was terminated" recieved from author "<USERNAME>"

Then when we check the updates on transaction SM13 we see these errors:

When using transaction VA01

Function Module RV_SALES_DOCUMENT_ADD

Status Update was terminated

Report LV45VF0V

Row 1,784

Error details: Class:00 Number:671

00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

When I check the ABAP short dump log I get this information

Client.............. 020

User................ "AURBINA"

Language key........ "S"

Transaction......... "VA01 "

Program............. "SAPLV45V"

Screen.............. "RSM13000 3000"

Screen line......... 2

And the line where I got the error is this:

Information on where terminated

The termination occurred in the ABAP program "SAPLV45V" in "VBUK_BEARBEITEN".

The main program was "RSM13000 ".

1780 UPDATE VBUK FROM TABLE DA_XVBUKU.

1781 IF SY-SUBRC > 0.

1782 MESSAGE A101 WITH 'VBUK' SY-SUBRC DA_XVBUKU-STRU-VBELN.

1783 ENDIF.

>>>>> INSERT VBUK FROM TABLE DA_XVBUKI.

1785 IF SY-SUBRC > 0.

1786 MESSAGE A100 WITH 'VBUK' SY-SUBRC DA_XVBUKI-STRU-VBELN.

1787 ENDIF.

And when using transaction VL01N

Function Module RV_DELIVERIES_SAVE

Status Update was terminated

Report LV45VF0V

Row 1,784

Error details: Class:00 Number:671

00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

When I check the ABAP short dump log I get this information

Client.............. 020

User................ "AURBINA"

Language key........ "E"

Transaction......... "VL01N "

Program............. "SAPLV45V"

Screen.............. "RSM13000 3000"

Screen line......... 2

And the line where I got the error is this:

The termination occurred in the ABAP program "SAPLV45V" in "VBUK_BEARBEITEN".

The main program was "RSM13000 ".

1780 UPDATE VBUK FROM TABLE DA_XVBUKU.

1781 IF SY-SUBRC > 0.

1782 MESSAGE A101 WITH 'VBUK' SY-SUBRC DA_XVBUKU-STRU-VBELN.

1783 ENDIF.

>>>>> INSERT VBUK FROM TABLE DA_XVBUKI.

1785 IF SY-SUBRC > 0.

1786 MESSAGE A100 WITH 'VBUK' SY-SUBRC DA_XVBUKI-STRU-VBELN.

1787 ENDIF.

Can someone please help me and advice what to do in this case? We have stopped all of our transports from DEV to QA in order to fix this problem first and we have a new module implementation in process.

Best Regards,

Erik Espinosa

Former Member
Former Member replied

After you compare the highest number in table VBUK (as Jurgen has said) you can adjust the sales order number range and update the current number with the highest number in vbuk plus 1 (or plus 100 for security reasons).

Best regards,

Paulo Café

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question