Unhandled Event Loop Exception java.lang.NullPointerException error

One Star

Unhandled Event Loop Exception java.lang.NullPointerException error

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.
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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.
One Star

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

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.
One Star

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

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.
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.