E-IB: IB Failover May Hang If Email Notification Was Used (Doc ID 1350475.1)

Last updated on SEPTEMBER 11, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Jan-2014***

Symptoms

After having implemented Integration Broker failover on two AIX boxes, started getting emails with empty body and the subject line reading as follows:

Integration Broker Failover: A general exception has occurred during Failover processing. (158,518).


Also, in MONITORSRV_0518.LOG file, additional errors were found, as follows:

PSMONITORSRV.2818226 (0) [03/30/11 00:00:46](3) File: /vob/peopletools/src/psmonitorsrv/statements.cppSQL error. Stmt #: 59 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2/AIX64] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001
(SQLSTATE 40001) -911
Failed SQL stmt:UPDATE PSIBFOLOCK SET IB_FAILOVER_LOCK=0 WHERE IB_FAILOVER_NAME=:1
PSMONITORSRV.2818226 (0) [03/30/11 00:00:46](1) GenMessageBox(200, 0, M): /vob/peopletools/src/psmonitorsrv/statements.cpp: A SQL error occurred. Please consult your system log for details.
PSMONITORSRV.2818226 (0) [03/30/11 00:00:46](3) Unknown error returned on ExecFetch for UpdateIBFOLock
PSMONITORSRV.2818226 (0) [03/30/11 00:02:21](3) File: /vob/peopletools/src/psmonitorsrv/statements.cppSQL error. Stmt #: 59 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2/AIX64] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001
(SQLSTATE 40001) -911

 

 

Changes

 

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