Six Stars

error

Hi Team,

 

I have created one job. Loading .xls data to oracle table. 1:1 mapping.

 

I am getting below error.

 

Execution failed : Job compile errors
At least job "job_test" has a compile errors, please fix and export again.
Error Line: 2606
Detail Message: org.apache.poi.ss.usermodel.Cell 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.

 

How to resolve this error.

 

Regards

Shree

13 REPLIES
Twelve Stars TRF
Twelve Stars

Re: error

Click on the Code tab to access the generated Java code then go to the error line using the cross on the right margin. Move the mouse pointer over the cross on the left margin to display the compile error message.

TRF
Six Stars

Re: error

Hi David,

 

I am facing error all jobs. suddenly i am getting these error. 

 

Most of jobs i am getting.

 

Execution failed : Job compile errors
At least job "XXXX_job" has a compile errors, please fix and export again.
Error Line: 1336
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 feel any JRE path is missing?  How to set  path for JRE. I am using Talend bigdata 6.3 and JAVA 1.8._65.

 

Thanks

Shree

Six Stars

Re: error

Hi,

 

I am attaching screen shot for references.

 

Let me know if you need any information.

 

Thanks

Shree

 

Moderator

Re: error

Hello,

Did you follow up document about:TalendHelpCenter: Setting up the Java environment variable to set your java environment? Are you using JDK?

Environment variable for Java is usually JAVA_HOME.  You should  Install the 64-bit JDK and point your JAVA_HOME to the JDK.

Make sure the search order of the JDK bin folder in the PATH appears first for the JDK.

Let us know if it is OK with you.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: error

Hi Sabrina,

 

Yes, i am using jdk 1.8 version.

 

Attached file for your references. Can you tell me any changes are required.

 

Thanks

Shree

 

Moderator

Re: error

Hello,

It seems talend cannot recognize your system variables. Are you using the JDK executables and not the JRE ones?

Have you tried to reboot to see if it works?

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: error

Hi Sabira,

 

I have tried for  restarting machine and i am using JDK. Still error is exist.

 

Thanks

Shree

Moderator

Re: error

Hello,

We cannot repro your issue on our side. Would you mind re-installing you studio to see if it works?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: error

Hi Sabira,

 

Sure, I will try.

 

How to take backup all job which is created before.  What is best way to do it without losing jobs and metadata.

 

Thanks

Shree

Moderator

Re: error

Hello,

You can install a new studio in your local machine on different place(such as E:\Talend6.4) to see if this issue is caused by your java environment setting or studio installation.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: error

Hi Sabira.

 

I found the issue with tOutputExcel_1

 

 

tPostgresInput_1-------->tOutputExcel_1

 

Error Message:

 

[statistics] connecting to socket on port 4060
[statistics] connected
Exception in thread "main" java.lang.NoSuchFieldError: RETURN_NULL_AND_BLANK
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:209)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:235)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:240)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:210)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:185)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:271)
at org.talend.ExcelTool.prepareXlsxFile(ExcelTool.java:132)
at local_project.mtn_recon_12001_copy_0_1.MTN_RECON_12001_Copy.tPostgresqlInput_6Process(MTN_RECON_12001_Copy.java:8340)
at local_project.mtn_recon_12001_copy_0_1.MTN_RECON_12001_Copy.tPostgresqlSP_2Process(MTN_RECON_12001_Copy.java:7219)
at local_project.mtn_recon_12001_copy_0_1.MTN_RECON_12001_Copy.tPostgresqlInput_1Process(MTN_RECON_12001_Copy.java:6998)
at local_project.mtn_recon_12001_copy_0_1.MTN_RECON_12001_Copy.tPostgresqlSP_1Process(MTN_RECON_12001_Copy.java:4570)
at

 

Note: When i  run separete job it is working fine. 

if i run in main job inside i am getting above error.

 

Thanks

Shree 

Moderator

Re: error

Hello,

Are you referring to tfileoutputexcel component? This issue repro on your specific job not all jobs? Could you please post your current job design screenshot into forum? Which will be helpful for us to address your issue.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: error

Hi sabira,

 

Yes, tfileoutputexcel  component.

 

Attached screen shot for your references.

 

If i deselect the checkbox "Write excel 2007 file formats" and ".csv" it work for me.

 

if i select then i am getting error. I am looking in xlsx format output.

 

Thanks

Shree