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.
SAP Knowledge Base Article - Preview