12 Replies Latest reply on Mar 27, 2014 4:44 AM by Sagar Tippe

    oraclediagent failed after install OBIA 11.1.1.7.1

    Alvaro Soares

      I have installed and configured Oracle Business Intelligence Applications 11.1.1.7.1. During the OBIA configuration, I've got error at ODI step and I've got to continue until it ends. However, the ODI steps I've got to make manually.

      All services appears to be running as well, except by oraclediagent that shows failure at Weblogic.  When I test the oraclediagent connection at ODI Studio, the following error appears :

       

       

      oracle.odi.runtime.agent.invocation.InvocationException: ODI-1425: Agent application cannot be reached using http://MYSERVER:15001/oraclediagent.

      at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.reThrowAgentErrorAsInvocation(RemoteRuntimeAgentInvoker.java:1301)

      at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:243)

      at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeIsAlive(RemoteRuntimeAgentInvoker.java:428)

      at oracle.odi.ui.action.SnpsPopupActionTestAgentHandler.actionPerformed(SnpsPopupActionTestAgentHandler.java:65)

      at com.sunopsis.graphical.frame.edit.EditFrameSnpAgent.jButtonTestAgent_ActionPerformed(EditFrameSnpAgent.java:990)

      at com.sunopsis.graphical.frame.edit.EditFrameSnpAgent.connEtoC2(EditFrameSnpAgent.java:212)

      at com.sunopsis.graphical.frame.edit.EditFrameSnpAgent$IvjEventHandler.actionPerformed(EditFrameSnpAgent.java:160)

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

      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.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)

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

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

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

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

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

      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)

      Caused by: ODI-1425: Agent application cannot be reached using http://MYSERVER:15001/oraclediagent.

      at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:244)

      ... 41 more

       

      Also, my schema <prefix>_DW is been locked by some process and everytime I have to unlock this schema at database server.

       

      My environment is Linux Red Hat 5.3 using oracle database server Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit.

       

      Does someone could help me ?

       

       

      Thanks

        • 1. Re: oraclediagent failed after install OBIA 11.1.1.7.1
          Alvaro Soares

          Just to complement....I've been considering to re-deploy the oraclediagent.ear  but I'm afraid it will work...

          • 2. Re: oraclediagent failed after install OBIA 11.1.1.7.1
            user11932033

            Hi,

             

            I am also getting the same error.. and not able to start the OracleDiAgent in Weblogic.?

             

            Did you find any solution for the same ...please share

             

             

            Regards,

            Tarang Jain

            • 3. Re: oraclediagent failed after install OBIA 11.1.1.7.1
              Alvaro Soares

              Hi,

               

                    I have follwed the step 6 "How do I redeploy the Java EE ODI Agent in WebLogic" from from the Doc ID 1589540.1.

               

                     After that, the OracleDiAgent worked well at ODI Studio.

               

                     I hope it helps you.

               

              Thanks

              • 4. Re: oraclediagent failed after install OBIA 11.1.1.7.1
                user11932033

                Hi,

                 

                I followed the step 6 in the document and redeployed oraclediagent. But still i am getting error of invalid username pasword. Please find the details below help me to resolve this issue.

                 

                [HTTP:101216]Servlet: "AgentServlet" failed to preload on startup in Web application: "oraclediagent". ODI-1404: Agent OracleDIAgent start failure: an authentication error occurred while connecting to the master repository. Caused By: oracle.odi.core.security.BadCredentialsException: ODI-10199: Incorrect ODI username or password. [Security:090304]Authentication Failed: User BIAppsSystemUser javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User BIAppsSystemUser denied at oracle.odi.core.security.internal.ODIJpsHelper.translateNativeSecurityException(ODIJpsHelper.java:180) at oracle.odi.core.security.internal.ODIJpsHelper.createSubject(ODIJpsHelper.java:82) at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:250) at oracle.odi.runtime.agent.servlet.AgentServlet.startup(AgentServlet.java:391) at oracle.odi.runtime.agent.servlet.AgentServlet.init(AgentServlet.java:249) at javax.servlet.GenericServlet.init(GenericServlet.java:241) at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:64) at weblogic.servlet.internal.StubLifecycleHelper.createOneInstance(StubLifecycleHelper.java:58) at weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:48) at weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.java:539) at weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletContext.java:1981) at weblogic.servlet.internal.WebAppServletContext.loadServletsOnStartup(WebAppServletContext.java:1955) at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1874) at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3154) at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1518) at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:484) at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425) at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52) at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119) at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200) at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247) at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425) at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52) at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119) at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27) at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:671) at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52) at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212) at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:59) at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161) at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79) at weblogic.deploy.internal.targetserver.operations.AbstractOperation.activate(AbstractOperation.java:569) at weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:150) at weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:116) at weblogic.deploy.internal.targetserver.operations.StartOperation.doCommit(StartOperation.java:149) at weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:323) at weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:844) at weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1253) at weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:440) at weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:163) at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:195) at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:13) at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:68) at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221) Caused by: javax.security.auth.login.LoginException: [Security:090304]Authentication Failed: User BIAppsSystemUser javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User BIAppsSystemUser denied at oracle.security.jps.internal.jaas.module.authentication.JpsUserAuthenticationLoginModule.login(JpsUserAuthenticationLoginModule.java:71) at sun.reflect.GeneratedMethodAccessor450.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at javax.security.auth.login.LoginContext.invoke(LoginContext.java:769) at javax.security.auth.login.LoginContext.access$000(LoginContext.java:186) at javax.security.auth.login.LoginContext$5.run(LoginContext.java:706) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.login.LoginContext.invokeCreatorPriv(LoginContext.java:703) at javax.security.auth.login.LoginContext.login(LoginContext.java:575) at oracle.odi.core.security.internal.ODIJpsHelper.createSubject(ODIJpsHelper.java:69) ... 47 more Caused by: oracle.security.jps.internal.jaas.module.AuthenticationException: [Security:090304]Authentication Failed: User BIAppsSystemUser javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User BIAppsSystemUser denied at oracle.security.jps.wls.jaas.module.authentication.WlsUserAuthenticator.authenticate(WlsUserAuthenticator.java:61) at oracle.security.jps.internal.jaas.module.authentication.JpsUserAuthenticationLoginModule.login(JpsUserAuthenticationLoginModule.java:62) ... 57 more Caused by: javax.security.auth.login.FailedLoginException: [Security:090304]Authentication Failed: User BIAppsSystemUser javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User BIAppsSystemUser denied at weblogic.security.providers.authentication.LDAPAtnLoginModuleImpl.login(LDAPAtnLoginModuleImpl.java:261) at com.bea.common.security.internal.service.LoginModuleWrapper$1.run(LoginModuleWrapper.java:110) at java.security.AccessController.doPrivileged(Native Method) at com.bea.common.security.internal.service.LoginModuleWrapper.login(LoginModuleWrapper.java:106) at sun.reflect.GeneratedMethodAccessor447.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at javax.security.auth.login.LoginContext.invoke(LoginContext.java:769) at javax.security.auth.login.LoginContext.access$000(LoginContext.java:186) at javax.security.auth.login.LoginContext$4.run(LoginContext.java:683) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680) at javax.security.auth.login.LoginContext.login(LoginContext.java:579) at com.bea.common.security.internal.service.JAASLoginServiceImpl.login(JAASLoginServiceImpl.java:113) at sun.reflect.GeneratedMethodAccessor445.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.bea.common.security.internal.utils.Delegator$ProxyInvocationHandler.invoke(Delegator.java:57) at $Proxy36.login(Unknown Source) at weblogic.security.service.internal.WLSJAASLoginServiceImpl$ServiceImpl.login(WLSJAASLoginServiceImpl.java:89) at com.bea.common.security.internal.service.JAASAuthenticationServiceImpl.authenticate(JAASAuthenticationServiceImpl.java:82) at sun.reflect.GeneratedMethodAccessor443.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.bea.common.security.internal.utils.Delegator$ProxyInvocationHandler.invoke(Delegator.java:57) at $Proxy54.authenticate(Unknown Source) at weblogic.security.service.WLSJAASAuthenticationServiceWrapper.authenticate(WLSJAASAuthenticationServiceWrapper.java:40) at weblogic.security.service.PrincipalAuthenticator.authenticate(PrincipalAuthenticator.java:338) at weblogic.security.services.Authentication.doLogin(Authentication.java:133) at weblogic.security.services.Authentication.login(Authentication.java:74) at weblogic.security.services.Authentication.login(Authentication.java:51) at oracle.security.jps.wls.jaas.module.authentication.WlsUserAuthenticator.authenticate(WlsUserAuthenticator.java:56)

                 

                Regards,

                Tarang Jain

                • 5. Re: oraclediagent failed after install OBIA 11.1.1.7.1
                  Alvaro Soares

                  According to your error message, you are having " failure: an authentication error occurred while connecting to the master repository". Are you sure the password from Master and Work Repository are fine ?  Try to check that.

                   

                  Thanks

                  • 6. Re: oraclediagent failed after install OBIA 11.1.1.7.1
                    Raj2188

                    Hi Alvaro,

                     

                    I am pretty new to ODI. Can you please guide me of on a preload where to check these credentials ?

                     

                    Thanks

                    • 7. Re: oraclediagent failed after install OBIA 11.1.1.7.1
                      Raj2188

                      Just to add on, i am using FMW security and its a standalone installation(for POC).

                      • 8. Re: oraclediagent failed after install OBIA 11.1.1.7.1
                        Alvaro Soares

                        Hi,

                         

                              First of all. Have you installation completed without errors ? Because I have got errors at ODI serttings on the configApps.sh.

                         

                             At the same Doc ID 1589540.1, go to step from 3.5.1 to 3.6.4.4. There is explained how to set the repositories and set the credentials in ODI Studio.

                         

                        1.1.         3.5.1. Install ODI Studio and configure user access as documented in sections 3.3.8.1 Installing ODI Studio and 3.3.8.2 Configuring User Access for ODI Studio of the Oracle® Fusion Middleware Installation Guide for Oracle Business Intelligence Applications 11g Release 1 (11.1.1.7). ( http://docs.oracle.com/cd/E38317_01/doc.11117/e35981/install.htm#BABJHCII)

                         

                                       After that, let me know if you are still having errors.

                         

                                 thanks

                                             

                        • 9. Re: oraclediagent failed after install OBIA 11.1.1.7.1
                          Raj2188

                          Hi,

                           

                          I resolved the issue. The problem was the patchset that was to be applied for OBIEE client and had some 1039 files to be copied over for proper functioning.

                           

                          Patch : BISHIPHOME_11_1_1_7_0_GENERIC_130409_1210_16492220.zip

                           

                          Thanks

                          • 10. Re: oraclediagent failed after install OBIA 11.1.1.7.1
                            a30e4212-17db-440e-9bba-4ff6a0ec8ae1

                            Alvaro,

                            i am unable to find the document with number doc id 1589540.1. Also, the link you posted doesn't have section 3.5.1 and 3.6.4.4

                            Can you please point me in the right direction so i can fix this installations.

                             

                            thanks,

                            RP

                            • 11. Re: oraclediagent failed after install OBIA 11.1.1.7.1
                              Alvaro Soares

                              Hi RP,

                                 This Doc ID is available at Oracle Support. When you're going to search it, just type the 1589540.1 at search box.

                               

                              Thanks,

                              • 12. Re: oraclediagent failed after install OBIA 11.1.1.7.1
                                Sagar Tippe

                                Hi guys,

                                 

                                for a complete and neat steps for installation of OBIA 11.1.1.7.1, follow the following doc. It contains all of the possible errors and their solutions there itself.

                                 

                                Oracle Business Intelligence 11g: Installing and Configuring Oracle BI Applications 11.1.1.7.1