Jobs Not Running on Job Server with ERROR ExecutionTriggerableHelper  - org.talend.administrator.common.exception.UnicityException

Overview

It is possible with a problem in the TAC database for Jobs to not run properly. This generally occurs when there is a duplicate entry in the database that prevents normal operation. This will occur with manual or scheduled job runs.

Environment

Windows or Linux

Symptoms/Description

Jobs from Job Conductor will not run either manually or on schedule.
The following error is located in the logs:
ERROR ExecutionTriggerableHelper  - org.talend.administrator.common.exception.UnicityExceptionorg.talend.administrator.common.exception.SystemException: org.talend.administrator.common.exception.UnicityException
        at org.talend.administrator.scheduler.persistence.helper.ExecutionTaskHelper.findByIdQuartzJob(ExecutionTaskHelper.java:495)
        at org.talend.administrator.scheduler.persistence.helper.ExecutionTaskHelper.findByIdQuartzJob(ExecutionTaskHelper.java:465)
  
       at
org.talend.administrator.executionplan.persistence.helper.ExecutionTriggerableHelper.getByIdQuartzJob(ExecutionTriggerableHelper.java:99)
        at org.talend.administrator.scheduler.jobs.RemoteExecutionSwitcher.execute(RemoteExecutionSwitcher.java:44)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
Caused by: org.talend.administrator.common.exception.UnicityException
        at org.talend.administrator.scheduler.persistence.helper.ExecutionTaskHelper.findByIdQuartzJob(ExecutionTaskHelper.java:490)
        ... 5 more

 Resolution

To fix this issue please take a look at the following table in the TAC database:

Table: "ExecutionTask" table

Look for the same "idQuartzJob" duplicated in this table and remove the conflicting entry. Be sure you have a complete backup of the database before making any modifications to it.

Version History
Revision #:
1 of 1
Last update:
‎05-11-2017 08:43 PM
Updated by:
 
Labels (1)
Contributors