oracle.odi.core.security.BadCredentialsException: ODI-10163: This OPSS user biappadmin has different

Question

Hi All,

I am trying to connect the work repository from through the ODI Studio at that i am facing the below error.

Version for OBIA Apps .

OBIA Apps -- 11.1.1.10.1

ODI----11.1.1.9.0

OBIEE--11.1.1.9.0

oracle.odi.core.security.BadCredentialsException: ODI-10163: This OPSS user biappadmin has different GUID than the one found in Oracle Data Integrator repository.

at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:511)

at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:252)

at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.testConnection(SnpsDialogLoginDetail.java:754)

at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.access$4(SnpsDialogLoginDetail.java:736)

at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail$2.performAction(SnpsDialogLoginDetail.java:280)

at oracle.odi.ui.framework.event.OdiActionListener.actionPerformed(OdiActionListener.java:69)

at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)

at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)

at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)

at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)

at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)

at java.awt.Component.processMouseEvent(Component.java:6297)

at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)

at java.awt.Component.processEvent(Component.java:6062)

at java.awt.Container.processEvent(Container.java:2039)

at java.awt.Component.dispatchEventImpl(Component.java:4660)

at java.awt.Container.dispatchEventImpl(Container.java:2097)

at java.awt.Component.dispatchEvent(Component.java:4488)

at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)

at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)

at java.awt.Container.dispatchEventImpl(Container.java:2083)

at java.awt.Window.dispatchEventImpl(Window.java:2489)

at java.awt.Component.dispatchEvent(Component.java:4488)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:674)

at java.awt.EventQueue.access$400(EventQueue.java:81)

at java.awt.EventQueue$2.run(EventQueue.java:633)

at java.awt.EventQueue$2.run(EventQueue.java:631)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)

at java.awt.EventQueue$3.run(EventQueue.java:647)

at java.awt.EventQueue$3.run(EventQueue.java:645)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:644)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)

at java.awt.Dialog$1.run(Dialog.java:1052)

at java.awt.Dialog$3.run(Dialog.java:1104)

at java.security.AccessController.doPrivileged(Native Method)

at java.awt.Dialog.show(Dialog.java:1102)

at java.awt.Component.show(Component.java:1591)

at java.awt.Component.setVisible(Component.java:1543)

at java.awt.Window.setVisible(Window.java:843)

at java.awt.Dialog.setVisible(Dialog.java:987)

at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:395)

at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:356)

at oracle.odi.ui.framework.adapter.DefaultAdapter.displayDialog(DefaultAdapter.java:242)

at oracle.odi.ui.framework.UIFramework.displayDialog(UIFramework.java:90)

at oracle.odi.ui.LoginFactory.createNewLogin(LoginFactory.java:443)

at oracle.odi.ui.gallery.CreateNewOdiMasterWizard.invoke(CreateNewOdiMasterWizard.java:53)

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:1088)

at oracle.javatools.util.SwingUtils.invokeAfterRepaint(SwingUtils.java:509)

at oracle.ide.util.IdeUtil.invokeAfterRepaint(IdeUtil.java:1101)

at oracle.ide.wizard.WizardManager$2.run(WizardManager.java:428)

at oracle.ide.util.IdeUtil$3.run(IdeUtil.java:1088)

at oracle.javatools.util.SwingUtils.invokeAfterRepaint(SwingUtils.java:509)

at oracle.ide.util.IdeUtil.invokeAfterRepaint(IdeUtil.java:1101)

at oracle.ide.wizard.WizardManager.invokeSecondaryWizard(WizardManager.java:424)

at oracle.ide.gallery.ObjectGallery.invokeWizard(ObjectGallery.java:389)

at oracle.ide.gallery.ObjectGallery.runDialog(ObjectGallery.java:202)

at oracle.ide.gallery.ObjectGallery.runDialog(ObjectGallery.java:122)

at oracle.ide.gallery.ObjectGalleryAddin._invokeGallery(ObjectGalleryAddin.java:405)

at oracle.ide.gallery.ObjectGalleryAddin.handleEvent(ObjectGalleryAddin.java:208)

at oracle.ide.controller.IdeAction.performAction(IdeAction.java:529)

at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:897)

at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:501)

at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)

at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)

at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)

at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)

at javax.swing.AbstractButton.doClick(AbstractButton.java:357)

at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809)

at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850)

at java.awt.Component.processMouseEvent(Component.java:6297)

at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)

at java.awt.Component.processEvent(Component.java:6062)

at java.awt.Container.processEvent(Container.java:2039)

at java.awt.Component.dispatchEventImpl(Component.java:4660)

at java.awt.Container.dispatchEventImpl(Container.java:2097)

at java.awt.Component.dispatchEvent(Component.java:4488)

at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)

at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)

at java.awt.Container.dispatchEventImpl(Container.java:2083)

at java.awt.Window.dispatchEventImpl(Window.java:2489)

at java.awt.Component.dispatchEvent(Component.java:4488)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:674)

at java.awt.EventQueue.access$400(EventQueue.java:81)

at java.awt.EventQueue$2.run(EventQueue.java:633)

at java.awt.EventQueue$2.run(EventQueue.java:631)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)

at java.awt.EventQueue$3.run(EventQueue.java:647)

at java.awt.EventQueue$3.run(EventQueue.java:645)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:644)

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)

Regards,

Chandra

Syedsalmancs110 · Answer

Hi Chandra,

First make sure you are aware of your biappadmin user password , if you are aware of same then first try and login into Admin Console(http://machinename:port/console) with user biappadmin this should work if your password entered is correct as biappadmin is by default member of "Administrator" group which give it access of Admin Console.

Once above is verified then follow below steps:

A.
Open ODI Studio (in primary instance)  don't connect to repository> Go to option ODI on Tool Bar > Switch Authentication Mode, then enter the connection  information for the Master database schema and the SUPERVISOR(biappadmin ) password  and click OK to switch the authentication mode to internal.

B.
Now again switch the authentication back to external  authentication by Go to option ODI on Tool Bar > Switch Authentication Mode which should update the GUID in the Master Repository.
The GUID is updated when switching the authentication mode from external to internal and back.
You now have a valid GUID which is matching the information from primary LDAP.

C.
Now since GUID's has been updated you need to generate new security files to login into ODI Studio, follow steps in below mentioned link uder section "Regenerating the Security Files"

http://docs.oracle.com/cd/E53672_01/doc.111191/e53673/GUID-0EAF50FB-0A44-4E88-B3B1-09A5F3E806D2.htm#BIAIN24665

D.
Once new security files are generated then copy the same on client location and check connection through ODI Studio.

Thanks and Regards,

Syed Hamd Salman