topic Capture Stats, Java exceptions and DB exceptions in table for a job in Talend Studio

Capture Stats, Java exceptions and DB exceptions in table for a job

Anonymous — Thu, 22 Feb 2018 08:55:19 GMT

Hi,

As I am creating a job, I am able to capture stats for the job in a table. But along with stats I also want to capture the Java excptions , db exceptions and number of records that are read / inserted / skipped / into the same table.

Is there a way to capture all that into the same table with Talend.

Best Regards,

Abhishek Kumar

Re: Capture Stats, Java exceptions and DB exceptions in table for a job

Anonymous — Thu, 22 Feb 2018 09:17:36 GMT

Take a look at the AMC. I have answered a question here (https://community.talend.com/t5/Administering-and-Monitoring/AMC-displays-no-data-in-TAC-How-to-enable-it/m-p/51395#M615) with links to useful information.

Re: Capture Stats, Java exceptions and DB exceptions in table for a job

Anonymous — Thu, 22 Feb 2018 10:16:23 GMT

Thank you, rhall_2_0.

Let me have a look.

Re: Capture Stats, Java exceptions and DB exceptions in table for a job

Anonymous — Thu, 22 Feb 2018 11:41:26 GMT

Hi rhall_2_0,

Thanks a lot, it was very helpful. One more thing I want to ask when I am getting error like below -

Cannot insert the value NULL into column 'RowId', table '<test>'; column does not allow nulls. INSERT fails.
[ERROR]: testproject.updateStaging - tMSSqlOutput_10 - Cannot insert the value NULL into column 'RowId', table 'test'; column does not allow nulls. INSERT fails.

I didn't get any log related to it. How do I capture logs like these in Talend ?

Best Regards,

Abhishek Kumar

Re: Capture Stats, Java exceptions and DB exceptions in table for a job

Anonymous — Thu, 22 Feb 2018 11:58:52 GMT

This error I don't believe will be picked up automatically. I believe it is just Java errors. The way to trap that yourself is to use a DB Connection component and share it to all of the DB components. You will need to handle commits when you do that. But what that does is open up a "Rejects" output. You can use this to record rejects from your database.