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,
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>\
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?
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.
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!
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,
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
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?
