功能说明

适用模块

数据传输任务提交上线时，报错任务提交失败请稍后重试。

具体说明

提交数据传输任务上线时，出现报错任务提交失败请稍后重试。如下图。

问题原因 出现此类情况可先打开F12开发者工具查看具体报错信息详情。可容易定位问题。 一般是如下情况：

message: "[\"数据库唯一键冲突. \\n### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'ods_social_cost-ehr-建德十-1' for key 'task_name'\\n### The error may exist in class path resource [mapper/TaskOnlineDOMapper.xml]\\n### The error may involve com.netease.bdms.ndi.service.web.dao.TaskOnlineDOMapper.insert-Inline\\n### The error occurred while setting parameters\\n### SQL: insert into task_online (id, owner, product, cluster, creator, modifier, executor,conf, task_id, task_name, task_description, migration_type, create_time, modify_time, execute_time, version, status, properties, handlers, reader_id, reader_type, reader_url, writer_url, reader_table_name, writer_id, writer_type, writer_table_name) values (?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'ods_social_cost-ehr-建德十-1' for key 'task_name'\\n; Duplicate entry 'ods_social_cost-ehr-建德十-1' for key 'task_name'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'ods_social_cost-ehr-建德十-1' for key 'task_name'\"]"

可明显看出，是任务名重复了。修改任务名后提交上线成功，问题解决。

作者：刘思伟