topic Err Creating Metadata from Excel, csv and utf8 encoded files on DI 6.1 in Talend Studio

Err Creating Metadata from Excel, csv and utf8 encoded files on DI 6.1

Anonymous — Wed, 09 Mar 2016 20:21:59 GMT

The issue also affected me trying to create metadata from an xml file
When I run through the metadata excel wizard and select either a Office 2013 excel file (based off an xml file), a csv export of the excel file or the csv saved using notepad and selecting utf8 encoding when saving I get the error below
During the wizard the file contents are shown when I initially select the file but when I go to preview the contents I get the error marked Error 2
When I try to see the installation history dialog I get error 1 as shown in the attached screen shot
Error 1

An internal error occurred during: "Fetching Elements".
java.lang.NullPointerException

Error 2

java.lang.NoClassDefFoundError: Integer
	at java.lang.Class.getDeclaredMethods0(Native Method)
	at java.lang.Class.privateGetDeclaredMethods(Unknown Source)
	at java.lang.Class.privateGetMethodRecursive(Unknown Source)
	at java.lang.Class.getMethod0(Unknown Source)
	at java.lang.Class.getMethod(Unknown Source)
	at sun.launcher.LauncherHelper.validateMainClass(Unknown Source)
	at sun.launcher.LauncherHelper.checkAndLoadMain(Unknown Source)
Caused by: java.lang.ClassNotFoundException: Integer
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	... 7 more

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.delimited.DelimitedFileStep2Form$PreviewProcessor.nonUIProcessInThread(DelimitedFileStep2Form.java:1309)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)
java.lang.NoClassDefFoundError: Integer
	at java.lang.Class.getDeclaredMethods0(Native Method)
	at java.lang.Class.privateGetDeclaredMethods(Unknown Source)
	at java.lang.Class.privateGetMethodRecursive(Unknown Source)
	at java.lang.Class.getMethod0(Unknown Source)
	at java.lang.Class.getMethod(Unknown Source)
	at sun.launcher.LauncherHelper.validateMainClass(Unknown Source)
	at sun.launcher.LauncherHelper.checkAndLoadMain(Unknown Source)
Caused by: java.lang.ClassNotFoundException: Integer
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	... 7 more

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.delimited.DelimitedFileStep2Form$PreviewProcessor.nonUIProcessInThread(DelimitedFileStep2Form.java:1309)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)

Re: Err Creating Metadata from Excel, csv and utf8 encoded files on DI 6.1

Anonymous — Thu, 10 Mar 2016 10:54:22 GMT

The xml file was originally created on a mac but copies over the network to windows before importing into Excel 2013 on windows and from there creating the csv files

Using Rapidminer 5 I can read the csv and excel file contents so it doesn't appear to be the file itself

Any suggestions how I can get the data into Talend DI

Re: Err Creating Metadata from Excel, csv and utf8 encoded files on DI 6.1

Anonymous — Sat, 12 Mar 2016 16:14:12 GMT

I think it was down to me not using Java 8 JDK as when I installed it and configured Talend to use it over the other java version on my system I was able to read the Excel correctly. Prior to this I was also getting errors when trying to read from MySQL database but no errors when I started up Talend or designed a job

The error listed as Error 1 still occurs but at least now I can read files and data

Re: Err Creating Metadata from Excel, csv and utf8 encoded files on DI 6.1

Anonymous — Wed, 06 Apr 2016 00:04:13 GMT

I am experiencing the same issue when trying to import a CSV file that is UTF-8 encoded.
I am on Win64 with JDK 8 u77 with a fresh install of TOS_DI-20151214_1327-V6.1.1
-Mark

Re: Err Creating Metadata from Excel, csv and utf8 encoded files on DI 6.1

Anonymous — Wed, 06 Apr 2016 00:05:14 GMT

Any other suggestions ? I have already tried switching from JRE to JDK.

Re: Err Creating Metadata from Excel, csv and utf8 encoded files on DI 6.1

_AnonymousUser — Wed, 06 Apr 2016 11:23:38 GMT

Hi,
I an on Windows 7, TOS_DI_6.1.1_20151214_1327 installed on "C:\" directory, Java 8.
I am the same problem.
I try to add File delimited metadata and at the overview I have the error :
java.lang.NoClassDefFoundError: Integer
at java.lang.Class.getDeclaredMethods0(Native Method)
at java.lang.Class.privateGetDeclaredMethods(Unknown Source)
at java.lang.Class.privateGetMethodRecursive(Unknown Source)
at java.lang.Class.getMethod0(Unknown Source)
at java.lang.Class.getMethod(Unknown Source)
at sun.launcher.LauncherHelper.validateMainClass(Unknown Source)
at sun.launcher.LauncherHelper.checkAndLoadMain(Unknown Source)
Caused by: java.lang.ClassNotFoundException: Integer
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 7 more
Error: A JNI error has occurred, please check your installation and try again

