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
   \Oracle\Middleware\Oracle_Home\bi\bifoundation\web\bin\sawserver.exe
   \Oracle\Middleware\Oracle_Home\bi\bifoundation\web\bin\sawbedrock643r.dll
   4a0ac66e-ed56-11e5-80be-0050569a5b30

Do anyone know this issue? Pls help

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.

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
]]

rmoff

So have you raised an SR?