topic Re: How to get the error of tContextLoad in Talend Studio

How to get the error of tContextLoad

kakooo16 — Wed, 30 Jun 2021 15:26:54 GMT

Hello ,

I'm having a problem to get the error caused by setting a wrong value :

Example :

Cost (Integer)

Value Passed : "XXXX"

Here is my output of tLoadContext :

[statistics] connecting to socket on port 4068

[statistics] connected

Setting a value for the key "Cost " has failed. Error message: For input string: "XXXX"

How to get the global Variable that defines the error in the console ?

Re: How to get the error of tContextLoad

Sourav_Roy — Wed, 30 Jun 2021 18:47:16 GMT

Hi,

Please try again using implementing the below settings in tContextLoad

Also,

Alternatively try using ImplicitContextLoad from the below tab:

Re: How to get the error of tContextLoad

Anonymous — Thu, 01 Jul 2021 04:04:31 GMT

Hello,

It looks like there is a problem in the defined variables in the context.

Are your context variables in your job OR a list of context variables in a context group?

You can try is to type your context in your tJava and hit ctrl+space. This will show you a list of autocomplete options. Your available context variables will be in that list.

Here is online related scenario about: TalendHelpCenter: Reading data from different MySQL databases using dynamically loaded connection parameters

Hope it helps.

Best regards

Sabrina

Re: How to get the error of tContextLoad

gjeremy1617088143 — Thu, 01 Jul 2021 07:04:54 GMT

Hi, here the variables you can use for error in tContextLoad :

((String)globalMap.get("tContextLoad_1_ERROR_MESSAGE"))

((String)globalMap.get("tContextLoad_1_KEY_NOT_INCONTEXT"))

((String)globalMap.get("tContextLoad_1_KEY_NOT_LOADED"))

Send me Love and Kudos

Re: How to get the error of tContextLoad

kakooo16 — Thu, 01 Jul 2021 07:11:56 GMT

Hello jeremy ,

All of these variable print me Null

What component do i have to use and what link ?

Re: How to get the error of tContextLoad

kakooo16 — Thu, 01 Jul 2021 07:18:02 GMT

From File "YOUR_Path" what path exactly ??

Re: How to get the error of tContextLoad

gjeremy1617088143 — Thu, 01 Jul 2021 07:21:22 GMT

those variables are AFTER variables(they will be accessible after the component was executed),

i think you can use a tjava linked to the tlContextLoad with a oncomponent error link, and you have to set :

if a vairable loaded, but not in the context : error

if a variable in the context, but not loaded : error

in the basic settings of the component.

and if your tContextLoad is named tContextLoad_1 :

in the tJava :

System.out.println(((String)globalMap.get("tContextLoad_1_ERROR_MESSAGE")));

System.out.println(((String)globalMap.get("tContextLoad_1_KEY_NOT_INCONTEXT")));

System.out.println(((String)globalMap.get("tContextLoad_1_KEY_NOT_LOADED")));

Re: How to get the error of tContextLoad

kakooo16 — Thu, 01 Jul 2021 07:26:42 GMT

Here is the output :

I want just to get the variable that is not loaded by contextLoad

Because Costing_Date Variable is an int and when i charge it in tLoadContext with "XXXX" the variable is not loaded correctly

I want to get this particular error to the user that added the wrong value 'XXXX'

Re: How to get the error of tContextLoad

gjeremy1617088143 — Thu, 01 Jul 2021 07:27:22 GMT

path of your context file

Re: How to get the error of tContextLoad

kakooo16 — Thu, 01 Jul 2021 07:49:13 GMT

I'm not defining a group context , i'm declaring variables in context directly how to know the context of job ?

Re: How to get the error of tContextLoad

Anonymous — Thu, 01 Jul 2021 07:50:43 GMT

Hello,

How did you configure your input file with key and value columns?

The parameter Costing_Date Variable should be correspond to the parameter name in the delimited files.

Best regards

Sabrina

Re: How to get the error of tContextLoad

kakooo16 — Thu, 01 Jul 2021 07:54:04 GMT

it is correct and initialized : 2020

See below screen shot When the user pass Costing_date wrongly ('XXXX') the contextLoad show this error :

Setting a value for the key "Costing_date" has failed. Error message: For input string: "XXXX"

Now , i want to get just this error ? how can i achieve this ?

Re: How to get the error of tContextLoad

kakooo16 — Thu, 01 Jul 2021 08:03:44 GMT

Here is my job design

and my context is

when i run my job i get this error :

[statistics] connected

Setting a value for the key "Costing_date" has failed. Error message: For input string: "XXXX"

I just want to get this error when i set the key wrong as the example below

Re: How to get the error of tContextLoad

gjeremy1617088143 — Thu, 01 Jul 2021 09:18:49 GMT

So you can do this :

ad a custom string to the java part to see if its ok :

System.out.println("hello" + ((String)globalMap.get("tContextLoad_1_ERROR_MESSAGE")));

System.out.println("hello" + ((String)globalMap.get("tContextLoad_1_KEY_NOT_INCONTEXT")));

System.out.println("hello" + ((String)globalMap.get("tContextLoad_1_KEY_NOT_LOADED")));

if your message in the console is : hello and the error message

you got it.

So you can connect a twarn to the tcontextload instead of tjava with on component error and in the message field of the tmap you set the value of the variable:

ex :(String)globalMap.get("tContextLoad_1_ERROR_MESSAGE")

Re: How to get the error of tContextLoad

kakooo16 — Thu, 01 Jul 2021 09:35:11 GMT

How to do that ? ad a custom string

Re: How to get the error of tContextLoad

gjeremy1617088143 — Thu, 01 Jul 2021 10:09:34 GMT

just add for example : "hello" + in the println as i mentionned in the post, if all variables are null you 'll see nothing

if one of them is not null you'll see hello followed by your error message in the console