TAC Job Conductor job hung at "Generating"

Highlighted
One Star

TAC Job Conductor job hung at "Generating"

Using TAC (Big Data Edition), I have a job that needs to be deployed to many Job Servers in a cluster. The first few generate, deploy and run just fine, but then a job will get stuck in the Generating step and never complete. Even after stopping/restarting TAC (on linux), stopping/restarting the job servers, it's still stuck.
In the CommandLine view of TAC, the step that is in the running phase is ExportJobCommand.
Even if I kill this job and create a duplicate, the duplicate becomes hung as well.
Highlighted
One Star

Re: TAC Job Conductor job hung at "Generating"

Hi
Just delete the directory <TIS Installation dir>\commandline-workspace.
And try to generate it again.
Regards,
Pedro
Highlighted
One Star

Re: TAC Job Conductor job hung at "Generating"

Hi Barry,
I had a similar problem about a year ago. The jobs had many context variables and they exceeded the length of the db field in the H2 database running TAC.
http://www.talendforge.org/bugs/view.php?id=17860
I ran these alter table statements:
alter table "executiontaskjobprm" alter column "label" VARCHAR(510);
alter table "executiontaskjobprm" alter column "originalvalue" CLOB(4147483647);
alter table "executiontaskjobprm" alter column "defaultvalue" CLOB(4147483647);
alter table "taskexecutionhistory" alter column "contextvalues" CLOB(4147483647);
You might not have the same problem I had, but it certainly sounds like similar symptoms.
Thanks,
Ben
Highlighted

Re: TAC Job Conductor job hung at "Generating"

Thanks, Pedro. That cleared out the Command Line records from TAC, and reset the job to Ready to Generate, but it still gets stuck when I try to regenerate. It hangs at the ExportJobCommand step.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog