topic error when testing an expression in Talend Studio

error when testing an expression

carlrees123 — Tue, 11 Jul 2017 11:09:57 GMT

Exception in thread "main" java.lang.Error: Unresolved compilation problems:

comes up in red

image attached

does anyone think the expression is incorrect? -- no, so why the error?

upon exiting expression builder and run the job it works perfectly... known bug?

Re: error when testing an expression

TRF — Tue, 11 Jul 2017 12:19:12 GMT

This should be better:

"Y".equalsIgnoreCase(row2.name2) ? "Yes" : "No"

Re: error when testing an expression

carlrees123 — Tue, 11 Jul 2017 12:48:10 GMT

Thanks but gives same error when hitting the test button !

see image

a1.JPG

Re: error when testing an expression

cterenzi — Tue, 11 Jul 2017 17:36:29 GMT

Should the test value be "Y" instead of just Y?

Re: error when testing an expression

Anonymous — Wed, 12 Jul 2017 05:19:59 GMT

Hello,

Don't use =="". Instead use .equals("").

Is your tMap Ok with you when you omit clicking on "Test"?

Best regards

Sabrina

Re: error when testing an expression

carlrees123 — Wed, 12 Jul 2017 09:47:06 GMT

Thanks all but still gives an error.....

how do I check if this is a bug in Talend ?

the code works, however the code that runs behind the Test! button does not seem to like expressions with correct syntax !

a1.JPG

Re: error when testing an expression

Anonymous — Wed, 12 Jul 2017 11:03:03 GMT

Hi,

Have you tried to execute your job without clicking on "Test" to see if there is any error printed on console?

Best regards

Sabrina

Re: error when testing an expression

carlrees123 — Wed, 12 Jul 2017 11:37:40 GMT

Bury your head in the sand and IGNORE THE FACT THAT TALEND HAS AN BUG................ at your peril,

if this tool does not work as expected i'm not committing my companies data to it , period. THERE IS NO TRUST, reasonable ? tell me if i'm not being reasonable?

hand coded java c# f# will always be better, than a tool that is always half right because you will never know when Talend is telling the truth and when it has odd error messages for no reason!

Re: error when testing an expression

cterenzi — Wed, 12 Jul 2017 13:54:27 GMT

Did you attempt to change the test value to "Y" like I suggested? Fields which take string literals in Talend almost always require that the value be wrapped in quotes. I did not see quotes around the Y in your original screenshot.

Re: error when testing an expression

carlrees123 — Wed, 12 Jul 2017 15:26:03 GMT

Thanks

I did, got same error from the Test ! button.

I think its just a bug, but false positives are very very dangerous.

Re: error when testing an expression

cterenzi — Wed, 12 Jul 2017 17:05:07 GMT

I was able to reproduce this when I put "Y" as the value for name2. I finally found an example of how to use the expression builder Test feature in the documentation:

https://help.talend.com/reader/nXPtKhielAtSqFD6_f7~OQ/UiJEcAn2BxH5csEtuIR5pA

It shows that test values should not be wrapped in quotes, so I removed my quotes. After that, the test started working and displays "Yes" in the output area.

Re: error when testing an expression

Anonymous — Thu, 13 Jul 2017 08:23:56 GMT

Hi,

We usually use the Test! button to test a function.

The Test! button can't understand "Y" for your column value name2, you need to execute the job to see if the job works without any compilation error or Java error to locate your issue in expression.

Best regards

Sabrina

Re: error when testing an expression

carlrees123 — Thu, 13 Jul 2017 09:44:19 GMT

Great

re: We usually use the Test! button to test a function.

can you point me to the documentation for the Test! button

Re: error when testing an expression

carlrees123 — Thu, 13 Jul 2017 10:20:46 GMT

Thank you again cterenzi (Kudos to you for the post !!)

Great reply and good link to documentation (love the chuck Norris ref !)

I have found the issue and it IS A BUG in the Talend expression/function checker, the coder who wrote this did not check for a Var (variable) that has no name defined

I wonder if they also checked for variables that are reserved words?

see screen shot of blank variable !

a1.JPG

Re: error when testing an expression

Anonymous — Thu, 13 Jul 2017 10:34:28 GMT

Hello,

Here is online document about:TalendHelpCenter:tMap operation

Feel free to create a jira issue about your issue or concern on talend bug tracker.https://jira.talendforge.org/secure/Dashboard.jspa

Best regards

Sabrina