UPDATE ERROR -"SAPSQL_ARRAY_INSERT_DUPREC" CX_SY_OPEN_SQL_DBC

[Former Member]

DEAR ALL!

I am facing the following error while posting goods issue through VL01N and stock posting through MB1C ( m.type 521 without production order ).

Table COBK is not updated wile doing those trasactions, this cause the runtime error.how to solve this issue?

I searched SAP notes but problem not yet solved.Kindly go through the following error and give your suggestions.

Thanks in advance.

Error analysis

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was

neither

caught nor passed along using a RAISING clause, in the procedure

"INSERT_TABLES" "(FORM)"

.

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

If you use an ABAP/4 Open SQL array insert to insert a record in

the database and that record already exists with the same key,

this results in a termination.

(With an ABAP/4 Open SQL single record insert in the same error

situation, processing does not terminate, but SY-SUBRC is set to 4.)

Sivasubramaniam,

SD consultant.

[Former Member]

Hi Siva,

I am not sure but check your number range assignment for Material doc no. it might have exhausted.

The menu path is IMG> Materials Management> Inventory Management and Physical Inventory>Number Assignment>Define Number Assignment for Material and Phys. Inv. Docs. (check for your material doc type

REWARD if it helps you!!

Regards,

Ajinkya