While Posting MIGO Getting error

[Former Member]

Hi Friends,

While Posting the Goods Reciepts in Tcode MIGO for the POs

in some cases i am getting an Express Dump.

I am not able to find the exact reason,

Please find the Exception occurred (taken from ST22).

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

in

procedure "MB_POST_DOCUMENT" "(FUNCTION)", nor was it propagated by a RAISING

clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is 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.)

How to correct the error

Use an ABAP/4 Open SQL array insert only if you are sure that none of

the records passed already exists in the database.

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"SAPSQL_ARRAY_INSERT_DUPREC" "CX_SY_OPEN_SQL_DB"

"SAPLMBMB" or "LMBMBU04"

"MB_POST_DOCUMENT"

Now how can i proceed furhtur to correct that error

Thanks in Advance,

Ganesh

[kesavadas_thekkillath]

Check the source code extract.

Does this happen from any Z developments.

Its because of duplicate record insertion.

[Former Member]

Hi Kesavadas,

I also getting the same error but still i am not able to solve this issue, and there is no z developments

Can any one give me a solution for this issue..

[Former Member]

Hi Srinivasan ,

The ST22 Short dump because of Duplicate number Insertion .

So please check the number ranges of Material document ..!