Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I'm currently using Talend as ETL tools for Oracle Database on my project.
Currently i'm running job Store Procedure created in Oracle using Talend (toracleSP) and run it from Job Conductor in TAC.
The problem is, when i killing the job session from Job Conductor, the session in oracle still active and need to be killed manually from database.
any help is appreciated
Thanks and Regards,
Willy
Hello,
Is there any message in TAC log?
Could you please clarify in which Talend version/edition you are?
Best regards
Sabrina
Hello,
Talend version i'm using right now is Talend Studio 6.5.1
no message in tac log after the job killed
Regards,
Willy
Hi @Willyemerio ,
Can you pls check the Job design in Talend studio in terms of code generated and i would also suggest you to close the connection once the data load is complete. After this is done, pls re-publish/add the job onto TAC and then re-generate the code.
Pls get back to the Community,if necessary.
Thanks,
Ankit
Hi @Willyemerio ,
Apologies for my previous reply, if it wasnt clear.
What i meant by checking the code is in the Talend studio, you have a code tab in the bottm of the workspace after moving to that tab you can identify what are the issues with your generated code basing on that you can make changes in your job design. also in your job design if you are loading data to your Oracle Database then i suggest that after the target Component(tOracleOutput or whatever is the output component) pls connect tOracleCloseConnection for the connection.
Pls let the Community know,If the issue persists.
Thanks,
Ankit