E-IB:Integration Broker Publication and Subscription Servers Crashing Intermittently on Oracle 10.2.0.1 (Doc ID 646898.1)

Last updated on JUNE 16, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Dec-2014***
***Checked for relevance on 05-July-2013***
***Checked for relevance on 29-Dec-2011***
***Checked for relevance on 14-June-2010***
SPECIFIC TO: ENTERPRISE, PeopleTools, Integration Broker, PT8.46 and above, Oracle 10g.

This document was previously published as Customer Connection Solution 201008046




Symptoms


After upgrading the DBMS server to Oracle 10.2.0.1, the application server publication/subscription servers crash intermittently.
The following is an example shown in app server log.

PSPUBDSP_dflt.8912 (0) [02/17/06 11:54:59](0) Unhandled exception occurred.  Writing crash dump to PSPUBDSP_dflt.8912\dump
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 1400.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 3123.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 2206.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 3803.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 2253.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 3082.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 2037.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) SQL error. Stmt #: 2475  Error Position: 28  Return: 24909 - ORA-24909: call in progress. Current operation cancelled
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](1) GenMessageBox(200, 0, M): f:\pt84605b-retail\peopletools\SRC\pspubsub\pubsubdispatcher.cpp: SQL error. Stmt #: 2475  Error Position: 28  Return: 24909 - ORA-24909: call in progress. Current operation cancelled
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) Sam SqlError: SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD-HH24.MI.SS."000000"') FROM PSCLOCK
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](1) GenMessageBox(200, 0, M): SQL Access Manager: A SQL error occurred. Please consult your system log for details.



But there is nothing specific in crash dump.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms