Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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)
14 Replies
Anonymous
Not applicable
Author

as a *test* that works
you can copy the installation folders
and paste in a path without spaces as suggested
you have to edit the talend*.ini file to use the new location 
you have to add the
-vm
c:\path\to\jdk\

see this: http://wiki.eclipse.org/Eclipse.ini

this file is in the root of the Talend installation.
Anonymous
Not applicable
Author

Eclipse.ini file did not have any path to the jdk, so I added the path.
I also changed the working folder.
I did not move jdk or talend installations to a different folder
The preview error no longer occurs, so I can continue.
Anonymous
Not applicable
Author

so ...
what you are saying is that by adding:
-vm
C:\Program Files (x86)\Java\jdk1.7.0_71\bin

everything is working as you expected.
namely, there are no problems

could you please confirm?
Anonymous
Not applicable
Author

This is what my eclipse.ini now contains.  It was hard to find the correct ini file.  It was buried several folders under the Talend installation folder. 
-vmargs
-Xms40m
-Xmx500m
-XX:MaxPermSize=128m
-vm C:\Program Files (x86)\Java\jdk1.7.0_71
NOTE:  I also had to change my working folder to get it to work:
C:\Users\Pam\Documents\XMLDev
It is working now.
Anonymous
Not applicable
Author

thanks for clarifying how you have resolved this issue.
enjoy your XML development

bye