My Oracle Support Banner

When SSL Is Being Used, the Repository Test Connection Doesn't Work in ODI Studio, But Login Is Possible (Doc ID 2472356.1)

Last updated on MAY 28, 2020

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 to 12.2.1.3.2 [Release 12c]
Information in this document applies to any platform.

Symptoms

The following error occurs when Oracle Data Integrator (ODI) 12c Studio is configured to use SSL, and attempting to test the connection to the Repositories:

java.lang.NullPointerException
   at java.util.Hashtable.put(Hashtable.java:459)
   at java.util.Properties.setProperty(Properties.java:166)
   at oracle.odi.ui.utils.OdiUiUtils.getSSLProperties(OdiUiUtils.java:1770)
   at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.createOdiInstanceConfigFromFields(SnpsDialogLoginDetail.java:1011)
   at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.testConnection(SnpsDialogLoginDetail.java:775)
   at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.access$400(SnpsDialogLoginDetail.java:71)
   at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail$2.performAction(SnpsDialogLoginDetail.java:311)
   at oracle.odi.ui.framework.event.OdiActionListener.actionPerformed(OdiActionListener.java:69)
   at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
   at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
   at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
   at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
   at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
   at java.awt.Component.processMouseEvent(Component.java:6533)
   at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
   at java.awt.Component.processEvent(Component.java:6298)
   at java.awt.Container.processEvent(Container.java:2236)
   at java.awt.Component.dispatchEventImpl(Component.java:4889)
   at java.awt.Container.dispatchEventImpl(Container.java:2294)
   at java.awt.Component.dispatchEvent(Component.java:4711)
   at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
   at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
   at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
   ...

The issue can be reproduced at will with the following steps:

  1. Configure ODI Studio for SSL
  2. Create a connection to a non-SSL enabled Database/Repositories
  3. Test the connection
  4. View the error popup
  5. Connection to the Repository is success, even though the Test Connection fails.

Changes

 SSL was configured for ODI Studio, but not for the database holding the Repositories.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.