topic Re: error in Talend Studio

error

Anonymous — Mon, 21 Aug 2017 10:48:33 GMT

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

Re: error

TRF — Mon, 21 Aug 2017 13:48:12 GMT

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.

Re: error

Anonymous — Tue, 22 Aug 2017 04:39:31 GMT

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

Re: error

Anonymous — Tue, 22 Aug 2017 04:46:57 GMT

Hi,

I am attaching screen shot for references.

Let me know if you need any information.

Thanks

Shree

java version.PNG
No jdk found.PNG

Re: error

Anonymous — Tue, 22 Aug 2017 07:14:26 GMT

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

Re: error

Anonymous — Tue, 22 Aug 2017 07:32:58 GMT

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

env setup.PNG

Re: error

Anonymous — Tue, 22 Aug 2017 08:40:30 GMT

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

Re: error

Anonymous — Tue, 29 Aug 2017 07:53:03 GMT

Hi Sabira,

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

Thanks

Shree

Re: error

Anonymous — Tue, 29 Aug 2017 08:09:17 GMT

Hello,

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

Best regards

Sabrina

Re: error

Anonymous — Tue, 29 Aug 2017 08:33:04 GMT

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

Re: error

Anonymous — Tue, 29 Aug 2017 09:05:27 GMT

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

Re: error

Anonymous — Mon, 11 Sep 2017 06:28:32 GMT

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

Re: error

Anonymous — Mon, 11 Sep 2017 07:37:31 GMT

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

Re: error

Anonymous — Mon, 11 Sep 2017 10:27:57 GMT

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

screen shot 1.PNG
screen shot 2.PNG