Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Anonymous
Not applicable
‎2011-07-05 10:31 AM

Excel strange behaviour - maybe windows - Preview errors

when i try to open an Excel 2003 (.xls)
when i try to create a metadata for this file in Windows, i get the error below when using ANY encoding: 
java.lang.NoClassDefFoundError: itrack_reporting/shadowfileinputtodelimitedoutput_0_1/ShadowFileInputToDelimitedOutput
Caused by: java.lang.ClassNotFoundException: itrack_reporting.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput
	at java.net.URLClassLoader$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
Could not find the main class: itrack_reporting.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.  Program will exit.
Preview error. Some settings must be changed.
Note: Preview errors are generally due to a wrong encoding setting.
org.talend.designer.runprocess.shadow.ShadowFilePreview.preview(ShadowFilePreview.java:90)
org.talend.repository.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:385)
org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep2Form$PreviewProcessor.nonUIProcessInThread(ExcelFileStep2Form.java:969)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)

but in linux (ubuntu x64 11.04 - with sun-java) it works fine without a glitch.
any suggestions on this topic? any similar experiences? is this a bug?
thanks,

Nicolas
Labels (3)
Labels
763 Views
0 Likes
Anonymous
Not applicable
‎2011-07-05 12:31 PM

if you have Talend installed in "Program Files" or any directory with a space, try moving it to one that does not contain a space. my favorite is c:\talend\<version>\
526 Views
0 Likes
Anonymous
Not applicable
‎2011-07-18 09:40 AM

very close John

it turns out that my workspace was in: 
p:\workspace\talend\

so i simply moved into: 
c:\development\workspace\talend\

effectively moving from a network to a local disk.
and it has fixed the error..
i wounder if this should not be considered as a bug?
526 Views
0 Likes
_AnonymousUser
Specialist III
Specialist III
‎2011-10-05 06:00 AM

By moving the workspace, I got rid of the fisrt half of the error.
There is still the second part :

Preview error. Some settings must be changed.
Note: Preview errors are generally due to a wrong encoding setting.
org.talend.designer.runprocess.shadow.ShadowFilePreview.preview(ShadowFilePreview.java:90)
org.talend.repository.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:385)
org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep2Form$PreviewProcessor.nonUIProcessInThread(ExcelFileStep2Form.java:969)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)

very close John

it turns out that my workspace was in:
p:\workspace\talend\

so i simply moved into:
c:\development\workspace\talend\

effectively moving from a network to a local disk.
and it has fixed the error..
i wounder if this should not be considered as a bug?
526 Views
0 Likes
Anonymous
Not applicable
‎2011-10-11 08:04 AM

Hi,
i'm currently having the same problem with excel and csv files in Version: 4.2.2 Build id: r63143-20110622-0628.
Initially, the workspace was on a network drive. Copying the repository to c: did not help. Neither the repository path nor the talend installation path does not contain any spaces. Any suggestions?
Thanks,
Tansel.
526 Views
0 Likes
Anonymous
Not applicable
‎2014-10-24 03:48 PM

This question has been posted many times and I have yet to find a solution from Talend Support.  I am using files provided by Talend in their demos.  I have tried many combinations of TAlend and JDKs, have uninstalled/reinstalled....  If support can't provide concrete solutions instead of questions, then I am going to look for another product.  This should be a very simple issue to resolved. 
Ready to give up!
526 Views
0 Likes
Anonymous
Not applicable
‎2014-10-24 05:37 PM

OK
let's try a bit of constructive discussion ..
could you *please* let us know some specifics about your environment?
OS, JDK version/release
actual paths to workspace and talend installation
regards,
526 Views
0 Likes
Anonymous
Not applicable
‎2014-10-24 05:48 PM

C:\Program Files (x86)\TOS_DI-Win32-r118616-V5.5.1
C:\Program Files (x86)\Java\jdk1.7.0_71\bin
JAVA_HOME: "C:\Program Files (x86)\Java\jdk1.7.0_71"
Windows 7 Professional, sp1
526 Views
0 Likes
Anonymous
Not applicable
‎2014-10-24 06:15 PM

Thanks,
as you can see from the comments above
there is something peculiar with the way interacts with Java
could you try the above suggestions first to see if it works?
move your JDK to (a path *without* spaces) like
c:\java\x64\jdk\
and also move Talend to a path without spaces
as well as its workspace
keep us posted
526 Views
0 Likes
Anonymous
Not applicable
‎2014-10-24 06:29 PM

The above thread did not confirm that moving to a path without spaces resolved the issue related to preview errors. 
When you say "move JDK and Talend", you mean that I need to reinstall both, correct?
526 Views
0 Likes