topic Re: Error on preview when loading excel file in Talend Studio

Error on preview when loading excel file

Anonymous — Mon, 07 May 2018 15:21:16 GMT

I've tried differents enconding, still the same error.

Here's the log:

object is not an instance of declaring class
Preview error. Some settings must be changed.
Note: Preview errors are generally due to a wrong encoding setting.
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.eclipse.emf.codegen.jet.JETEmitter.generate(JETEmitter.java:461)
org.talend.designer.codegen.config.TalendJetEmitter.generate(TalendJetEmitter.java:684)
org.eclipse.emf.codegen.jet.JETEmitter.generate(JETEmitter.java:441)
org.eclipse.emf.codegen.jet.JETEmitter.generate(JETEmitter.java:432)
org.talend.designer.codegen.proxy.JetProxy.generate(JetProxy.java:54)
org.talend.designer.codegen.CodeGenerator.instantiateJetProxy(CodeGenerator.java:444)
org.talend.designer.codegen.CodeGenerator.generateContextCode(CodeGenerator.java:361)
org.talend.designer.core.runprocess.Processor.updateContextCode(Processor.java:637)
org.talend.designer.runprocess.java.JavaProcessor.generateContextCode(JavaProcessor.java:1585)
org.talend.designer.runprocess.ProcessorUtilities.generateContextInfo(ProcessorUtilities.java:693)
org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:929)
org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:741)
org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:1463)
org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:1432)
org.talend.designer.core.runprocess.Processor.run(Processor.java:178)
org.talend.designer.runprocess.java.AbstractJavaProcessor.run(AbstractJavaProcessor.java:272)
org.talend.designer.core.runprocess.Processor.run(Processor.java:136)
org.talend.designer.runprocess.shadow.ShadowProcess.runWithErrorOutputAsException(ShadowProcess.java:371)
org.talend.designer.runprocess.shadow.ShadowFilePreview.preview(ShadowFilePreview.java:86)
org.talend.metadata.managment.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:383)
org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep2Form$PreviewProcessor.nonUIProcessInThread(ExcelFileStep2Form.java:1042)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)

Re: Error on preview when loading excel file

Anonymous — Mon, 07 May 2018 15:46:59 GMT

I fixed by changing my .ini settings in the talend folder to:

-vmargs
-Xms512m
-Xmx1536m
-Dfile.encoding=UTF-8
-Dosgi.requiredJavaVersion=1.8
-XX:+UseG1GC
-XX:+UseStringDeduplication

Re: Error on preview when loading excel file

Anonymous — Wed, 09 May 2018 08:05:25 GMT

Hello,

Great it is fixed. Thanks for sharing it with us.

Best regards

Sabrina

Re: Error on preview when loading excel file

Anonymous — Thu, 11 Oct 2018 14:30:30 GMT

I had the same error, but my talend*.ini file looks exactly as your updated config..

-vmargs
-Xms512m
-Xmx1536m
-Dfile.encoding=UTF-8
-Dosgi.requiredJavaVersion=1.8
-XX:+UseG1GC
-XX:+UseStringDeduplication

Any idea? My version is 7.0.1

Capture.PNG

Re: Error on preview when loading excel file

Anonymous — Fri, 12 Oct 2018 03:26:20 GMT

Hello,

Does this issue repro on all your excel files or a specific one? For v6 of Talend products JDKv1.8 is required instead of JRE.

Please try to add -vm path to java bin in the .ini file(example: Talend-Studio-win-x86_64.ini)

Example:

-vm C:\Program Files\Java\jdk1.8.0_65 \bin

Best regards

Sabrina

Re: Error on preview when loading excel file

Anonymous — Fri, 12 Oct 2018 03:30:43 GMT

I tried with 2 Excel files. They contained same format. Let me update my Java and also the ini.

Will update again.

Re: Error on preview when loading excel file

Anonymous — Fri, 12 Oct 2018 04:54:52 GMT

Xdshi

I updated my system with a JDK and updated the ini file:

-vmargs
-Xms512m
-Xmx1536m
-Dfile.encoding=UTF-8
-Dosgi.requiredJavaVersion=1.8
-XX:+UseG1GC
-XX:+UseStringDeduplication
-vm C:\Program Files\Java\jdk1.8.0_181\bin

However, I am still running into the same issue.

Exception in thread "main" java.lang.Error: Unresolved compilation problem:

