topic Re: Getting error when trying to creaate metadata for an Excel File in Talend Studio

Getting error when trying to creaate metadata for an Excel File

Anonymous — Wed, 20 Feb 2019 07:40:32 GMT

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

Re: Getting error when trying to creaate metadata for an Excel File

Anonymous — Wed, 20 Feb 2019 08:19:51 GMT

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

Re: Getting error when trying to creaate metadata for an Excel File

Anonymous — Wed, 20 Feb 2019 09:15:07 GMT

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

Re: Getting error when trying to creaate metadata for an Excel File

Anonymous — Wed, 20 Feb 2019 09:19:02 GMT

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 🙂

Re: Getting error when trying to creaate metadata for an Excel File

Anonymous — Fri, 22 Feb 2019 08:40:53 GMT

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)

Error_Screenshot.png

Re: Getting error when trying to creaate metadata for an Excel File

manodwhb — Fri, 22 Feb 2019 09:11:27 GMT

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

Re: Getting error when trying to creaate metadata for an Excel File

Anonymous — Sat, 02 Mar 2019 16:48:46 GMT

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)

Re: Getting error when trying to creaate metadata for an Excel File

Anonymous — Sun, 03 Mar 2019 16:12:30 GMT

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 🙂

Re: Getting error when trying to creaate metadata for an Excel File

akumar2301 — Sun, 03 Mar 2019 16:19:15 GMT

@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

Re: Getting error when trying to creaate metadata for an Excel File

Anonymous — Thu, 07 Mar 2019 07:10:06 GMT

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

Re: Getting error when trying to creaate metadata for an Excel File

Anonymous — Thu, 07 Mar 2019 07:32:33 GMT

Hi,

It seems you have mapped to Java 11. Could you please map to 8 and try?

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 🙂

Re: Getting error when trying to creaate metadata for an Excel File

François_T — Wed, 19 Jun 2019 11:03:40 GMT

We are having the same problem with an up to date 7.1.1 integration studio. It's failing to recognize any metadata, from XLSX, XLS, or even CSV. Same error message. We are using a V8 Oracle java. Do you know any solution to this problem ?