Express Document "Update was terminated"

[former_member187989]

Dear all,

On saving sales order document getting saved with message

"Express Document "Update was terminated"

On analyzine error in ST22 it shows error message as below

Runtime Errors         SAPSQL_ARRAY_INSERT_DUPREC
Exception                 CX_SY_OPEN_SQL_DB

Error analysis
    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 "SD_PARTNER_UPDATE" "(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.)

This happened after moving transport request(new configuration with scrap sales & free sample) to production client.

New configuration throughly tested ok in developement & quality clients.

Note : Order number range is maintained earlier according to plant.

What may be cause of this error ? How to resolve this issue ?

Thanks & Regards,

A.Jeyakanthan.

[Shiva_Ram · Accepted solution]

Is the sales order created with reference to any other document like contract or quotation? If so, then refer OSS Note 154766 - Update termination in VBPA when you create with reference. You may also check OSS Note 663828 - Contract: Dump SAPSQL_ARRAY_INSERT_DUPREC II.

You have not mentioned about the SAP version, which is causing this error.

Another suggestion would be if possible, re-transporting the requests from test system to production system and test.

Regards,

[former_member187989 · Accepted solution]

Is the sales order created with reference to any other document like contract or quotation?

No,sales order is base document.

You have not mentioned about the SAP version, which is causing this error.

SAP ECC 6.0 Level 0014

[former_member187989]

Thanks for replies.

[former_member187989]

Issue is resolved now,actually problem is (sales order number range which clash with existing

number range for other sales documents) with new order type internal no. range assignment in VOV8.

Before moving transport request we should create new number range for new order types.

Edited by: Jeyakanthan A on Feb 9, 2011 10:24 AM

[Lakshmipathi]

Check Note 1412609 - DUPREQ when configuring the transport domain

thanks

G. Lakshmipathi