at chap_1.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.main(ShadowFileInputToDelimitedOutput.java:1276)

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.metadata.managment.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:383)
org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep2Form$PreviewProcessor.nonUIProcessInThread(ExcelFileStep2Form.java:1042)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)

Re: Error on preview when loading excel file

Anonymous — Mon, 15 Oct 2018 05:24:19 GMT

Any ideas how I can trace this issue? I installed Talend in another laptop and it worked. However I need it fo work on my main laptop. I tried using a CSV file and also had the same error.

Re: Error on preview when loading excel file

Anonymous — Mon, 15 Oct 2018 06:42:03 GMT

Hello,

What's OS are you using? Have you tried to re-install V 7.0.1 on your laptop to see if it works?

Best regards

Sabrina

Re: Error on preview when loading excel file

Anonymous — Tue, 16 Oct 2018 09:46:22 GMT

Hi Sabrina

I am running Talend Open Studio in Windows 10 Pro 64 bit. I have reinstalled and the outcome is the same. I know it worked on another laptop but I need to make it work on the current laptop. Also, I need to know how to troubleshoot such issues.

Re: Error on preview when loading excel file

Anonymous — Tue, 16 Oct 2018 09:47:31 GMT

Hi Sabrina

Thank you in advance.

Re: Error on preview when loading excel file

Anonymous — Tue, 16 Oct 2018 09:49:45 GMT

@xdshi wrote:

Hello,

What's OS are you using? Have you tried to re-install V 7.0.1 on your laptop to see if it works?

Best regards

Sabrina

Hi Sabrina

Thank you in advance.

Re: Error on preview when loading excel file

Anonymous — Wed, 17 Oct 2018 03:13:42 GMT

Hello,

We cannot repro this issue on Window 10, V 7.0.1 from our side. Could you please check the java version by typing : java - version in cmd to make sure your java environment is set correctly?

Best regards

Sabrina

Re: Error on preview when loading excel file

Anonymous — Wed, 17 Oct 2018 12:49:31 GMT

Sabrina

It turned out that the environment variable is not set correctly. I don't think JDK or JRE mattered.

Re: Error on preview when loading excel file

Anonymous — Fri, 19 Oct 2018 03:31:38 GMT

Hello,

For v6 of Talend products JDKv1.8 is required instead of JRE. If that requirement is met, ensure JDK bin is included in your PATH environment variable and is being reached.

Note:You have to install corresponding JDK, install 64bit JDK on 64bit system.

Best regards

Sabrina

Re: Error on preview when loading excel file

Anonymous — Mon, 05 Aug 2019 08:13:46 GMT

I have the same error and I fixed like you explain, but I dont understand why . Does it have any sense on it ? why is that the solution

Thanks Enrique

Re: Error on preview when loading excel file

Anonymous — Tue, 06 Aug 2019 10:17:15 GMT

Hello @Enrique1987.,

The JDK is the Java Development Kit. The JRE is the Java Runtime Environment. You actually get a JRE when you download the JDK. You cannot develop and compile with the JRE, you can only run your precompiled code. As such you need the JDK for your Studio.

Best regards

Sabrina

Re: Error on preview when loading excel file

jgomezal — Wed, 02 Oct 2019 22:46:47 GMT

Good afternoon. I'm from Colombia and my English is basic, but I need your help, because I was reading the "solutions" and I tried it, but my Talend is not working yet.

The problem is when I try to upload an Excel file to the Metadata Tree. Well, I tried to change the TOS_DI-win-x86_64.ini archive and others things in the Path with JDK and JRE. Please, help me!! Check the attached document to more information.

Error Message: The type java.lang.Object cannot be resolved. It is indirectly referenced from required .class files
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.metadata.managment.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:383)
org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep2Form$PreviewProcessor.nonUIProcessInThread(ExcelFileStep2Form.java:1042)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)

Error_Talend.pdf

Re: Error on preview when loading excel file

jgomezal — Thu, 03 Oct 2019 17:20:24 GMT

Buenos dias.

I could solve this issue. After to read differents post of this community, finally I understanded. My problem was my JRE version and my JDK version. Well, I installed the JDK correct and my JRE for 64 bits. Then, I changed my PATH and finally I changed the configuration in Talend: Window> Preference> Java> Installed JREs. There I included the JDK URL and it works.

Re: Error on preview when loading excel file

firdos4u — Mon, 31 Aug 2020 05:34:16 GMT

Where I will get .ini setting in talend folder