Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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