IV59725: INITIAL IMPORT FAILING

APAR status

• Closed as program error.

Error description

• Initial import error with the following logs:
  
  ERROR: Sequel::DatabaseError: NativeException:
  
  com.ibm.db2.jcc.am.SqlException: An error occurred in a
  triggered SQL
  statement in trigger "DBO.DATASOURCE_G". Information returned
  for the
  error includes SQLCODE "-545", SQLSTATE "23513" and message
  tokens
  "DBO.DATASOURCE_GROUP_MEMBERSHIPS_SCD.CKT_D".. SQLCODE=-723,
  SQLSTATE=09000, DRIVER=3.64.104
  

Local fix

Problem summary

• ****************************************************************
  * Initial import error with the following logs:
  *
  * ERROR: Sequel::DatabaseError: NativeException:
  *
  * com.ibm.db2.jcc.am.SqlException: An error occurred in a
  * triggered SQL statement in trigger "DBO.DATASOURCE_G".
  * Information returned for the error includes SQLCODE "-545",
  * SQLSTATE "23513" and message tokens
  * "DBO.DATASOURCE_GROUP_MEMBERSHIPS_SCD.CKT_D".. SQLCODE=-723,
  * SQLSTATE=09000, DRIVER=3.64.104
  ****************************************************************
  * RECOMMENDATION: Apply appropriate update when available.
  ****************************************************************
  

Problem conclusion

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

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

  IEM SW USE ANL

• Fixed component ID

  5725F57MT

Applicable component levels

• R910 PSY

     UP