"ODI-40528: A java.lang.NullPointerException occurred saying: null Error" When Testing a LDAP Connection In ODI (Doc ID 1948234.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

Testing the LDAP Data Server connection in Oracle Data Integrator (ODI) throws the error message below:

ODI-40528: A java.lang.NullPointerException occurred saying: null

Testing the LDAP Data Server connection using an J2EE Agent, the following log details can be seen:

java.sql.SQLException: ODI-40528: A java.lang.NullPointerException occurred saying: null
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
  at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1243)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:173)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$400(SnpsDialogTestConnet.java:51)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:629)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:625)
  at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
  at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:947)
  at java.lang.Thread.run(Thread.java:745)

Caused by: java.sql.SQLException: ODI-40528: A java.lang.NullPointerException occurred saying: null
  at com.sunopsis.ldap.jdbc.driver.SnpsLdapRDBSchema.loadLdapToRdb(SnpsLdapRDBSchema.java:514)
  at com.sunopsis.ldap.jdbc.driver.SnpsLdapRDBSchema.addConn(SnpsLdapRDBSchema.java:291)
  at com.sunopsis.ldap.jdbc.driver.SnpsLdapConnection.<init>(SnpsLdapConnection.java:94)
  at com.sunopsis.ldap.jdbc.driver.SnpsLdapDriver.connect(SnpsLdapDriver.java:97)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:412)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:385)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:352)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:331)
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:110)
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
  at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87)
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:228)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
  at java.util.concurrent.FutureTask.run(FutureTask.java:262)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  ... 1 more

Caused by: java.lang.NullPointerException
  at com.sunopsis.ldap.model.mappers.SnpsLdapModelMapperGrouping.createTableHierarchyForElement(SnpsLdapModelMapperGrouping.java:204)
  at com.sunopsis.ldap.model.mappers.SnpsLdapModelMapperGrouping.createTableHierarchyForElement(SnpsLdapModelMapperGrouping.java:357)
  at com.sunopsis.ldap.model.mappers.SnpsLdapModelMapperGrouping.createTableHierarchyForElement(SnpsLdapModelMapperGrouping.java:357)
  at com.sunopsis.ldap.model.mappers.SnpsLdapModelMapperGrouping.createTableHierarchyForElement(SnpsLdapModelMapperGrouping.java:357)
  at com.sunopsis.ldap.model.mappers.SnpsLdapModelMapperGrouping.acceptModel(SnpsLdapModelMapperGrouping.java:120)
  at com.sunopsis.ldap.jdbc.driver.SnpsLdapRDBSchema.loadLdapToRdb(SnpsLdapRDBSchema.java:434)
  ... 16 more

Or you may see one of the following.

Observed for ODI 12.1.3:

oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: ODI-40528: A java.lang.NullPointerException occurred saying: null
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:336)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:899)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:688)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$1200(SnpsDialogTestConnet.java:51)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:665)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:658)
at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:947)
at java.lang.Thread.run(Thread.java:745)

  

Observed for ODI 11.1.1.7.0:

oracle.odi.runtime.agent.invocation.InvocationException: ODI-40528: A java.lang.NullPointerException occurred saying: null
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:265)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:780)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:584)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$10(SnpsDialogTestConnet.java:581)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:558)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:1)
at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)
at java.lang.Thread.run(Thread.java:662)

  

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms