JR58500: THE SUBSCRIPTION FAILED BECAUSE THE CONFLICT HAPPENED BUT CDC CAN NOT RESOLVE IT.

APAR status

• Closed as program error.

Error description

• The subscription failed because the conflict happened but CDC
  can not resolve it with following error exception.
  The part of SQL exception may be different based on the column
  type.
  .
  Conflict not resolved and error retrieving target table row.|
  IBM InfoSphere Data Replication was unable to resolve the
  conflict|and unable to insert details about this conflict and
  its resolution to the conflict resolution audit table.|The
  conflict was detected while performing the following type of
  operation: DELETE (1-Insert, 2-Update, 3-Delete).
  ......
  Caused by:
  com.datamirror.ts.target.apply.GenericDirectApplyException
  Database operation failed.|A SQL exception has occurred.
  The SQL error code is '-4220'. The SQL state is: [null].
  The error message is: |[jcc][1093][10427][4.19.26] Invalid data
  conversion:
  Parameter instance xxxx is invalid for the requested conversion
  to java.sql.Timestamp. ERRORCODE=-4220, SQLSTATE=null|
  .....
  
  In the JDBC trace, the SQL exception usually was from a SELECT
  statement generated for a conflict.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue affects users with IIDR 11.3.3.3-66 or            *
  * 11.4.0.0-5039 or earlier for Db2. It affects subscriptions   *
  * configured to use Conflict Detecting and Resolution, where   *
  * the Db2 datastore is used as a target.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A subscription will end replication on error. The following  *
  * error is in the event log:                                   *
  * "[Error]                                                     *
  * Origin:                                                      *
  * [com.datamirror.ts.target.publication.CriticalTargetReplicat *
  * ionException]                                                *
  * ID: [4179]                                                   *
  * Detail: [Conflict not resolved and error retrieving target   *
  * table row.                                                   *
  * IBM InfoSphere Data Replication was unable to resolve the    *
  * conflict                                                     *
  * and unable to insert details about this conflict and its     *
  * resolution to the conflict resolution audit table."          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IIDR 11.3.3.3-67 or 11.4.0.0-5040 or later for    *
  * Db2.                                                         *
  ****************************************************************
  

Problem conclusion

• Upgrading to IIDR 11.3.3.3-67 or 11.4.0.0-5040 or later for Db2
  resolves the issue.
  

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

  IS CDC DB2 LUW

• Fixed component ID

  5725E30DL

Applicable component levels

• RB33 PSY

     UP

• RB40 PSY

     UP