2 Replies Latest reply: May 8, 2013 2:18 AM by Penky RSS

    Random connection errors after dashboard is being refreshed (external DS)

    Penky
      Hi Forum,

      we are testing Oracle BAM to monitor data coming from an external oracle database.
      On the external database, I created views and using this views to created external data source and data object in BAM architect.

      There is a dashboard with 5 charts on it. The dashboard works fine for some time, but then randomly the following errors are thrown for one or two charts in the dashboard:

      SQLRECOVERABLEEXCEPTION_NULL_NULL_NULL
      Closed Connection: Next

      or this one

      SQLRECOVERABLEEXCEPTION_NULL_NULL_NULL
      Closed Connection


      After Hitting "Refresh" it sometimes works, sometimes other charts fail to display their data ... it's just all random.

      What can it be? We are using JDBC driver jdbc:oracle:thin:@host:port:SID

      Thank you!
        • 1. Re: Random connection errors after dashboard is being refreshed (external DS)
          Shankar
          Hi Penky ,

          can you please post log of BAM server.

          Thank you!
          • 2. Re: Random connection errors after dashboard is being refreshed (external DS)
            Penky
            Hi Shankar,

            Thanks for your help!
            BAM Server Log contains this snipped on every refresh of the dashboard (even if there is no error thrown on the dashboard/report itself):


            [2013-05-08T08:53:50.152+02:00] [bam_server1] [WARNING] [] [oracle.bam.web.reportserver.activedata.ActiveDataServlet] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 93c6b8f05ea8d87c:-749821c0:13e7efceeec:-8000-0000000000001c6b,0] [APP: oracle-bam#11.1.1] [DSID: 0000Jtz2VgWApI^5xVWByW1HYFJt000006] inside ActiveDataServlet.doResponse(): weblogic.servlet.http.RequestResponseKey@a71e1405
            [2013-05-08T08:53:50.941+02:00] [bam_server1] [ERROR] [] [oracle.bam.reportcache] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 93c6b8f05ea8d87c:-749821c0:13e7efceeec:-8000-0000000000001c71,0] [APP: oracle-bam#11.1.1] [DSID: 0000Jtz2VgWApI^5xVWByW1HYFJt000006] ReportCache: ReportCacheServer.GetRecordSet: ADC exception=BAM-01282: This viewset not found: 93c6b8f05ea8d87c-749821c013e7efceeec-7550. [[

            at oracle.bam.reportcache.engine.CacheEngine.getRecordSets(CacheEngine.java:976)
            at oracle.bam.reportcache.engine.CacheEngine.getRecordSet(CacheEngine.java:862)
            at oracle.bam.reportcache.server.ReportCacheService.getRecordSet(ReportCacheService.java:238)
            at oracle.bam.reportcache.ejb.ReportCacheServerBean.getRecordSet(ReportCacheServerBean.java:278)
            at sun.reflect.GeneratedMethodAccessor495.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:601)
            at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
            at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
            at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
            at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
            at oracle.bam.reportcache.ejb.ReportCacheServerBean.interceptor(ReportCacheServerBean.java:193)
            at sun.reflect.GeneratedMethodAccessor450.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:601)
            at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
            at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
            at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
            at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
            at oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:113)
            at java.security.AccessController.doPrivileged(Native Method)
            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.ejb.JpsAbsInterceptor.runJaasMode(JpsAbsInterceptor.java:100)
            at oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:154)
            at oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:113)
            at sun.reflect.GeneratedMethodAccessor418.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:601)
            at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
            at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
            at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
            at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
            at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
            at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
            at com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34)
            at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
            at com.oracle.pitchfork.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:42)
            at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
            at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
            at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
            at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
            at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
            at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
            at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
            at com.sun.proxy.$Proxy229.getRecordSet(Unknown Source)
            at oracle.bam.reportcache.ejb.ReportCacheServerBean_vm1wm8_ReportCacheServerRemoteImpl.__WL_invoke(Unknown Source)
            at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
            at oracle.bam.reportcache.ejb.ReportCacheServerBean_vm1wm8_ReportCacheServerRemoteImpl.getRecordSet(Unknown Source)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:601)
            at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
            at com.sun.proxy.$Proxy151.getRecordSet(Unknown Source)
            at sun.reflect.GeneratedMethodAccessor493.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:601)
            at oracle.bam.common.remoting.BamEjbClient.invoke(BamEjbClient.java:1546)
            at com.sun.proxy.$Proxy228.getRecordSet(Unknown Source)
            at oracle.bam.web.reportserver.data.DataManager.getRecordSet(DataManager.java:273)
            at oracle.bam.web.reportserver.activedata.ActiveDataManager.syncViewSetIndexes(ActiveDataManager.java:777)
            at oracle.bam.web.reportserver.activedata.ActiveDataPage.getChangeList(ActiveDataPage.java:655)
            at oracle.bam.web.reportserver.activedata.ActiveDataServlet.doRequest(ActiveDataServlet.java:188)
            at weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
            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:301)
            at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
            at oracle.bam.web.filters.CharsetFixupFilter.doFilter(CharsetFixupFilter.java:65)
            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(Native Method)
            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.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
            at java.security.AccessController.doPrivileged(Native Method)
            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 weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
            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:2273)
            at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
            at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
            at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

            ]]
            [2013-05-08T08:54:16.670+02:00] [bam_server1] [ERROR] [] [oracle.bam.web.reportserver.activedata.ActiveDataPage] [tid: Timer-5] [userId: OracleSystemUser] [ecid: 0000JtyzG2oApI^5xVWByW1HYFJt000002,0] [APP: oracle-bam#11.1.1] ServerRestartedException (BAM-01263: The Oracle BAM Server has restarted.)
            [2013-05-08T08:54:16.671+02:00] [bam_server1] [NOTIFICATION] [] [oracle.bam.web.reportserver.activedata.ActiveDataPage] [tid: Timer-5] [userId: OracleSystemUser] [ecid: 0000JtyzG2oApI^5xVWByW1HYFJt000002,0] [APP: oracle-bam#11.1.1] ActiveDataPage.handleServerRestartedException() - strActiveReportID = 93c6b8f05ea8d87c_749821c013e7efceeec_7554