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 for Me (Login required).

Search for additional results

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