Cannot delete Job Conductor entry

Anonymous — Thu, 14 Mar 2013 19:20:30 GMT

We have a job in Job Conductor that seems to be "locked" - it cannot be modified or deleted, but we need to delete it. When I attempt to delete it, I get an error message of "Delete Failed," and the Error Status is "Unexpected error, contact your administrator."
Following is the info from the "Last occurred error:" section of the "Information" tab for the job:
!!!Cannot flush and commit transaction.!!!
org.talend.administrator.common.persistence.hibernate.HibernateTransactionHolder.commitWithFlush(HibernateTransactionHolder.java:116)
org.talend.administrator.common.persistence.hibernate.HibernateTransactionHolder.commitWithFlushAndBeginNewTransaction(HibernateTransactionHolder.java:190)
org.talend.administrator.scheduler.business.job.deploy.VirtualServerJobDeployer.sendAndDeploy(VirtualServerJobDeployer.java:110)
org.talend.administrator.scheduler.business.job.deploy.JobServerJobDeployerCached.sendAndDeploy(JobServerJobDeployerCached.java:44)
org.talend.administrator.scheduler.business.ExecutionTaskHandler.deployJobUnit(ExecutionTaskHandler.java:603)
org.talend.administrator.scheduler.business.ExecutionTaskHandler$2.run(ExecutionTaskHandler.java:457)
Caused by: Batch update returned unexpected row count from update ; actual row count: 0; expected: 1
org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)
org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:68)
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
org.talend.administrator.common.persistence.hibernate.HibernateTransactionHolder.commitWithFlush(HibernateTransactionHolder.java:108)
org.talend.administrator.common.persistence.hibernate.HibernateTransactionHolder.commitWithFlushAndBeginNewTransaction(HibernateTransactionHolder.java:190)
org.talend.administrator.scheduler.business.job.deploy.VirtualServerJobDeployer.sendAndDeploy(VirtualServerJobDeployer.java:110)
org.talend.administrator.scheduler.business.job.deploy.JobServerJobDeployerCached.sendAndDeploy(JobServerJobDeployerCached.java:44)
org.talend.administrator.scheduler.business.ExecutionTaskHandler.deployJobUnit(ExecutionTaskHandler.java:603)
org.talend.administrator.scheduler.business.ExecutionTaskHandler$2.run(ExecutionTaskHandler.java:457)

Re: Cannot delete Job Conductor entry

Anonymous — Mon, 20 May 2019 13:59:17 GMT

Hello,

I have similar question.

A Job ended with errors (triggered every 15 minutes) due to ftp connexion reject.

Since, the job is no longer run ... the trigger status is showing red/forbidden ...

I cannot delete the job, I try to change some parameters of execution task and save but I have the message "save failed : another operation is locking..."

How to force deletion ?

regards

Damien

Re: Cannot delete Job Conductor entry

Bhavik1 — Tue, 11 Jun 2019 15:21:43 GMT

Hi Damien,

We also had similar problem.
We used to call admin to remove lock from the task.
After that we were able to perform other operations.

If you found any other solution please share..!

Thanks
Bhavik

topic Cannot delete Job Conductor entry in Data Quality

Cannot delete Job Conductor entry

Re: Cannot delete Job Conductor entry

Re: Cannot delete Job Conductor entry