APAR status

• Closed as program error.

Error description

• CDC is replicating null for trailing column when table using
  compress method as compress for OLTP logging
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * NONE                                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Stack:                                                       *
  * 145400607    2017-11-06 10:17:31.357    ADVCOT2 Target       *
  * Apply:0{39605}                                               *
  * com.datamirror.ts.target.publication.TargetApplyJob          *
  * execute()    Failed to update a row in table PMPRT.TB_PRM.   *
  * ISS_AIRL: [16] DOC_NR: [2365488275] CPN_NR: [2] SEQ: [0]     *
  * .|Database operation failed.|A SQL exception has occurred.   *
  * The SQL error code is '1407'. The SQL state is: HY000. The   *
  * error message is: |[CDC][Oracle JDBC                         *
  * Driver][Oracle]ORA-01407: cannot update                      *
  * ("PMPRT"."TB_PRM"."TO_BE_IN_DT") to                          *
  * NULL|?com.datamirror.ts.target.publication.NonCriticalTarget *
  * ReplicationException Failed to update a row in table         *
  * PMPRT.TB_PRM. ISS_AIRL: [16] DOC_NR: [2365488275] CPN_NR:    *
  * [2] SEQ: [0] .|Database operation failed.|A SQL exception    *
  * has occurred. The SQL error code is '1407'. The SQL state    *
  * is: HY000. The error message is: |[CDC][Oracle JDBC          *
  * Driver][Oracle]ORA-01407: cannot update                      *
  * ("PMPRT"."TB_PRM"."TO_BE_IN_DT") to NULL                     *
  *                                                              *
  * Cause:                                                       *
  * CDC is preparing wrong update operation that updates not     *
  * nullable columns with NULLs. As a result there is an         *
  * ORA-01407 error on the target                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IIDR 11.4.0.0-5066 (Oracle) or later              *
  ****************************************************************
  

Problem conclusion

• Upgrading to IIDR 11.4.0.0-5066 (Oracle) or later will fix 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 ORACLE

• Fixed component ID

  5725E30OR

Applicable component levels

• RB40 PSY

     UP