topic Re: Restart Job at point of tJDBCInput error in Talend Studio

Restart Job at point of tJDBCInput error

Anonymous — Wed, 08 Feb 2017 19:42:40 GMT

I have a job where I am extracting a large data set(37 million records each refresh) from an external Vendor database via a JDBC connection. I am using the bulk load component to insert the data into an oracle database. I have set up the job to bulk load into the oracle database in wk_end_dt increments.
However sporadically I receive the following error in the tJDBCInput component. I have added an additional JDBC connection to open and close the connection after each wk_end_dt load, but I am wondering how I can restart the job at the wk_end_dt it left off at when I receive this error. Anyone have any suggestions on how to set this up in my job?
Here is the error I receive. TEIID30504 is the name of the external database I am pulling data from

Job

Re: Restart Job at point of tJDBCInput error

Anonymous — Thu, 09 Feb 2017 08:19:36 GMT

Hi,
What's the error message you are facing? Could you please post you whole job design screenshot into forum?
Best regards
Sabrina

Re: Restart Job at point of tJDBCInput error

Anonymous — Thu, 09 Feb 2017 19:04:20 GMT

I re-posted the two errors I am getting in the original post.
The first error is from the JDBCInput : "Error checking for a transaction"
The second error is from the JDBC Commit : "The transaction is not active"
Here is also the full set of screen shots from the Job

Re: Restart Job at point of tJDBCInput error

Anonymous — Thu, 09 Feb 2017 20:53:09 GMT

Full set of job images