0 Replies Latest reply on Apr 5, 2017 2:50 PM by Yogen

    Authentication Error invalid session ID in BI publisher webservices

    Yogen

      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 Check event trigger result in 11.1.1.7 .

       

      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)