Replicator Engine - connect_cdc_sqdata - 4.1

Connect CDC (SQData) Replicator Engine problems are generally associated with target datastores.

Some points to consider when diagnosing and correcting problems with the SQData Replicator Engine are listed below.

• Datastores (source and target) must exist and be accessible to the Engine during execution. This includes remote sqdaemon's, capture/publishers, local file systems and Kafka and HDFS clusters.
• Interacting with the Confluent Schema Registry requires specification of the corresponding "Subject", provided in either a MAPPINGS statement or by a MAPPINGS EXIT.

  object name	alias	rec type name	topic	subject	version	id
  SQD2DB00.SRC_KEY_20					0	0
  SQD1DB00.SRC_KEY_15					0	0
  SQD.EMP !	!	!	!	! 0	! 0

  SQDC016I sqdrpl(pid=22318) terminated with Return Code 8, Reason Code=0x227c006 (RPLUAVRO_MISSING_SUBJECT)

• Any errors in processing a target datastore will result in the Replicator Engine terminating with a return code of 8 or higher. All source CDC records from UOW's not fully processed and acknowledged are preserved and will be automatically republished once the Replicator is restarted.

• The Replicator script referenced in either command line operation or when specified in a controller sqdaemon sqdagents.cfg file may require specification of either relative or full path information.

  SQDC072E File engines/sqdrpl_case1.rpl could not be loaded (0x11c00c:FILE_STAT_ERROR)
  SQDY004E Could not open file: engines/sqdrpl_case1.rpl
  SQDC016I sqdrpl(pid=22102) terminated with Return Code 8, Reason Code=0x11c00c (FILE_STAT_ERROR)

• The SQData Replicator produces a report providing statistics about the number of input/source records processed and the number of target records written along with a histogram describing performance.