topic Re: jxl cannot be resolved to a type in Talend Studio

jxl cannot be resolved to a type

Anonymous — Sat, 16 Nov 2024 10:06:27 GMT

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

Re: jxl cannot be resolved to a type

Anonymous — Mon, 06 Feb 2017 01:33:23 GMT

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.

Did you get this issue on a 97-2003 format excel file only or all excel files? Could you please show us your tfileinputexcel component setting screenshot?
Best regards
Sabrina

Re: jxl cannot be resolved to a type

Anonymous — Mon, 06 Feb 2017 15:17:43 GMT

Hi Sabrina,
I got the issue with all Excel formats. After the 97-2003 format failed I tried the 2007 format. I also tried to import it as a CSV file and still got same error.

From the first time I received the error I double checked if I was missing any modules. I installed the required third-party libraries and when I run the job I get the following error message instead of what I originally posted:
Execution failed : Job compile errors
At least job "Excel_Import_to_Epicor" has a compile errors, please fix and export again.
Error Line: 1401
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.

Re: jxl cannot be resolved to a type

Anonymous — Tue, 07 Feb 2017 11:13:26 GMT

Hi,
We cannot repro this issue on our side.
Have you ever successfully executed ANY job in your Talend Open Studio for Big Data 6.3 (64bit version)? Did you install your talend studio completely?
Best regards
Sabrina

Re: jxl cannot be resolved to a type

Anonymous — Tue, 07 Feb 2017 15:04:22 GMT

No, I wasn't able to successfully execute any jobs.
The Big Data v6.3 I downloaded wasn't an install, I just had to extract it. I downloaded the Data Integration v6.3 which did an install but I also get the same error message.
This is the Big Data v6.3: TOS_BD-20161216_1026-V6.3.1.zip
This is the Data Integration v6.3 I also tried: TOS_DI-Win32-20161216_1026-V6.3.1.exe

Re: jxl cannot be resolved to a type

Anonymous — Fri, 10 Feb 2017 02:00:11 GMT

Hi,
Could you please re-unzip (7 zip, Winrar)your TOS_BD-20161216_1026-V6.3.1.zip file and install it on your machine completely to see if your studio works?

TOS_DI-Win32-20161216_1026-V6.3.1.exe

You need to download TOS_DI-20161216_1026-V6.3.1.zip file from talend website.
https://www.talend.com/download/talend-open-studio/
Best regards
Sabrina

Re: jxl cannot be resolved to a type

Anonymous — Wed, 15 Feb 2017 18:43:29 GMT

Hi,
Could you please re-unzip (7 zip, Winrar)your TOS_BD-20161216_1026-V6.3.1.zip file and install it on your machine completely to see if your studio works?
TOS_DI-Win32-20161216_1026-V6.3.1.exe

You need to download TOS_DI-20161216_1026-V6.3.1.zip file from talend website.
Best regards
Sabrina

I tried the link but I'm only getting the TOS_DI-Win32-20161216_1026-V6.3.1.exe file. It doesn't give me the option to download the TOS_DI-20161216_1026-V6.3.1.zip file. I'll try and re-unzip the TOS_BD-20161216_1026-V6.3.1.zip.

Re: jxl cannot be resolved to a type

Anonymous — Wed, 15 Feb 2017 20:37:17 GMT

Sabrina,
I managed to get it to work. I forgot to mention that I had Studio DI v6.1 before but received a new PC and installed the latest v6.3. I was pointing the working folder to my old project folder but this time I imported it. This seemed to work!
Do you always need to import your old projects? I didn't think there would be a difference between v6.1 and v6.3.

Re: jxl cannot be resolved to a type

Anonymous — Thu, 16 Feb 2017 08:21:38 GMT

Hi,
Usually, we export our old project from old studio and then import it into an upper version.
Best regards
Sabrina

Re: jxl cannot be resolved to a type

Anonymous — Tue, 24 Dec 2019 00:25:03 GMT

I am also having same issue. i have TOS v.6.3 when i am exporting data to FileOutputExcel from ExtractXMLFeild.
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.

Re: jxl cannot be resolved to a type

Anonymous — Tue, 24 Dec 2019 03:30:27 GMT

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

Re: jxl cannot be resolved to a type

Anonymous — Wed, 25 Dec 2019 04:54:34 GMT

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

Thank you,

Re: jxl cannot be resolved to a type

Anonymous — Wed, 25 Dec 2019 05:01:02 GMT

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