Regarding update was terminated

[Former Member]

Hi,

While doing PGI I am getting the error express document " update was terminated" received from author......

Also the document flow is not getting updated after PGi & stock is not getting reduced from the Unrestricted use when checked in MMBE.

Also we have checked in the ST22 for error analysiss we got the below message

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.)

Regards,

Tushar

[Former Member · Accepted solution]

Hi,

This error is occurs most of time when there is number range conflict.

Example - You already created some document say delivery document in system 1 to 100 now next number is 101

But Now you reset this number range and try to create delivery and save then system will give this error.

because number 1 is already in database.

So check all number ranges, and also take help of ABAPer and Basis to veryfiy from there side.

kapil

[Former Member · Accepted solution]

is it possible to reassign the old number ranges again so that we can continue the functioning of the process, any solution for this

[Former Member · Accepted solution]

Hi,

I am not sure,

I think we have to archive documents first,then can be able to reuse numbers.

kapil

[Lakshmipathi · Accepted solution]

I think this is possible if you know the original delivery reference. Execute VL01N where on top, you can see the delivery reference field as blank. Before posting the goods issue, key in that delivery reference here and then try. It should work.

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Hi,

Thank u laxmipathi & kapildev error solved

problem was in materia document number range now we have assigned the new number ranges In T- Code OMBT Now system working fine.

thank u for your valuable help

Regards,

Tushar