topic Re: Error: Invalid Character Constant in Talend Studio

Error: Invalid Character Constant

Anonymous — Sat, 16 Nov 2024 12:25:36 GMT

What does the error "Invalid Character Constant" mean?
My job holds components:
Input -> AddLocationFrom IP -> tMap -> tLogRow
(with additional inputs to the tMap)
The error popping up during compilation, and is related to tLogRow-component.

Any ideas?

Re: Error: Invalid Character Constant

Anonymous — Thu, 26 Jan 2012 14:18:40 GMT

Hi,
Take a look at your source's view job, might help you.

Re: Error: Invalid Character Constant

Anonymous — Thu, 26 Jan 2012 14:23:54 GMT

Sorry,
but I'm not following you.
I'm a noob 😉
The source component to tLogRow?
What is a "view job"?

Re: Error: Invalid Character Constant

Anonymous — Thu, 26 Jan 2012 14:27:22 GMT

You have the design view and the code view. Just open your job, on the bottom left of it you should see 2 tabs.

Re: Error: Invalid Character Constant

Anonymous — Thu, 26 Jan 2012 15:47:14 GMT

Ah!
Yes I know.
But, since I'm not a developer I will have a hard time interpret the code 😕
Any general hints of what to look for?

Re: Error: Invalid Character Constant

Anonymous — Thu, 26 Jan 2012 16:34:35 GMT

Do you have a red line?

Re: Error: Invalid Character Constant

Anonymous — Thu, 26 Jan 2012 16:54:45 GMT

Hi,
Found it and it helped!
Thanks!
(Now I'm struggling with a Null Pointer exception I get for some of my rows)

Re: Error: Invalid Character Constant

Anonymous — Fri, 27 Jan 2012 09:17:36 GMT

Geuder,
What are you doing in your tMap component? Because doing function on columns with null values can give null pointer exceptions.
If that's the case you need to do an if statement like: row1.ColumnName == null ? null : Yourfunction(row1.ColumnName)
Regards

Re: Error: Invalid Character Constant

Anonymous — Sat, 28 Jan 2012 15:36:56 GMT

Thanks!
That was exactly it!
One input field being a part of several output expressions.
/G