IJ19979: IMPORT IS FAILING WITH A CHECKCONSTRAINTVIOLATION VIOLATION

APAR status

• Closed as program error.

Error description

• customers imports failing import log error
  
  2019-09-09 22:09:10
  (+0:00:00.235) INFO: ETL from Data Source - SAM::ScanFile
  (0x0000000000990AF5 - 0x00000000009A8E62): Failed
  
  2019-09-09
  22:09:10 (+0:00:00.015) ERROR: Sequel::CheckConstraintViolation:
  DBNAME: temadb -
  Java::ComMicrosoftSqlserverJdbc::SQLServerException: The UPDATE
  statement conflicted with the CHECK constraint
  "ckt_sam__scan_files_scd". The conflict occurred in database
  "temadb", table "sam.scan_files_scd".
  
  TS002703810
  

Local fix

• Root cause of the duplicated IDs which are causing import error
  is caused by running "Initiate Software Scan on Shared Disks" on
  the same machine more than once, at the same time.
  

Problem summary

• ****************************************************************
  
  * ERROR DESCRIPTION:
  *
  * customers imports failing import log error
  *
  *
  *
  * 2019-09-09 22:09:10
  *
  * (+0:00:00.235) INFO: ETL from Data Source - SAM::ScanFile
  *
  * (0x0000000000990AF5 - 0x00000000009A8E62): Failed
  *
  *
  *
  * 2019-09-09
  *
  * 22:09:10 (+0:00:00.015) ERROR: Sequel::CheckConstraintViolatio
  *
  * DBNAME: temadb -
  *
  * Java::ComMicrosoftSqlserverJdbc::SQLServerException: The UPDAT
  *
  * statement conflicted with the CHECK constraint
  *
  * "ckt_sam__scan_files_scd". The conflict occurred in database
  *
  * "temadb", table "sam.scan_files_scd".
  *
  *
  *
  * TS002703810
  *
  * **************************************************************
  *
  * EXPECTED RESULTS:
  * The issue does not occure.
  ****************************************************************
  * RECOMMENDATION: Apply appropriate update when available.
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  packages:
   | Update | ILMT 9.2.17
  ****************************************************************
  

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