Warning : usage of a local non-builtin name and Debug format string

One Star

Warning : usage of a local non-builtin name and Debug format string

Hi ,
During execution of a job
tInputFileDelimited
|
|
tInputFileExcel ----->tMap ----> tOutputFileDelimited
the following messages are displayed :
"Warning : usage of a local non-builtin name "
"Debug format string is : 0.0%"
"Debug format string is #,##0.00 \ £

With same tInputFileDelimited(same csv file) I did'nt get such message and am suspecting Excel file.
How can I identify the non-builtin name ?

Here enclosed screenshots (Job , tMap , Warning1 , Warning2)
Best regards,
YVES
Community Manager

Re: Warning : usage of a local non-builtin name and Debug format string

Hi Yves
Which version of TIS/TOS are you using? I seen the same problem before, the warning messages are printed on tFileInputExcel component.
To locates the problem further, try to use a a tfileInputExcel to read a simple excel file and see the problem comes from the component or the file.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Warning : usage of a local non-builtin name and Debug format string

Hi Shong ,
I am using "Talend Open Studio"
Version: 4.2.0
Build id: r59885-20110505-1025
French version

Best regards,
Yves.
One Star

Re: Warning : usage of a local non-builtin name and Debug format string

Hi Shong,
With a simple job tFileInputExcel --> tFileOutDelimited I get same messages .
I attached the file the file to the post (I try use the worksheet IPP3).
Best regards,
Yves.
One Star

Re: Warning : usage of a local non-builtin name and Debug format string

Hi Shong,
file too big , I attach the worksheet IPP3 in zip file
Best regards,
Yves.
One Star

Re: Warning : usage of a local non-builtin name and Debug format string

Hi ,
zip file not allowed , I try Excel file
Best regards,
Yves.
One Star

Re: Warning : usage of a local non-builtin name and Debug format string

Hi Shong ,
Xls file not allowed , is there a way for me to send you the Excel file ?
now I am to go in a meeting.
Best regards,
Yves.
Community Manager

Re: Warning : usage of a local non-builtin name and Debug format string

Hi Yves
Please send the file and the job to me via email.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Community Manager

Re: Warning : usage of a local non-builtin name and Debug format string

Hi
It seems the file problem, we have seen many related topics on forum, see
http://www.talendforge.org/forum/viewtopic.php?id=4053
http://forum.iopus.com/viewtopic.php?f=8&t=4818
You can ignore the warning message by checking the box 'Ignoring warning message' in the advanced setting of component.
About the NPE exception, there are some null value in column row1.Crit_, to solve it, change the expression of Var1 to:
row1.Crit_==null?"":row1.Crit_

Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business