SQL0803N One or more values in the INSERT statement
Stagingprop fails
|
Technote
(troubleshooting)
Problem(Abstract)
|
Your Stagingprop utiltiy fails when propagating data to
the production database. The reason for failure is a database error
similar to:
SQL0803N One or more values in the INSERT statement,
UPDATE statement, or foreign key update caused by a DELETE statement are
not valid because the primary key, unique constraint or unique index
identified by "2" constrains table "DB2ADMIN.INITIATIVE" from having
duplicate rows for those columns. SQLSTATE=23505
|
Symptom
|
Consider the following scenario, where each update is
recorded by table and primary key value in STAGLOG:
Update INITIATIVE table (key = 1, Unique Index = A)
Update INITIATIVE table (key = 2, Unique Index = B)
Update INITIATIVE table (key = 1, Unique Index = C)
Update INITIATIVE table (key = 2, Unique Index = A)
Update INITIATIVE table (key = 1, Unique Index = B)
Prior to running stagingprop, take the example where the production
database has two entries in the INITIATIVE table:
key = 1, Unique Index = A
key = 2 Unique Index = B
When running stagingprop, we will try to update the unique index of key =
1 to a value of B. However, on production, key = 2 already has the unique
index value = B.
|
Segment
| Product
| Component
| Platform
| Version
| Edition
|
Commerce
| WebSphere Commerce Enterprise
| Utilities/Tools
| AIX, Linux, Solaris, Windows
| 6.0
|
|
Commerce
| WebSphere Commerce Business Edition
| Utilities/Tools
| AIX, Linux, Solaris, Windows
| 5.6, 5.6.1
|
|
Commerce
| WebSphere Commerce - Express
| Utilities/Tools
| Linux, Windows
| 5.6, 5.6.1, 6.0
|
|
Commerce
| WebSphere Commerce Developer Enterprise
| Utilities/Tools
| Windows
| 6.0
|
|
Commerce
| WebSphere Commerce Developer Business Edition
| Utilities/Tools
| Windows
| 5.6, 5.6.1
|
|
Commerce
| WebSphere Commerce Developer Professional Edition
| Utilities/Tools
| Windows
| 5.6, 5.6.1, 6.0
|
|
Commerce
| WebSphere Commerce Developer Express
| Utilities/Tools
| Windows
| 5.6, 5.6.1, 6.0
| |
|
Current web document: http://www.ibm.com/support/docview.wss?uid=swg21269830
|