OBIA 11.1.1.7.1 ODI connectivity issue

[Dinesh Chauhan]

Hello There,

                  I have installed BIAPPS 11.1.1.7.1 and running into problem when trying to connecting to Master/Work repository. After giving all the credentials(repository/db) when I press the test button,authentications passes i.e. I get 'Successful Connection' message but when I press OK button I receive below error.

 

1) I have created Master & Work repository using RCU for BI APPS (Bus_Analytics_Apps_Suite_RCU_Win64)

2) I belive I do not need to create any new Master/Work repository because RCU has already done so for me.

3) Please see attached snapshot files which confirm 'Successful Connection' & 'Error'.

4) Yes I have copied cwallet.sso & jps-config-jse.xml files from server to ODI studio & done the necessary changes to odi.conf file.

 

Any help/idea/pointer is highly appreciated.

 

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)

[Stewart Bryson]

Most likely, it's your JDK. What version are you using?

Sent from my iPhone

--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-met...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

<ODI_Connection_Success.bmp>

<ODI_Error.bmp>

[Dinesh Chauhan]

Its Java 1.6.0_26

--

Ph. +44-7466331834 (M)
     
     

[Dinesh Veera]

Do you have other ODI installations? If yes, you need a separate client install for each install of BI Apps. We have DEV, UAT and PROD and we have 3 client installs in 3 different locations.

If NOT, I would focus on the copied files and the config files. We had similar issues when we started our DEV environment and ODI would not recognize the repositories. Issue was due to our prior connection to a demo repository. Once we installed another ODI client, we got around the problem. 

This would be one of many challenges to overcome..Please beware!

[Naeem Akhtar]

TNS entries are Okay? And ODI server is running?

 

Naeem

--

[Dinesh Chauhan]

Thanks Dinesh & Naeem...Yes TNS names seems to be fine and I can see ODI server running on weblogic. Also odiconsole is all good.

I am going to re-install ODI again...however could you confirm what JDK version you are using... Also should I go for 32bit or 64 bit JDK ?

My client machine is Windows Server 2008 R2 Standard 64 Bit

--

Ph. +44-7466331834 (M)
     
     

[Dinesh Chauhan]

Hi,

       Just wanted to let you know that this issue has been resolved now with the help of Oracle Support Community. They suggested that remove this like from odi.conf and it worked for me.

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

Any idea what this command in odi.conf is suppose to do ?

--

Ph. +44-7466331834 (M)