Urgent: Update termination: R3 4.7, Oracle 9i

[Former Member]

Hi experts,

Am facing update failures:

ST22 shows:

Runtime Errors: SAPSQL_ARRAY_INSERT_DUPREC

Exception: CX_SY_OPEN_SQL_DB

Transaction......... "MB01 "

Program............. "SAPLIEP1"

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

SM13 Details are :

Function Module: SERIALNUMBER_POST

Status: Update was terminated

Report: LIEP1U01

Row: 144

Error details: 00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Any idea . . ..

rgds

[Former Member]

Hi all,

Thanks for your resposes. . .

The problem solved and the process involved includes as follows. . .

1. Check the number range in Tx SNRO, object: EQUIP_NR

in my case :

FromNumber: 000000000010000000

ToNumber:000000000079999999

Current Number: 10096312

2. Check the last number in table EQUI table

Tx: SE16, Table: EQUI

Equipment: >= Give number (current number in above case) and finally you need to found the last entry in that table.

in my case it is 79998152

3. Solution

Go back to SNRO and edit current number as this last number (79998152) and Tonumber increase to some number I increased from 79999999 to 89999999

Rgds

[JPReyes]

To add to Ruchit's recommendation, check the update errors and do a temse consistency check.

Regards

Juan

[Former Member]

Hello Jalli,

This happens when an attempt is made to enter duplicate records. Duplicate here means re-enterinng of an entry for which the primary key already exists.

To check this please go to transaction SM13 and look for the corresponding update error. Double click on it and it will let you know the names of tables and conflicting entries.

Regards.

Ruchit.