topic Re: Unhandled Event Loop Exception java.lang.NullPointerException error in Data Quality

Unhandled Event Loop Exception java.lang.NullPointerException error

jong_lee — Tue, 28 Jun 2016 17:20:07 GMT

Hi all,
I'm trying to run a basic column analysis, and everything (from establishing JDBC connection to the SQL server all the way to selecting indicators) seems to work fine, but when I click "Run", Talend throws me this error:
!ENTRY org.eclipse.ui 4 0 2016-06-28 08:50:46.998
!MESSAGE Unhandled event loop exception
!STACK 0
java.lang.NullPointerException
at java.util.Hashtable.put(Unknown Source)
at org.talend.cwm.db.connection.ConnectionUtils.isConnectionAvailable(ConnectionUtils.java:235)
at org.talend.cwm.db.connection.ConnectionUtils.checkConnection(ConnectionUtils.java:147)
at org.talend.dataprofiler.core.ui.editor.analysis.AbstractAnalysisMetadataPage$6.handle(AbstractAnalysisMetadataPage.java:1035)
at org.talend.dataprofiler.core.ui.events.EventManager.publish(EventManager.java:123)
at org.talend.dataprofiler.core.ui.wizard.analysis.connection.ConnectionTypePage.publishSelectDataEvent(ConnectionTypePage.java:148)
at org.talend.dataprofiler.core.ui.wizard.analysis.connection.ConnectionTypePage.getNextPage(ConnectionTypePage.java:121)
at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:935)
at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:434)
at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:619)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4172)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3761)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:832)
at org.eclipse.jface.window.Window.open(Window.java:808)
at org.talend.dataprofiler.core.ui.editor.analysis.AbstractAnalysisMetadataPage$13.mouseDown(AbstractAnalysisMetadataPage.java:1378)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:192)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4172)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3761)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
at org.talend.dataprofiler.rcp.intro.Application.start(Application.java:78)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
Any suggestions as to why this is happening and the solution for it? I downloaded the latest Talend version V6.2.0, and Java version 1.8.0_91. I'm currently using sqljdbc4.jar driver with Windows Authentication.

Re: Unhandled Event Loop Exception java.lang.NullPointerException error

Anonymous — Wed, 29 Jun 2016 08:00:25 GMT

Hi,
Could you please try to use Java version 1.8.0_5 to see if it works?
It seems there is something wrong with Java version 1.8.0_9. What's your OS?
Best regards
Sabrina

Re: Unhandled Event Loop Exception java.lang.NullPointerException error

jong_lee — Tue, 12 Jul 2016 16:49:08 GMT

My OS is Windows 8, tried changing to java version 1.8.0_05, and still the same issue. Interestingly it's a very sporadic error; last time it worked, this time it doesn't.

Re: Unhandled Event Loop Exception java.lang.NullPointerException error

jong_lee — Tue, 12 Jul 2016 18:31:11 GMT

Also as an alternative, I've tried connecting to SQL Server by using the MSSQLServer Database type, but after 30s-1min trying to establish the connection, it results in this error:
Connection failure. You must change the Database Settings.
java.sql.SQLException: I/O Error: Connection reset
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2481)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:649)
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:371)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1063)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2638)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at net.sourceforge.jtds.ssl.TdsTlsInputStream.read(TdsTlsInputStream.java:72)
at sun.security.ssl.InputRecord.readFully(Unknown Source)
at sun.security.ssl.InputRecord.read(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readDataRecord(Unknown Source)
at sun.security.ssl.AppInputStream.read(Unknown Source)
at java.io.DataInputStream.readFully(Unknown Source)
at java.io.DataInputStream.readFully(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:850)
at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:731)
at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:477)
at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:114)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2368)
... 13 more
Settings are:
Login:
Password:
Server: <servername>
Port: 1433
Database: <databasename>
Schema: <schema>
Additional Parameters: instance=MSSQLSERVER;integrateSecurity=true;ssl=require;
Also have tried with a different server and works with this particular settings. So not sure what the issue is, as the server connects well with SQL Server Management Studio and all other Microsoft tools.

Re: Unhandled Event Loop Exception java.lang.NullPointerException error

jong_lee — Mon, 18 Jul 2016 17:35:21 GMT

Hi,
Still haven't heard in the past few days...what's happening?
Also will upgrading to TOS 6.2.1 solve this issue? Need an answer ASAP.
Thanks.

Re: Unhandled Event Loop Exception java.lang.NullPointerException error

Anonymous — Tue, 19 Jul 2016 08:13:11 GMT

Hi jong.lee,
Sorry for delay!

We cannot repro your issue on V 6.2. Is there any limitation or firewall on your side? What's Sql server version you are using?
Have you already tried to use V 6.2.1 to see if it works?
Best regards
Sabrina