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:
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!
[ad#ad-post]
Solution above solved my problem.
Thanks a lot Robert.
Solution above solved my problem.
Thanks a lot Robert.