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