Error using internal variables

[Anonymous]

Hello,

I'm created a simple enough mapping that sets a fiew context variables dynamically using a tContextLoad, then uses a query to read some records from an Oracle table, goes through a tMap and to a tDBOutput. 

Everything works great, no errors, I see the data in the target table. 

Now I want to log the results, whether the tDBOutput inserted without errors or returned an error.

My plan was to use a tFixedFlowInput triggered by OnComponentOK from the tDBOutput and set the column values for my log table. Some variables are coming from the context variables and that works fine.

I hit issues when I try to use the internal variables from my SQL queries and output. I use the auto-complete to make sure I get the proper syntax:

internal((Integer)globalMap.get("tDBInput_1_NB_LINE")) 

internal((Integer)globalMap.get("tDBOutput_1_NB_LINE_INSERTED"))

internal((String)globalMap.get("tDBOutput_1_ERROR_MESSAGE"))

I get errors run time :

Error in the component's properties:The method internal(Integer) is undefined for the type MyJobName
The method internal(Integer) is undefined for the type MyJobName
The method internal(String) is undefined for the type MyJobName

I tried a number of things but can't figure out where I can use those internal variables and somehow output that somewhere.

Any idea?

Thanks.

JFS.

[Anonymous · Accepted solution]

I found the problem. 

My plan worked. The issue was in the syntax itself of those internal variables. 

Where I got : internal((Integer)globalMap.get("tDBInput_1_NB_LINE"))  I needed only (Integer)globalMap.get("tDBInput_1_NB_LINE") and voilà. 

I used "internal" because I had seen this in another post while searching how to ouput this kind of data. 

Cheers,

JFS.