error

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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 

[Anonymous]

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

[Anonymous]

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