Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover the Trends Shaping AI in 2026: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error on preview when loading excel file

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)
Labels (3)
20 Replies
Anonymous
Not applicable
Author

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.

 

Thank you in advance.

Anonymous
Not applicable
Author


@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

 

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.

 

Thank you in advance.

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Sabrina

 

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

 

 

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Hi 

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

Anonymous
Not applicable
Author

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

jgomezal
Contributor
Contributor

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
jgomezal
Contributor
Contributor

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.

firdos4u
Contributor
Contributor

Where I will get .ini setting in talend folder