SAP Knowledge Base Article - Preview

2704244 - DB2 LUW SQL0803N . . . table SAP<SID>.ENHTEXT~ from having duplicate values for the index key

Symptom

  • SUM error . . . SUM/abap/log/SQLDBSCRIPT##.OUT
       ERROR: Detected the following errors:# /sapgtrans/18B/<SID>/SUM/abap/log/SQLDBSCRIPT##.OUT:
       3 ETQ###XSQL: object = 'ENHO')
       3 ETQ### SQL: update "ENHTEXT~" set version = 'N' where enhname in (select
       3 ETQ###SQL: obj_name from "E071~" where trkorr = 'SAPKCCI752' and pgmid = 'R3TR' and
       3 ETQ###XSQL: object = 'ENHO')
       4 ETQ###  Date & Time: YYYYMMDD24MMSS
       1EETQ###  Error message: DBSL error 26 (db code -803):
       1EETQ###  DbSlExecuteDB6( SQLExecDirect ): [IBM][CLI 1EETQ###XDriver][DB2/LINUXX8664] SQL0803N One or more values in the INSERT statement,
       1EETQ###X UPDATE statement, or foreign key update caused by a DELETE statement are not
       1EETQ###X valid because the primary key, unique constraint or unique index identified by
       1EETQ###X "1" constrains table "SAP<SID>.ENHTEXT~" from having duplicate values for the
       1EETQ###X index key. SQLSTATE=23505 row=1
  • db2 "select unique enhname from ""SAP<SID>"".""ENHTEXT~""";
           ENHNAME                                                                                   
           ------------
           <tablenm>                                                                            

           1 Row(s) affected

  • db2 "select a.enhname, a.version, a.language, a.id from ""SAP<SID>"".""ENHTEXT~"" a where a.enhname = '<tablenm>';
       <result set has at least the following two rows in it . . .

       <tablenm> version = <"N"_value>               LANGUAGE = '<same_value>'
       <tablenm> version = <any_non_"N"_value> LANGUAGE = '<same_value>'

       here is an example . . .
          ENHNAME VERSION LANGUAGE ID
              <tablenm>   A         D          1
              <tablenm>   A         E          1
              <tablenm>   A         F          1
              <tablenm>   A         L          1
              <tablenm>   A         M          1
              <tablenm>   A         S          1
              <tablenm>   N         L          1
              7 Row(s) affected

       err SQL0803N is happening because of these two rows in the 7 rows above . . .
                 <tablenm>   A         L          1
                 <tablenm>   N         L          1


Read more...

Environment

SUM Upgrade
DB2 LUW

Product

SAP NetWeaver 7.4

Keywords

KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

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

Search for additional results

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