E-AS: PeopleTools 8.51: Logging on to PIA Results in "bea.jolt.ApplicationException: TPESVCFAIL - application service failure" (Doc ID 1303236.1)

Last updated on APRIL 03, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.51 to 8.51 [Release 8.4]
Information in this document applies to any platform.

Symptoms

Trying to logon to PIA results in error:

 "bea.jolt.ApplicationException: TPESVCFAIL - application service failure" on logon screen.

 

Note: This also affects the Integration Broker Gateway that also logs in to application server when passing inbound messages.

 
When TraceSQL=31 is set in the application server domains <PS_HOME>/appserv/<domain>/psappsrv.cfg file you will see errors similar to the ones below in the <PS_CFG_HOME>/appserv/<domain>/LOGS/*.tracesql files.

Oracle Database:

PSAPPSRV.9699626 (26) 1-6 09.08.54 0.002009 SQL error. Function: CreateSQL
Error Position: 0
Return: 3114 - ORA-03114: not connected to ORACLE

 

PSAPPSRV.1992 (23) 1-2752 17.56.20 0.000000 Cur#1.1992.HRTEST RC=0 Dur=0.000000 COM Stmt=SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'
PSAPPSRV.1992 (23) 1-2753 17.56.20 0.002000 Cur#1.1992.HRTEST RC=3113 Dur=0.002000 EXE
PSAPPSRV.1992 (23) 1-2754 17.56.20 0.008000 Cur#1.1992.HRTEST RC=0 Dur=0.000000 RCD rtncd=3113
PSAPPSRV.1992 (23) 1-2755 17.56.20 0.000000 Cur#1.1992.HRTEST RC=0 Dur=0.000000 EPO error pos=24
PSAPPSRV.1992 (23) 1-2756 17.56.20 0.011000 Cur#0.1992.notSamTran RC=-1 Dur=0.000000 XER rtncd=6291792 msg=
PSAPPSRV.1992 (23) 1-2757 17.56.20 0.000000 Cur#0.1992.notSamTran RC=0 Dur=0.000000 ERR rtncd=3113 msg=ORA-03113: end-of-file on communication channel Process ID: 15728 Session ID: 141 Serial number: 3


SQL Server Database


PSAPPSRV.264 (177) 1-178359 02.24.56 0.000000 Cur#0.264.notSamTran RC=0 Dur=0.000000 XER rtncd=8 msg=[Microsoft][SQL Server Native Client 10.0]Communication link failure
PSAPPSRV.264 (177) 1-178360 02.24.56 0.000000 Cur#2.264.HRTEST RC=8200 Dur=0.000000 Rollback
PSAPPSRV.264 (177) 1-178361 02.24.56 0.000000 Cur#2.264.HRTEST RC=0 Dur=0.000000 Disconnect
PSAPPSRV.264 (177) 1-178362 02.24.56 0.000000 Cur#1.264.HRTEST RC=0 Dur=0.000000 Disconnect
PSAPPSRV.264 (177) 1-178363 02.24.56 0.004000 SQL error. Function: CreateSQL
Error Position: 0
Return: 8200 - [Microsoft][SQL Server Native Client 10.0]Communication link failure

 

PSAPPSRV.264 (177) 1-178344 02.24.56 0.000000 Cur#1.264.HRTEST RC=8601 Dur=0.000000 EXE


DB2 Database:

APPSRV_MMDD.LOG

PSAPPSRV.3168 (32) [04/25/11 13:09:41 096086@172.20.65.253 ICPanel](3) File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 8601 - [IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003 (SQLSTATE 08003) -99999

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