JR61375: POSSIBLE DATA LOSS AFTER EVENT ID 2903 "AN EXCEPTION HAS OCCURRED IN THE LOG PARSER."

APAR status

• Closed as program error.

Error description

• Possible data loss after event ID 2903
  
  ID=2903 MSG=An exception has occurred in the log parser. IBM
  InfoSphere Data Replication encountered an error while
  processing data for table with id <id> and name
  "<schema>"."<table_name>". The error could be related to DDL
  done on the table recently or in the past. Please rebuild the
  table and refresh to reposition past the current log position.
  Please review Microsoft documentation possible options to
  rebuild the table.
  

Local fix

• Rebuilding table <schema>.<table_name>
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you replicate SqlServer tables  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Replication ends on error, and when mirroring starts again   *
  * there may be data missing from the target.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.2-5503 or newer for SQL Server.        *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.2-5503 or newer for SQL Server 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 SQL

• Fixed component ID

  5725E30SQ

Applicable component levels