SAP Knowledge Base Article - Preview

3288691 - Sales order can not be created due to DBSQL_DUPLICATE_KEY_ERROR update termination / short dump

Symptom

While creating sales order in transaction VA01, there is update termination or short dump. As shown in dump file (transaction ST22):

----------------------------------------------------------------------------------------------------
|Error analysis                                                                                    |
|    An exception has occurred which is explained in more detail below. The                        |
|    exception is assigned to class 'CX_SY_OPEN_SQL_DB' and was not caught in                      |
|     procedure                                                                                    |
|    "KONV_BEARBEITEN" "(FORM)", nor was it propagated by a RAISING clause.                        |
|    Since the caller of the procedure could not have anticipated this                             |
|    exception, the current program was terminated.                                                |
|    The reason for the exception is:                                                              |
|    When an Open SQL array insert is performed, trying to insert a record                         |
|    into the database table "KONV" causes the function to terminate if a                          |
|    record with the same key already exists.                                                      |
|                                                                                                  |
|    (When an Open SQL individual record insert is performed, this situation                       |
|    does not cause the function to terminate. SY-SUBRC is set to 4 instead.)                      |


Read more...

Environment

  • Sales And Distribution (SD)
  • Logistics Execution (LE)
  • SAP R/3
  • SAP R/3 Enterprise 4.7
  • SAP ERP Central Component
  • SAP ERP
  • SAP Enhancement package for SAP ERP
  • SAP Enhancement package for SAP ERP, version for SAP HANA

Product

SAP ERP Central Component all versions ; SAP ERP all versions ; SAP R/3 Enterprise all versions ; SAP R/3 all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

Keywords

DBSQL_DUPLICATE_KEY_ERROR; CX_SY_OPEN_SQL_DB; SAPLV45U; KONV_BEARBEITEN; VTAF; DATEN_KOPIEREN_053; VA01; VTAF , KBA , SD-BF-PR , Pricing , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.