topic Error Log Details in Talend Studio

Error Log Details

Anonymous — Tue, 23 Jul 2019 09:46:28 GMT

I want to retrieve exception error details and error line no and store in database. In tLogCatcher, I only saw exception error name such as java.lang.NumberFormatException:null. How to retrieve error line no and their details?

The following is tLogCatcher details. Where to get error line number and details?

Re: Error Log Details

Anonymous — Thu, 25 Jul 2019 08:30:18 GMT

Hello,

Could you please show us your whole job design screenshot? Let us know if you add "Die on Error" check box in your input source so that you will get error while reading the file itself.

Best regards

Sabrina

Re: Error Log Details

Anonymous — Thu, 25 Jul 2019 08:34:48 GMT

I ticked "Die on Error" check box and I got error details in terminal. The thing is I want to store that error details in database. TLogCatcher is not storing that error details. Any way to get these error details?

Re: Error Log Details

ThWabi — Thu, 25 Jul 2019 16:47:33 GMT

Hello JaRoi,

if you use a tLogCatcher component in your job, you need to connect its row output (if applicable via another tMap) to a database output component in order to write its data to a database table.

However, you can do without a tLogCatcher component by going to the "Stats & Logs" panel in the Job view and activating the "Use logs (tLogCatcher)" setting and enabling the "On databases" configuration. Make sure to check the "Catch runtime errors" settings (and others, if needed).

Best regards,

Thomas

Re: Error Log Details

ThWabi — Thu, 25 Jul 2019 16:54:29 GMT

Hello JaRoi,

for logging your data, you could try this:

From your tXMLMap, create a new output to a tHashOutput component and let your job write some important parts for your data to this "temporary log".

From your tLogCatcher component, create an "onComponentOk" link to a tHashInput component. Read from the previously created tHashOutput and write that data to a tLogRow (or a file). That way you should be able to capture your input data up to the point when an error occurs.

Best regards,

Thomas

Re: Error Log Details

Anonymous — Fri, 26 Jul 2019 03:54:14 GMT

It only show these error details. Any way to get error line number which error is causing?

Re: Error Log Details

ThWabi — Fri, 26 Jul 2019 07:56:12 GMT

Hello JaRoi,

you asked

> Any way to get error line number which error is causing?

Are you talking about the line number of the job java code or the line number of the input data flow?

You could add a sequence to the output (and input) of the tHash... components I mentioned.

Best regards,

Thomas

Re: Error Log Details

Anonymous — Fri, 26 Jul 2019 08:30:14 GMT

Hi Thomas,

I am talking about the line number of java code which error is causing. How to use thash components? I want to retrieve error stack trace occurred in txmlmap component.

Re: Error Log Details

ThWabi — Fri, 26 Jul 2019 10:24:45 GMT

Hi JaRoi,

perhaps this might help.

In tMap, on the left (input) side, open the tMap configuration/properties window and disable the "Die on error" setting. Then you will find an ErrorReject panel on the output side of the tMap. Connect that to a tLogRow or a file.

tMap Properties

Best regards,

Thomas

Re: Error Log Details

Anonymous — Fri, 26 Jul 2019 10:28:36 GMT

This is only available in tMap not txmlMap. And I am using talend V7.1.1 and it is not working there.

Re: Error Log Details

Anonymous — Wed, 31 Jul 2019 04:04:45 GMT

Hello @JaRoi

The tXMLMap component doesn't have "die on error" option. You could add another output to catch rejects via the filter box.

!Relational.ISNULL(((String)globalMap.get("tXMLMap_1_ERROR_MESSAGE"))) && 
! ((String)globalMap.get("tXMLMap_1_ERROR_MESSAGE")).equals("")

Best regards

Sabrina

Re: Error Log Details

Anonymous — Wed, 31 Jul 2019 04:07:37 GMT

Hello,

In addition to that, there is a jira issue that "tmap with Die on error uncheck doesn't create ErrorReject Output".

https://jira.talendforge.org/browse/TUP-20851

It works in 7.1.1 but subscription version and not work in 7.0, 7.1.1 Open Studio.

This issue is fixed in V 7.2.1.

Best regards

Sabrina

Re: Error Log Details

Anonymous — Wed, 31 Jul 2019 05:34:30 GMT

I changed txmlmap to tmap to get error stack trace via ErrorReject output. But I still have one issue. It only catch one error exception but the file has one or more exception error. How to get all error exceptions in one xml file?

Re: Error Log Details

Anonymous — Wed, 31 Jul 2019 05:38:40 GMT

Hello @JaRoi

Could you please set an example for your more exception error in one XML file?

Best regards

Sabrina

Re: Error Log Details

Anonymous — Wed, 31 Jul 2019 05:43:46 GMT

For example, remove value from xml file which is required in xml and database table.