JR61841: ERROR REFRESHING A TABLE WITH A LONG COLUMN COMMENT: "AN UNCAUGHT EXCEPTION HAS OCCURRED"

APAR status

• Closed as program error.

Error description

• An uncaught exception occurs when a table being refreshed has a
  table or column comment in the source database catalog metadata
  definition whose length exceeds 260 characters. When CDC
  refreshes a table, it captures the table definition from the
  source database catalog metadata and stores it in CDC metadata,
  where the comment field has a maximum of 260 characters. It
  fails if the comment exceeds that length.
  
  The following event
  is displayed:
  [ERR2001]: An error has occurred. Possible
  recovery steps: Please try again.
  If the error persists, if
  possible restart the IBM Data Replication Db2 for z/OS
  Remote
  Source instance and try again. Internal error information:
  Agent
  Message 'Message2023' Exception Text 'Metadata database
  error: A SQL exception
  has occurred. The SQL error code is
  '25201'. The SQL state is: 22001. The error
  message is: Data
  exception -- string data right truncation.
  

Local fix

• Truncate the column comment in the source table to 260
  characters or less.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue affects clients replicating source tables that    *
  * have column comments longer than 260 characters.             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This issue occurs when refreshing a source table that has a  *
  * column comment longer than 260 characters. Refresh ends on   *
  * error, and the following exception is logged:                *
  *                                                              *
  * com.datamirror.ts.util.TsExceptionHandler                    *
  * processUnhandledException() An uncaught exception has        *
  * occurred: com.datamirror.ts.metadata.MetadataPbException     *
  * Metadata database error: A SQL exception has occurred. The   *
  * SQL error code is '25201'. The SQL state is: 22001. The      *
  * error message is: |Data exception -- string data right       *
  * truncation.                                                  *
  *                                                              *
  * This happens because the replication engine tries to         *
  * retrieve the table information from its internal metadata    *
  * repository, and the metadata did not handle the case where a *
  * column comment was longer than 260 characters. This would    *
  * return an error, and the refresh would end.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade the source CDC replication engine to 11.4.0.2-5528   *
  * or newer.                                                    *
  ****************************************************************
  

Problem conclusion

• This issue is resolved by upgrading the source CDC replication
  engine to 11.4.0.2-5528 or newer. Long column comments are now
  handled properly.
  

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

• RB33 PSN

     UP