Delimited File Preview error to load to table

[Anonymous]

Hi All,
Earlier i could able to load data from delimited flat file(*.txt, *.csv, *.xls) to table, but suddenly I m facing below error. Even i couldnt able to preview the delimited file. Can anyone help on this?
Output not generated.
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.repository.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:383)
org.talend.repository.ui.wizards.metadata.connection.files.delimited.DelimitedFileStep2Form$PreviewProcessor.nonUIProcessInThread(DelimitedFileStep2Form.java:1246)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)
Thanks
Kavitha L

[Anonymous]

Hi Sabrina,
Thanks for your quick response.
I had previously tried this in version 7.0.1 and had the same issue, I tried upgrading to the latest version to see if the issue remained, and it did ☹
Thanks

[Anonymous]

Hello @dean_l,

Does this issue reproduce on all your input delimited files or a specific one?

For v6 of Talend products oracle JDKv1.8 is required instead of JRE. If that requirement is met, ensure JDK bin is included in your PATH environment variable and is being reached.

Best regards

Sabrina

[Anonymous]

Hi Sabrina,
It is the same error for each of the files that I am using.
I am using 1.8 JDK, and have input the variable and referenced it in the path system variable.
Can you explain how I can check to see if the path is reached?
Kind Regards

[Anonymous]

Hello,

Have you tried to type java -version in cmd to see if your java environment is set correctly?

Did you have different JDK versions on same machine? If you want to use Java 1.8 version for your Talend Open Studio. Please do following steps.

 1) Install oracle Java 1.8 version.

2) Copy bin location ex : C:\Program Files\Java\jdk1.8.0_xx\bin.

3) Go to the Talend Setup directory and open TOS_DI-win-x86_64.ini file.

4) paste java location with following parameter in the TOS_DI-win-x86_64.ini file.

     -vm
    C:\Program Files\Java\jdk1.8.0_xx\bin

5) Save the file and close.

Best regards

Sabrina

[Anonymous]

Hello @dean_l,

Please avoid to install the application in the Program Files directory. Make sure there is no space and illegal character in your installation path.

Best regards

Sabrina

[Anonymous]

Hi Sabrina,
I have gone through an double checked your suggestions and it is sat out as below:
Version showing in CMD Prompt:
[cid:image001.png@01D4571D.FA8E12B0]
JAVA_HOME = C:\Program Files\Java\jdk1.8.0_181
Added to the end of path = ;%JAVA_HOME%\bin
Install location = C:\TalendOS\TOS_DI-Win32-20180829_1603-V7.1.1M3
Added to TOS_DI-win-x86_64.ini =
[cid:image002.png@01D45720.7AA63570]
Config within TalendOS =
[cid:image003.png@01D45720.B36CF7E0]
(This is the same config within talend OS that works on another instance)
☹ - Same outcome
Kind Regards
Dean

[Anonymous]

Apologies, images didn't come through from my email.

[Anonymous]

Hello,

The java environment is set correctly without error.

Please set the encoding as UTF-8 to see if it is OK with you?

Best regards

Sabrina

[Anonymous]

Hi Sabrina,

I still get the same error message unfortunately.

Thanks

Dean

[Anonymous]

Hi Sabrina,

A bit more information, I uninstalled TOS and re-installed using a local admin on the machine, rather than the domain admin that I was using previously and all worked fine.

Unfortunately, I need it to work for the domain admin, any ideas?

Kind Regards

Dean