topic Re: Excel strange behaviour - maybe windows - Preview errors in Talend Studio

Excel strange behaviour - maybe windows - Preview errors

Anonymous — Sat, 16 Nov 2024 12:49:42 GMT

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

Re: Excel strange behaviour - maybe windows - Preview errors

Anonymous — Tue, 05 Jul 2011 16:31:04 GMT

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>\

Re: Excel strange behaviour - maybe windows - Preview errors

Anonymous — Mon, 18 Jul 2011 13:40:52 GMT

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?

Re: Excel strange behaviour - maybe windows - Preview errors

_AnonymousUser — Wed, 05 Oct 2011 10:00:07 GMT

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?

Re: Excel strange behaviour - maybe windows - Preview errors

Anonymous — Tue, 11 Oct 2011 12:04:45 GMT

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.

Re: Excel strange behaviour - maybe windows - Preview errors

Anonymous — Fri, 24 Oct 2014 19:48:29 GMT

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!

Re: Excel strange behaviour - maybe windows - Preview errors

Anonymous — Fri, 24 Oct 2014 21:37:59 GMT

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,

Re: Excel strange behaviour - maybe windows - Preview errors

Anonymous — Fri, 24 Oct 2014 21:48:35 GMT

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

Re: Excel strange behaviour - maybe windows - Preview errors

Anonymous — Fri, 24 Oct 2014 22:15:29 GMT

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

Re: Excel strange behaviour - maybe windows - Preview errors

Anonymous — Fri, 24 Oct 2014 22:29:16 GMT

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?

Re: Excel strange behaviour - maybe windows - Preview errors

Anonymous — Fri, 24 Oct 2014 22:54:54 GMT

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.

Re: Excel strange behaviour - maybe windows - Preview errors

Anonymous — Sat, 25 Oct 2014 00:15:21 GMT

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.

Re: Excel strange behaviour - maybe windows - Preview errors

Anonymous — Sat, 25 Oct 2014 00:31:30 GMT

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?

Re: Excel strange behaviour - maybe windows - Preview errors

Anonymous — Sat, 25 Oct 2014 00:40:13 GMT

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.

Re: Excel strange behaviour - maybe windows - Preview errors

Anonymous — Sat, 25 Oct 2014 10:31:10 GMT

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

bye