This discussion is archived
1 Reply Latest reply: Jul 30, 2013 4:50 PM by mikereiche RSS

Getting Pool connect failed : java.lang.SecurityException in ODI Agent

user12273134 Newbie
Currently Being Moderated

Hi All,

 

I am getting below error and i tried lot googling but not able to find proper solution.

 

Scenario i am try is :

 

To post the JMS messgae from ODI weblogic domain to the queue on another weblogic domain.

I googled and found the solution to enable the cross domain between this two domain, but I dnt think in real sense this is the issue. Because of below scenario:

 

When i deploy ODI agent, and execute the scenario it works end to end. After this I try to call agent webservice, it not getting the Datasource pool connection

I suspect, as the call is made to anothr domain the principal of another domain is getting cached.

If i redeploy EAR file, it will run again for first time.. .and second time it will fail.

 

Please help, as cross domain doesnt seems to be the issue.. but not able to find out the extract cause.

 

 

####<Jun 28, 2013 4:38:41 PM EST> <Notice> <Diagnostics> <orint4imqodis01.espdev.aurdev.national.com.au> <odi_server1> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <37b614862c0723ee:-370e2457:13f88cf3c4d:-8000-0000000000000e3a> <1372401521457> <BEA-320068> <Watch 'UncheckedException' with severity 'Notice' on server 'odi_server1' has triggered at Jun 28, 2013 4:38:41 PM EST. Notification details:

WatchRuleType: Log

WatchRule: (SEVERITY = 'Error') AND ((MSGID = 'BEA-101020') OR (MSGID = 'BEA-101017') OR (MSGID = 'BEA-000802'))

WatchData: DATE = Jun 28, 2013 4:38:41 PM EST SERVER = odi_server1 MESSAGE = [ServletContext@545927139[app:J2EEOBPODIAGENT module:J2EEOBPODIAGENT path:/J2EEOBPODIAGENT spec-version:2.5]] Root cause of ServletException.

ODI-1274: Agent Exception

Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Create DwgConnectConnection to master repository failed; nested exception is java.sql.SQLException: Pool connect failed : java.lang.SecurityException: [Security:090398]Invalid Subject: principals=[odiuser, Administrators, CrossDomainConnectors]

        at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:490)

        at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:394)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)

        at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

        at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)

        at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)

        at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)

        at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)

        at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)

        at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

        at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)

        at weblogic.servlet.int

Caused By: org.springframework.jdbc.CannotGetJdbcConnectionException: Create DwgConnectConnection to master repository failed; nested exception is java.sql.SQLException: Pool connect failed : java.lang.SecurityException: [Security:090398]Invalid Subject: principals=[odiuser, Administrators, CrossDomainConnectors]

        at oracle.odi.core.persistence.dwgobject.DwgRepositoryConnectConnectionUtils.doGetMasterDwgConnectConnection(DwgRepositoryConnectConnectionUtils.java:84)

        at oracle.odi.core.persistence.dwgobject.DwgRepositoryConnectConnectionUtils.doGetMasterDwgConnectConnection(DwgRepositoryConnectConnectionUtils.java:48)

        at oracle.odi.core.persistence.dwgobject.DwgRepositoryConnectConnectionUtils.doGetMasterDwgConnectConnection(DwgRepositoryConnectConnectionUtils.java:57)

        at oracle.odi.core.security.SecurityManager.doODIInternalAuthentication(SecurityManager.java:331)

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

        at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:438)

        at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:394)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)

        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)

        at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)

        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

        at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)

        at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)

        at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)

        at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)

        at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)

        at oracle.security

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points