One Star

## 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/ShadowFileInputToDelimitedOutputCaused 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
One Star

## Re: Excel strange behaviour - maybe windows - Preview errors

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

## Re: Excel strange behaviour - maybe windows - Preview errors

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?
One Star

## Re: Excel strange behaviour - maybe windows - Preview errors

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.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 Johnit 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?
One Star

## Re: Excel strange behaviour - maybe windows - Preview errors

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.
One Star

## Re: Excel strange behaviour - maybe windows - Preview errors

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.
One Star

## Re: Excel strange behaviour - maybe windows - Preview errors

OK
let's try a bit of constructive discussion ..
OS, JDK version/release
actual paths to workspace and talend installation
regards,
One Star

## Re: Excel strange behaviour - maybe windows - Preview errors

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
One Star

## Re: Excel strange behaviour - maybe windows - Preview errors

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
One Star

## Re: Excel strange behaviour - maybe windows - Preview errors

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?
One Star

## Re: Excel strange behaviour - maybe windows - Preview errors

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
-vmc:\path\to\jdk\

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

this file is in the root of the Talend installation.
One Star

## Re: Excel strange behaviour - maybe windows - Preview errors

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.
One Star

## Re: Excel strange behaviour - maybe windows - Preview errors

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

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

One Star

## Re: Excel strange behaviour - maybe windows - Preview errors

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.
One Star

## Re: Excel strange behaviour - maybe windows - Preview errors

thanks for clarifying how you have resolved this issue.