topic Re: Joblet does not work but code does in Talend Studio in Talend Studio

Joblet does not work but code does in Talend Studio

rmcclure — Sat, 16 Nov 2024 03:12:28 GMT

I have a Joblet in a reference project. This joblet opens DB connections, set context variables, writes to logs, closes DB connections etc.

If I:
- Create a standard job
- insert the joblet into the Job
- Run the job
- It fails with a NullPointerException

If I:
- Create a standard job
- copy the contents of the Joblet directly into the standard job
- Run the job
- It completes successfully

To make things more bizarre
If I:
- Switch to the reference project
- Create a the same standard job as above
- insert the joblet into the Job
- Run the job
- It completes successfully

If I:
- back in the master project
- run an existing job
- It completes successfully
- remove the joblet from the existing job
- immediately re-insert the joblet and run
- It fails with a NullPointerException

This joblet was modified recently and pushed to Github. I have pulled in the change and still have the issue
I have also renamed my workspace and re-pulled all from github.

Any ideas?

Re: Joblet does not work but code does in Talend Studio

Anonymous — Fri, 21 Feb 2020 01:37:48 GMT

Hi
Can you show us the full stack error message? We need more details to reproduce the issue. Which component throw the NPE error?

Regards
Shong

Re: Joblet does not work but code does in Talend Studio

rmcclure — Fri, 21 Feb 2020 18:03:44 GMT

I posted the error below. The component in error is a tDBInput.

The issue isn't the error as much as the fact that this exact same code works fine if it is placed in the job rather than run from a joblet

Error is:

Exception in component PrePostJoblet_1_tDBInput_1 (testcycle)
java.lang.NullPointerException
at pos.testcycle_0_1.testcycle.PrePostJoblet_1_tDBInput_1Process(testcycle.java:6479)
at pos.testcycle_0_1.testcycle.PrePostJoblet_1_tDBConnection_1Process(testcycle.java:5535)
at pos.testcycle_0_1.testcycle.PrePostJoblet_1_tFileInputDelimited_1Process(testcycle.java:5270)
at pos.testcycle_0_1.testcycle.PrePostJoblet_1_tJava_1Process(testcycle.java:3555)
at pos.testcycle_0_1.testcycle.PrePostJoblet_1_tSetGlobalVar_1Process(testcycle.java:3423)
at pos.testcycle_0_1.testcycle.PrePostJoblet_1_tPrejob_1Process(testcycle.java:3256)
at pos.testcycle_0_1.testcycle.runJobInTOS(testcycle.java:32687)
at pos.testcycle_0_1.testcycle.main(testcycle.java:31493)
[FATAL]: pos.testcycle_0_1.testcycle - PrePostJoblet_1_tDBInput_1 null
java.lang.NullPointerException
at pos.testcycle_0_1.testcycle.PrePostJoblet_1_tDBInput_1Process(testcycle.java:6479)
at pos.testcycle_0_1.testcycle.PrePostJoblet_1_tDBConnection_1Process(testcycle.java:5535)
at pos.testcycle_0_1.testcycle.PrePostJoblet_1_tFileInputDelimited_1Process(testcycle.java:5270)
at pos.testcycle_0_1.testcycle.PrePostJoblet_1_tJava_1Process(testcycle.java:3555)
at pos.testcycle_0_1.testcycle.PrePostJoblet_1_tSetGlobalVar_1Process(testcycle.java:3423)
at pos.testcycle_0_1.testcycle.PrePostJoblet_1_tPrejob_1Process(testcycle.java:3256)
at pos.testcycle_0_1.testcycle.runJobInTOS(testcycle.java:32687)
at pos.testcycle_0_1.testcycle.main(testcycle.java:31493)

Re: Joblet does not work but code does in Talend Studio

Anonymous — Mon, 24 Feb 2020 01:45:21 GMT

Do you create the DB connection on tDBInput component or use an existing DB connection? I guess it is trying to use an existing DB connection, but the DB connection does not exist and causes the error.
Which version of studio are you using? We will test if it is a bug.

Regards
Shong

Re: Joblet does not work but code does in Talend Studio

rmcclure — Mon, 24 Feb 2020 13:34:44 GMT

I am using Studio 7.2.1.
I am using a tDBConnection prior to using the tDBInput. I agree that the connection dosn't exist but the real question is: Why does the code work fine when placed inside the job but not when called from a joblet?

Re: Joblet does not work but code does in Talend Studio

Anonymous — Mon, 24 Feb 2020 13:50:03 GMT

You say that the joblet works when used in a job created in your reference project. This points to maybe there being some metadata that the components in the joblet rely on, being in the reference project but not referenced in the project you are trying this in.

Re: Joblet does not work but code does in Talend Studio

rmcclure — Mon, 24 Feb 2020 14:13:21 GMT

Thanks for your response.

I understand what you are saying but if the metadata is in the reference project Why does the code work in the master project if I copy from the joblet and paste in a master project job? It still needs to reference the metadata from the reference project.

Re: Joblet does not work but code does in Talend Studio

rmcclure — Mon, 24 Feb 2020 18:31:24 GMT

The issue is resolved.

One of the jobs in the master project was working fine using the joblet. If I removed the joblet and replaced it the job no longer worked. There was something wrong with dropping the Joblet into the job. As a last resort I completely removed Talend from my local machine and re-installed from scratch. Afterwards the Job that wasn't working still didn't work, but when I removed the joblet and replaced it in the job it started to work.

Re: Joblet does not work but code does in Talend Studio

Anonymous — Wed, 26 Feb 2020 09:41:19 GMT

My thinking was that the metadata when you added the components to your job (not in the joblet) was set to built-in. However, it sounds like you have it sorted now. This is very strange behaviour and needs to be investigated. Since you are using joblets you clearly have the subscription product. Would you mind raising this with support? Thanks

Re: Joblet does not work but code does in Talend Studio

rmcclure — Wed, 26 Feb 2020 13:26:17 GMT

I did raise this issue with support. They just sent me a link to this discussion.

Re: Joblet does not work but code does in Talend Studio

Anonymous — Wed, 26 Feb 2020 14:30:51 GMT

Which link did they give you? Would you mind posting it? Also, would you mind informing them that it was not the answer and that you needed to reinstall? I'm sorry that you had to go through these steps, but hopefully your experience with this can help support nail this in the future. Tell them that Richard from the Community team asked you to do this. If they want any more information, I can hopefully take it from there. Thanks

Re: Joblet does not work but code does in Talend Studio

rmcclure — Wed, 26 Feb 2020 14:51:53 GMT

I got the email below as a response from support. I had also mentioned that this "solution" was a complete reinstall and not really the answer I was looking for.

Please review this KB articles which seems similar to what you are experiencing:

https://community.talend.com/t5/Design-and-Development/Joblet-does-not-work-but-code-does-in-Talend-Studio/m-p/214074#M117674

Please let us know.

Thanks,
Talend Support

Re: Joblet does not work but code does in Talend Studio

Anonymous — Wed, 26 Feb 2020 18:36:04 GMT

Thanks @rmcclure, I'll look into this for you.