3 Replies Latest reply on Mar 22, 2016 9:05 AM by rmoff

    Biee12c presentation service crashed periody

    Jack Lu

      HI everyone,

       

      I have an issue in our windows2012R2 production environment,  the presentation service crashed  about once a week,  when i login analytics,get 500 error.

      But in the em, the status are all on, no service down.  I checked logs,

      in the bi_server1.log, i got error

      ####<2016-3-19  CST> <Info> <JDBC> <SER-JSYF-BI-TES> <bi_server1> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <3caee5b4-4ac1-427c-9059-70afb753e4ef-0004fcad> <1458376740549> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "mds-owsm" has been closed.>

      ####<2016-3-19  CST> <Info> <JDBC> <SER-JSYF-BI-TES> <bi_server1> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <3caee5b4-4ac1-427c-9059-70afb753e4ef-0004fcb0> <1458376745845> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "wlsservices_datasource" has been closed.>

      ####<2016-3-19 CST> <Info> <Common> <SER-JSYF-BI-TES> <bi_server1> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <3caee5b4-4ac1-427c-9059-70afb753e4ef-0004fcb1> <1458376746830> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "wlsservices_datasource", out of which "1" are available and "0" are unavailable.>

      ####<2016-3-19  CST> <Info> <JDBC> <SER-JSYF-BI-TES> <bi_server1> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <3caee5b4-4ac1-427c-9059-70afb753e4ef-0004fe1e> <1458377640253> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "biplatform_datasource" has been closed.>

      ####<2016-3-19  CST> <Info> <JDBC> <SER-JSYF-BI-TES> <bi_server1> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <3caee5b4-4ac1-427c-9059-70afb753e4ef-0004fe1f> <1458377640550> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "mds-owsm" has been closed.>

      in the   obis1-diagnostic.log,got error

      [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 1ac8]  [43065] lost connection with cluster controller ::ffff:10.0.0.11:63097  。

      [2016-03-19T06:20:48.336+08:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 19d8]  [nQSError: 12002] call=Read: (Number=10004) 一an lock operation was interrupt by invoke WSACancelBlockingCall 。 socket error [[

      file: server\Utility\Comm\Src\SUCMSocket.cpp; line: 913

      in the windows event log,i got error

      sawserver.exe

         12.2.1.0

         5616f0d2

         sawbedrock643r.dll

         12.2.1.0

         5616e91c

         c0000005

         0000000000008c2c

         1b34

         01d17d2d4917f9f7

         D:\Oracle\Middleware\Oracle_Home\bi\bifoundation\web\bin\sawserver.exe

         D:\Oracle\Middleware\Oracle_Home\bi\bifoundation\web\bin\sawbedrock643r.dll

         4a0ac66e-ed56-11e5-80be-0050569a5b30

       

      Do anyone know this issue? Pls help

        • 1. Re: Biee12c presentation service crashed periody
          rmoff

          If it's presentation services that's crashing, you need to also look at the sawlog.log.

           

          And if it's crashing, you need to raise an SR.

          • 2. Re: Biee12c presentation service crashed periody
            Jack Lu

            in the sawlog3.log file,  many invalid path error, but i check that the path is exist

            [2016-03-22T08:39:41+08:00] [OBIPS] [ERROR:16] [] [saw.catalog.serviceinstance.getItemInfoInternal] [ecid: ] [tid: 6436] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: wyb] Invalid path () -- R[[

            File:serviceinstancecatalog.cpp

            Line:1351

            Location:

              saw.catalog.serviceinstance.getItemInfoInternal

              saw.views.evc.activate

              saw.subsystem.portal.pagesImpl

              saw.subsystem.portal

              saw.httpserver.processrequest

              saw.rpc.server.responder

              saw.rpc.server

              saw.rpc.server.handleConnection

              saw.rpc.server.dispatch

              saw.threadpool.socketrpcserver

              saw.threads

            RSP: d:dashboard~p:hh8ldhm3uq1pommd~r:087iergfodeq8ins

            Path: ,

            HttpCommand: Dashboard

            SID: v7i48mlrj344m617dircs5eu72

            AuthProps: AuthSchema=UidPwd|PWD=******|UID=wyb|User=wyb|GUID=wyb

            SessionID: 10.3.5.126.8ed.9gq4jni

            RptPath: /shared/001/yearsale

            RemoteIP: 10.3.5.126

            ]]

            • 3. Re: Biee12c presentation service crashed periody
              rmoff

              So have you raised an SR?