Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Authentication Error invalid session ID in BI publisher webservices
Summary
Authentication Error invalid session ID in BI publisher webservices
Content
We are using java application webservice to schedule BIP reports. In production instance we are facing below error i. Due to the error, at rare instance almost 1-2% of our jobs fail at random.
I searched OTN forum and found a similar but unanswered thread .
BUG ID mentioned in the thread seems somewhat relevant to us but not sure how to fix it. OBIEE version is 11.1.1.7.16047.
[2014-10-27T08:00:00.790+03:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 13] [userId: BISystemUser] [ecid: 0000K^ySb7eBh4K6yV3j6G1KILI9000001,0] [APP: bipublisher#11.1.1] User: weblogic, absPath: /~weblogic/user~.profile
[2014-10-27T08:00:00.796+03:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 13] [userId: BISystemUser] [ecid: 0000K^ySb7eBh4K6yV3j6G1KILI9000001,0] [APP: bipublisher#11.1.1] java.rmi.RemoteException: BIEE: User: weblogic, message: Authentication error. Invalid session ID or Session Expired; nested exception is: [[
javax.xml.ws.soap.SOAPFaultException: Authentication error. Invalid session ID or Session Expired; nested exception is:
java.rmi.RemoteException: Authentication error. Invalid session ID or Session Expired; nested exception is:
javax.xml.ws.soap.SOAPFaultException: Authentication error. Invalid session ID or Session Expired
at oracle.xdo.service.report.saw.SawUtil.getTenantId(SawUtil.java:887)
at oracle.xdo.service.report.saw.SawUtil.getTenantId(SawUtil.java:802)
at oracle.xdo.servlet.resources.SawMtomResource.getInputStream(SawMtomResource.java:77)
at oracle.xdo.servlet.resources.XdoProfileServiceImpl._loadProfileXml(XdoProfileServiceImpl.java:165)
at oracle.xdo.servlet.resources.XdoProfileServiceImpl.loadProfile(Xdo]]
[2014-10-28T15:47:42.859+03:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 15] [userId: <anonymous>] [ecid: ba44b6ce5382ca53:-29a2f7d2:1493e723a7b:-8000-000000000010701f,0] [APP: bipublisher#11.1.1] BIEE: User: weblogic, realPaths: [/shared/VTB-DWH/Published Reports/Выписка по счету/Выписка по счету Bursting Trigger.xdm, /shared/VTB-DWH/Published Reports/Выписка по счету, ], message: BIEE: User: weblogic, realPaths: [/shared/VTB-DWH/Published Reports/Выписка по счету/Выписка по счету Bursting Trigger.xdm, /shared/VTB-DWH/Published Reports/Выписка по счету, ], message: Authentication error. Invalid session ID or Session Expired; nested exception is: [[
javax.xml.ws.soap.SOAPFaultException: Authentication error. Invalid session ID or Session Expired; nested exception is:
java.rmi.RemoteException: Authentication error. Invalid session ID or Session Expired; nested exception is:
javax.xml.ws.soap.SOAPFaultException: Authentication error. Invalid session ID or Session Expired
]]
[2014-10-28T15:47:42.880+03:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 15] [userId: <anonymous>] [ecid: ba44b6ce5382ca53:-29a2f7d2:1493e723a7b:-8000-000000000010701f,0] [APP: bipublisher#11.1.1] java.rmi.RemoteException: BIEE: User: weblogic, realPaths: [/shared/VTB-DWH/Published Reports/Выписка по счету/Выписка по счету Bursting Trigger.xdm, /shared/VTB-DWH/Published Reports/Выписка по счету, ], message: Authentication error. Invalid session ID or Session Expired; nested exception is: [[
javax.xml.ws.soap.SOAPFaultException: Authentication error. Invalid session ID or Session Expired; nested exception is:
java.rmi.RemoteException: Authentication error. Invalid session ID or Session Expired; nested exception is:
javax.xml.ws.soap.SOAPFaultException: Authentication error. Invalid session ID or Session Expired
at oracle.xdo.servlet.resources.StructuredSawMtomResourceProvider.getCatalogObjects(StructuredSawMtomResourceProvider.java:1108)
at oracle.xdo.servlet.resources.StructuredSawMtomResourceProvider._getResource(StructuredSawMtomResourceProvider.java:1161)
at oracle.xdo.servlet.resources.StructuredSawMtomResourceProvider.getResource(StructuredSawMtomResourceProvider.java:820)
at oracle.xdo.servlet.resources.ScanningResourceProvider.getResource(ScanningResourceProvider.java:578)
at oracle.xdo.servlet.resources.catalog.ResourceLoad$LoadBasic.execute(ResourceLoad.java:126)
at oracle.xdo.servlet.resources.catalog.ResourceCatalogServiceImpl.get(ResourceCatalogServiceImpl.java:447)
at oracle.xdo.servlet.resources.ResourceServlet.getDMItemList(ResourceServlet.java:4066)
at oracle.xdo.servlet.resources.ResourceServlet.service(ResourceServlet.java:224)
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.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:127)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(AccessController.java:310)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
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:163)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(AccessController.java:310)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
Caused by: java.rmi.RemoteException: Authentication error. Invalid session ID or Session Expired; nested exception is:
javax.xml.ws.soap.SOAPFaultException: Authentication error. Invalid session ID or Session Expired
at oracle.xdo.service.report.saw.wrapper.v7.AbstractSawCatalogServiceImpl.readCatalogObjects(AbstractSawCatalogServiceImpl.java:210)
at oracle.xdo.service.report.saw.wrapper.v7.SawCatalogServiceImpl.readCatalogObjects(SawCatalogServiceImpl.java:218)
at oracle.xdo.servlet.resources.CatalogSawMtomResourceProvider.getCatalogObjects(CatalogSawMtomResourceProvider.java:543)
at oracle.xdo.servlet.resources.StructuredSawMtomResourceProvider.getCatalogObjects(StructuredSawMtomResourceProvider.java:1080)
... 48 more
Caused by: javax.xml.ws.soap.SOAPFaultException: Authentication error. Invalid session ID or Session Expired
at com.siebel.analytics.web.jaxwsutils.DirectSoapCaller.invokeSoapMethod(DirectSoapCaller.java:222)
at com.siebel.analytics.web.jaxwsutils.SAWSOAPTcpConnector.invokeSoapMethod(SAWSOAPTcpConnector.java:77)
at com.siebel.analytics.web.jaxwsutils.SOAPInterfaceProxy.invoke(SOAPInterfaceProxy.java:206)
at $Proxy266.readObjects(Unknown Source)
at oracle.xdo.service.report.saw.wrapper.v7.AbstractSawCatalogServiceImpl.readCatalogObjects(AbstractSawCatalogServiceImpl.java:194)
... 51 more
]]er.java:59)
at oracle.xdo.servlet.security.UserContextSaver.getUserContextSaver(UserContextSaver.java:70)
at oracle.xdo.servlet.security.JPSSecurityHandler.integrateUserContext(JPSSecurityHandler.java:777)
at oracle.xdo.servlet.security.JPSSecurityHandler.handleUserPreferences(JPSSecurityHandler.java:119)
at oracle.xdo.servlet.security.JPSSecurityHandler.getJPSPrincipal(JPSSecurityHandler.java:297)
at oracle.xdo.servlet.security.JPSSecurityHandler.impersonate(JPSSecurityHandler.java:315)
at oracle.xdo.servlet.security.JPSSecurityHandler.impersonate(JPSSecurityHandler.java:321)
at oracle.xdo.servlet.security.JPSSecurityHandler.impersonate(JPSSecurityHandler.java:650)
at oracle.xdo.enterpriseScheduler.bursting.JobUserCache.getUser(JobUserCache.java:79)
at oracle.xdo.enterpriseScheduler.SchedulerJob.execute(SchedulerJob.java:112)
at oracle.xdo.service.scheduling.impl.quartz.QuartzJob.execute(QuartzJob.java:24)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:534)
Caused by: java.rmi.RemoteException: Authentication error. Invalid session ID or Session Expired; nested exception is:
javax.xml.ws.soap.SOAPFaultException: Authentication error. Invalid session ID or Session Expired
at oracle.xdo.service.report.saw.wrapper.v7.AbstractSawSecurityService.getAccountTenantID(AbstractSawSecurityService.java:261)
at oracle.xdo.service.report.saw.wrapper.v7.SawSecurityServiceImpl.getAccountTenantID(SawSecurityServiceImpl.java:148)
at oracle.xdo.service.report.saw.SawUtil.getTenantId(SawUtil.java:854)
... 17 more
Caused by: javax.xml.ws.soap.SOAPFaultException: Authentication error. Invalid session ID or Session Expired
at com.siebel.analytics.web.jaxwsutils.DirectSoapCaller.invokeSoapMethod(DirectSoapCaller.java:222)