Hi All,
I'm facing an issue with BI publisher jobs that are failing randomly. The jobs complete successfully after it is manually resubmitted. The following is the error received when they fail.
[2017-03-13T06:39:00.465-04:00] [bi_server2] [WARNING] [] [oracle.xdo] [tid: 74] [userId: BISystemUser] [ecid: 0000Lf41aHk6uH25Nrk3ye1OlQDe000003,0] [APP: bipublisher#11.1.1] !!!!!!! BurstingJobProcessor.onMessage :: ::JOB_PROCESSOR_EXCEPTION::[INSTANCE_ID=UVACPMMETL03NHX.1487478605369] [INSTANCE_JOB_ID=1246]::oracle.xdo.servlet.scheduler.ProcessingException: Error to reestablish global user:: USERNAME=[weblogic] INSTANCE_JOB_ID=[1246::java.lang.RuntimeException: Failed to retrieve data from Presentation ServerCould not connect to OBI Presentation Service::java.lang.RuntimeException: java.lang.RuntimeException: Failed to retrieve data from Presentation ServerCould not connect to OBI Presentation Service[[
BI publisher is integrated with OBIEE and is clustered. The BI publisher report data model is an OBIEE report. The sawlog had the following entries at the time job failed.
[2017-03-13T06:35:25.000-04:00] [OBIPS] [WARNING:16] [] [saw.subsystem.security.cleanup] [ecid: 005Icr4mhut6uH25Nrk3ye0006hK000000,0:13199] [tid: 3469092608] Client session expired while still in use (ref-count: 2).[[
File:sssecurity.cpp
Line:1459
Location:
saw.subsystem.security.cleanup
saw.Sessions.cache.cleanup
saw.taskScheduler.processJob
taskscheduler
saw.threads
task: Cache/Sessions
]]
[2017-03-13T06:39:00.000-04:00] [OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: 0000Lf41aHk6uH25Nrk3ye1OlQDe000003,0:9:1] [tid: 3646064384] Odbc driver returned an error (SQLDriverConnectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 12017] Unexpected socket read timeout: connection terminated by network, e.g. by the firewall.
I'm looking for any inputs on how to further troubleshoot or a solution (even better). Thanks in advance.
-Sherry