Erreur de prévisualisation. Des paramètres doivent être modifiés`
Note : Les erreurs de prévisualisation sont généralement liées à un mauvais paramétrage de l'encodage.
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.delimited.DelimitedFileStep2Form$PreviewProcessor.nonUIProcessInThread(DelimitedFileStep2Form.java:1309)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)

Re: Err Creating Metadata from Excel, csv and utf8 encoded files on DI 6.1

Anonymous — Wed, 06 Apr 2016 11:34:38 GMT

Hi,
I an on Windows 7, TOS_DI_6.1.1_20151214_1327 installed on "C:\" directory, Java 8.
I am the same problem.

I try to add File delimited metadata and at the overview I have the error :

```
java.lang.NoClassDefFoundError: Integer
at java.lang.Class.getDeclaredMethods0(Native Method)
at java.lang.Class.privateGetDeclaredMethods(Unknown Source)
at java.lang.Class.privateGetMethodRecursive(Unknown Source)
at java.lang.Class.getMethod0(Unknown Source)
at java.lang.Class.getMethod(Unknown Source)
at sun.launcher.LauncherHelper.validateMainClass(Unknown Source)
at sun.launcher.LauncherHelper.checkAndLoadMain(Unknown Source)
Caused by: java.lang.ClassNotFoundException: Integer
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 7 more
Error: A JNI error has occurred, please check your installation and try again
Erreur de prévisualisation. Des paramètres doivent être modifiés`
Note : Les erreurs de prévisualisation sont généralement liées à un mauvais paramétrage de l'encodage.
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.delimited.DelimitedFileStep2Form$PreviewProcessor.nonUIProcessInThread(DelimitedFileStep2Form.java:1309)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)
```

Re: Err Creating Metadata from Excel, csv and utf8 encoded files on DI 6.1

Anonymous — Wed, 06 Apr 2016 14:10:04 GMT

When I try on Windows 10, same Talend version TOS_DI_6.1.1_20151214_1327 installed on "C:\" directory and Java 8 (build 1.8.0_66-b18), that's all good.
:-(
There is a metter to test good configuration of Talend on the machine?
Thanks for all help
Massimo

Re: Err Creating Metadata from Excel, csv and utf8 encoded files on DI 6.1

Anonymous — Thu, 07 Apr 2016 07:51:37 GMT

Hi,
I solved the proble by upgrade
Java 1.8.0 up 45
to
1.8.0 up 77

Regards
Massimo

Re: Err Creating Metadata from Excel, csv and utf8 encoded files on DI 6.1

Anonymous — Sun, 12 Jun 2016 21:11:30 GMT

Hi,

I have windows 10 and installed Talend "Talend-Tools-Studio-20151214_1327-V6.1.1" and also Java i have the latest version
C:\WINDOWS\system32>java -version
java version "1.8.0_91"
Java(TM) SE Runtime Environment (build 1.8.0_91-b15)
Java HotSpot(TM) Client VM (build 25.91-b15, mixed mode, sharing)
When i try creating csv file delimited metadata getting below error and not able to preview the results.

java.lang.NoClassDefFoundError: Exception
at java.lang.Class.getDeclaredMethods0(Native Method)
at java.lang.Class.privateGetDeclaredMethods(Unknown Source)
at java.lang.Class.privateGetMethodRecursive(Unknown Source)
at java.lang.Class.getMethod0(Unknown Source)
at java.lang.Class.getMethod(Unknown Source)
at sun.launcher.LauncherHelper.validateMainClass(Unknown Source)
at sun.launcher.LauncherHelper.checkAndLoadMain(Unknown Source)
Caused by: java.lang.ClassNotFoundException: Exception
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 7 more
Error: A JNI error has occurred, please check your installation and try again

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.delimited.DelimitedFileStep2Form$PreviewProcessor.nonUIProcessInThread(DelimitedFileStep2Form.java:1300)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)

Please suggest, what should i do to overcome this issue ??

Thanks,
Sreedevi

Re: Err Creating Metadata from Excel, csv and utf8 encoded files on DI 6.1

Anonymous — Fri, 24 Jun 2016 11:24:14 GMT

I get some problem when I try to add File delimited metadata, too. I have TOS-DI-20151214_1327-V6.1.1 as well, java version "1.7.0_67". And here is the Exception:
java.lang.NoClassDefFoundError: Exception
    at java.lang.Class.getDeclaredMethods0(Native Method)
    at java.lang.Class.privateGetDeclaredMethods(Unknown Source)
    at java.lang.Class.getMethod0(Unknown Source)
    at java.lang.Class.getMethod(Unknown Source)
    at sun.launcher.LauncherHelper.getMainMethod(Unknown Source)
    at sun.launcher.LauncherHelper.checkAndLoadMain(Unknown Source)
Caused by: java.lang.ClassNotFoundException: Exception
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    ... 6 more

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.delimited.DelimitedFileStep2Form$PreviewProcessor.nonUIProcessInThread(DelimitedFileStep2Form.java:1309)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)