Getting error when trying to creaate metadata for an Excel File

[Anonymous]

Hi All,

I am getting the below error, when i am trying to create a Metadata from an Excel file :

Exception in thread "main" java.lang.Error: Unresolved compilation problem:

at local_project_demo_1.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.main(ShadowFileInputToDelimitedOutput.java:1239)

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)

Thanks,

Naresh

[Anonymous]

Hello,

What's JDK version are you using? On which talend build version you got this issue? More information will be preferred.

Best regards

Sabrina

[Anonymous]

Hi,
Please find the required details below :
Java/JDK Version installed in my machine :
java version "1.8.0_201"Java(TM) SE Runtime Environment (build 1.8.0_201-b09)Java HotSpot(TM) 64-Bit Server VM (build 25.201-b09, mixed mode)

Talend Version on which i am getting this error :
Talend Open Studio for Data IntegrationVersion: 7.1.1

Can you please help me in resolving this issue ?
Thanks,
Naresh

[Anonymous]

Hi,

    Could you please change the encoding under Advanced settings of the component to UTF-8 and try again?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi,

i changed the encoding to UTF-8 and tried, but getting the below error. Have attached screenshot as well of same. Unable to create Metadata, can you please help me in resolving this :

Exception in thread "main" java.lang.Error: Unresolved compilation problem:

at local_project_demo_1.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.main(ShadowFileInputToDelimitedOutput.java:1239)

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)

Error_Screenshot.png

[manodwhb]

@nareshc1977 ,can you  check Read excel2007 file format,if you have not uncheck,if you check can you uncheck and let me know.

[Anonymous]

Hi Manohar,

I tried to uncheck the option "Read excel2007 file format" and create a Metadata, but still getting the below mentioned error, can you help in resolving it :

Exception in thread "main" java.lang.Error: Unresolved compilation problem:

at local_project_demo_1.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.main(ShadowFileInputToDelimitedOutput.java:1239)

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)

[Anonymous]

Hi Naresh,

    Could you please share a screen shot of your job flow, the component basic and advanced settings screenshot (of the component where you are getting error) and a sample file (after removing any confidential data)? These details will help us in faster analysis of the issue.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[akumar2301]

@nareshc1977 

Could you please try to add JDK bin   your PATH environment variable if it is not there?Also Keep it as 1st path inside.

 Let me know if it works

[Anonymous]

Hi Abhishek,

I tried adding the JDK Bin to the PATH, but still my issue is not getting resolved, got the same error, please find attached screenshot of the same. Not sure what causing the issue

Thanks,

Naresh

Screenshot.png