Err Creating Metadata from Excel, csv and utf8 encoded files on DI 6.1
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)
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
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
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
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)
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)
```
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
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 ??
