topic Re: [resolved] Error when creating new Excel file in Metadata in Talend Studio

[resolved] Error when creating new Excel file in Metadata

Anonymous — Mon, 12 Jan 2015 16:59:49 GMT

Hi,
I want to create a new Excel file in the metadata.
When arriving on step 3 of 4, tab "Output" shows the error messages :
"Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. 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:383)
org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep2Form$PreviewProcessor.nonUIProcessInThread(ExcelFileStep2Form.java:1041)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)"
The same happens when I try to create a delimited file.
Java on my Win7 machine is C:\Program Files (x86)\Java\jdk1.7.0_71
Thanks for your help.
JL

Re: [resolved] Error when creating new Excel file in Metadata

Anonymous — Tue, 13 Jan 2015 03:47:02 GMT

Hi,
Did you install Talend in "Program Files" or any directory with a space or illegal character? If so, try moving it to one that does not contain a space. Such as: D:\talend\<version>\(Don't give a long name).
Feel free to let me know is it OK with you.
Best regards
Sabrina

Re: [resolved] Error when creating new Excel file in Metadata

Anonymous — Tue, 13 Jan 2015 10:03:42 GMT

Hi Sabrina,
Yes, Talend was installed on c:\Program Files.
I moved (cut/paste) Talend to c:\Talend and tried again.
But it does not work :
Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. 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:383)
org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep2Form$PreviewProcessor.nonUIProcessInThread(ExcelFileStep2Form.java:1041)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)
It sounds there is an issue with the Java Virtual Machine, but I don't know what the messages exactly mean.
JL

Re: [resolved] Error when creating new Excel file in Metadata

Anonymous — Tue, 13 Jan 2015 10:23:38 GMT

Hi,
What's the build version you are using? Did you execute a simple job successfully in it? Is it oracle JDK or Open JDK? Could you please show us your step 3 of 4 screenshots?
Best regards
Sabrina

Re: [resolved] Error when creating new Excel file in Metadata

Anonymous — Wed, 14 Jan 2015 08:21:46 GMT

Hi Sabrina,
Build version :
Version: 5.5.1
Build id: r118616-20140617-1110
No, I did not execute a simple job successfully yet.
JDK comes from Oracle website.
See screen shot below.
Kind regards,
JL

Re: [resolved] Error when creating new Excel file in Metadata

Anonymous — Wed, 14 Jan 2015 09:49:02 GMT

Hi,

Yes, Talend was installed on c:\Program Files.
I moved (cut/paste) Talend to c:\Talend and tried again.

Please reinstall Talend Studio in c:\Talend instead of moving Talend related folder. Make sure that there is no extra space or illegal character.
Feel free to let us know if it is OK with you.
Best regards
Sabrina

Re: [resolved] Error when creating new Excel file in Metadata

Anonymous — Wed, 14 Jan 2015 18:56:36 GMT

Hi Sabrina,
I installed Talend Studio 5.6 on c:\Talend.
Now it works ok.
Thank you for your help.
Kind regards,
JL

Re: [resolved] Error when creating new Excel file in Metadata

Anonymous — Thu, 15 Jan 2015 07:48:27 GMT

Hi,
Would you mind marking this topic as resolved?
Best regards
Sabrina