DTS-077500 目标实例异常

ADS 实例同步常见异常问题

1. ADS 主键字段值校验异常

   异常信息：

   DTS-077500: 
   Target Instance error in table {db_name.tb_name}, Please contact ADS support, 
   cause by [com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: InvalidStatementException:
   [USER ERROR] all primary key columns value are NULL: (0, NULL, NULL).

   解决方案：
   重建目的ADS表，并调整ADS主键符合源库数据值

2. ADS 磁盘空间不足或者ADS磁盘写入失败

   DTS-077500: Record Replicator error in table {db_name.tb_name}, cause by java.io.IOException: 
   com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
   Error Code:20015, RealtimeDataFailedException:Insert failed with 1 data records: [partition=14] 
   Unknown error in QueueStorage

   解决方案：
   去ADS控制台扩容ADS实例磁盘空间，然后重启DTS同步任务

3. ADS 计算节点挂了

   DTS-077500: 
   Target Instance error in table {db_name.tb_name}, Please contact ADS support, cause by java.io.IOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 
   Error Code:20015, 
   RealtimeDataFailedException:Insert failed with 1 data records: [partition=60] connect to <10.154.184.97:43894> failed

   解决方案：
   联系ADS值班恢复计算节，然后重启DTS任务

4. ADS 写入列校验失败

  DTS-077500:
  Target Instance error in table anta_analytic.ads_test, Please     contact ADS support. cause by [com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: InvalidStatementException:[USER ERROR] null value is not allowed for NOT NULL column: column=name7, value=java.lang.Object@4904e6c8]

解决方案：修改ADS对应表结构定义，重启任务

ODPS实例同步常见异常问题

Datahub实例同步常见异常问题