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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

jxl cannot be resolved to a type

Hi,
I'm running Talend Open Studio for Big Data 6.3 (64bit version) and trying to import from an Excel file (97-2003 format) into a SQL Server DB. When I try to run the job I get the following error message:
Execution failed : Job compile errors 

At least job "Excel_Import_to_Epicor" has a compile errors, please fix and export again.
Error Line: 1393
Detail Message: jxl cannot be resolved to a type
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.


I also tried to create a  Metadata - File Excel  but when I get to step 3 I get the following error message:
Error: Could not find or load main class epicor_audit.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput
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)

This error message is more detailed so I hope it helps isolate the issue.

I can see the data correctly in step 2 but get an error in step 3 when previewing the data.
I'm using Java v1.8 update 121
Labels (3)
12 Replies
Anonymous
Not applicable
Author

@Tanmay40 , what is your JDK version? V6.3 is a little old, make sure you are using a corresponding supported JDK version 1.6.

Anonymous
Not applicable
Author

Replaced my jxl.jar file with another user. Working fine now.

 

Thank you,

Anonymous
Not applicable
Author

My current version of JDK - Java(TM) SE Runtime Environment (build 1.8.0_201-b09)