JR60590: AFTER REFRESH USER EXIT IS NOT EXECUTED FOR JOURNAL CONTROL CODE FIELD.

APAR status

• Closed as program error.

Error description

• After refresh User Exit is not executed for Journal
  Control Code field.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue affects clients using CDC for Oracle where        *
  * subscriptions invoke a user exit for operation "after        *
  * refresh", and that user exit contains journal control        *
  * fields.                                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * If you use a stored procedure that contains journal control  *
  * fields such as j$CODE for operation "after refresh", the     *
  * following error may be returned:                             *
  * Target Apply:0{838}                                          *
  * com.datamirror.ts.target.publication.TargetApplyJob          *
  * handleNonRecoverableException() An error occurred in User    *
  * Exit for table <table name>. User exit class name:           *
  * com.datamirror.ts.target.publication.userexit.wrappers.sp.St *
  * oredProcedureUserExit|Error: The error value is "Unsupported *
  * image type requested in TargetEndRefreshOperation            *
  * JOURNAL_CONTROL".                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR LUW 11.4.0.2-5512 or newer for Oracle.        *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR LUW 11.4.0.2-5512 or newer for Oracle 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 DATA REPLICA

• Fixed component ID

  5725E3000

Applicable component levels

• RB40 PSY

     UP