You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-06-28 17:20:07

jong.lee
Member
4 posts

jong.lee said:

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.

Offline

#2 2016-06-29 08:00:25

xdshi
Talend Team


xdshi said:

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


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2016-07-12 16:49:08

jong.lee
Member
4 posts

jong.lee said:

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.

Offline

#4 2016-07-12 18:31:11

jong.lee
Member
4 posts

jong.lee said:

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.

Offline

#5 2016-07-18 17:35:21

jong.lee
Member
4 posts

jong.lee said:

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.

Offline

#6 2016-07-19 08:13:11

xdshi
Talend Team


xdshi said:

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


What we can do is to make sure that Talend will be your best choice!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy