IV73230: DURING DATA IMPORT GETING DATABASE CONSTRAINT ERRORS AGAINST TABLE "SAM.ISOTAG_FACT_TEMPS" FROM HAVING DUPLICATE VALUES

APAR status

• Closed as program error.

Error description

• ENV: LMT 9.2 on Linux with DB2 10.5
  During Data Import seeing the following errors
  2015-05-07 08:12:00 (+0:00:00.003) ERROR: Batch execution error:
  Error
  for batch element #1: 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 "1" constrains table "SAM.ISOTAG_FACT_TEMPS" from
  having
  duplicate values for the index key.. SQLCODE=-803,
  SQLSTATE=23505,
  DRIVER=4.14.111
  
  This fails the Data Import
  

Local fix

• Check with L3 for latest HotFix
  

Problem summary

• ****************************************************************
  ERROR DESCRIPTION:
  Import of data fails and the following error can be found in
  the logs:
  Error for batch element #1: 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 "1" constrains table
  "SAM.ISOTAG_FACT_TEMPS" from having duplicate values for the
  index key. SQLCODE=-803, SQLSTATE=23505,DRIVER=4.14.111
  Behavior after you install the update:
  The error does not occur and the import of data succeeds.
  ****************************************************************
  * RECOMMENDATION: Apply appropriate update when available or
  * refer to the documentation update
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  packages:
   | Update | SUA 9.2.0.2 site 51
   | Update | ILMT 9.2.0.2 site 63
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  LIC METRIC TOOL

• Fixed component ID

  5724LMTEM

Applicable component levels

• R920 PSY

     UP