Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Authentication Error invalid session ID in BI publisher webservices

Question
154
Views
0
Comments
Yogen
Yogen Rank 5 - Community Champion
in Oracle Analytics Cloud and Server

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)