ODI Studio New Connection Error when Saving

I was having an issue when trying to make a new connection within ODI Studio (11.1.1.x). I would define all of the connection details and information, click test, and get the sucessful test message. But when clicking Save, I would get an error:

ODI_Error ODI_Error2

java.lang.NullPointerException
 at oracle.odi.ui.gallery.CreateNewOdiMasterWizard.invoke(CreateNewOdiMasterWizard.java:51)
 at oracle.ide.wizard.WizardManager.invokeWizard(WizardManager.java:372)
 at oracle.ide.wizard.WizardManager$1.run(WizardManager.java:420)
 at oracle.ide.util.IdeUtil$3.run(IdeUtil.java:1089)
 at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
 at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:666)
 at java.awt.EventQueue.access$400(EventQueue.java:81)
 at java.awt.EventQueue$2.run(EventQueue.java:627)
 at java.awt.EventQueue$2.run(EventQueue.java:625)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:636)
 at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
 at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
 at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

I stumbled across this forum post (https://groups.google.com/forum/#!topic/obiee-enterprise-methodology/SGsSSDjDEao) which provided the solution for my issue. It seems that a java update might have started the problem with ODI. I have no idea why this config fixes it, but it does. I hope this helps someone else.

Close the ODI Studio client. Edit and remove the following line from the E:\Oracle\Middleware\Oracle_ODI1\oracledi\client\odi\bin\odi.conf:

AddVMOption -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration

My final odi.conf looked like the following:

IncludeConfFile ../../ide/bin/ide.conf
AddVMOption -XX:MaxPermSize=256M
AddVMOption -Doracle.core.ojdl.logging.config.file=ODI-logging-config.xml
AddVMOption -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger
AddJavaLibFile ../../../../oracledi.sdk/lib/ojdl.jar
AddJavaLibFile ../../../../oracledi.sdk/lib/dms.jar
AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/log4j-1.2.8.jar
AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/odi_hfm.jar
AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/odihapp_common.jar
AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/ess_es_server.jar
AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/ess_japi.jar
AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/odihapp_essbase.jar
AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/odihapp_planning.jar
AddVMOption -Dnative.canonicalization=false
AddVMOption -Doracle.security.jps.config=./jps-config.xml
AddVMOption -Doracle.odi.studio.ess=false
AddVMOption -Dide.AssertCheckingDisabled=true
AddVMOption -Dide.AssertTracingDisabled=true
AddVMOption -DLOG_FILE=studio.log
AddVMOption -Dsun.java2d.noddraw=true
SetJavaHome E:\Oracle\Middleware\jdk160_29

Good Luck!

Please follow and like us:

One Comment

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.