My Oracle Support Banner

E-COB: COBOL Program PTPNTEST Remote Call Test Fails with Return Code: 00404 Error Message : SQLRT: Unable to connect to database (Doc ID 2418727.1)

Last updated on JULY 03, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Information in this document applies to any platform.


Applies to : UNIX / Linux or Windows platforms

Sample Environment:
PeopleTools 8.55.19
TEST environment
Windows platform

Cobol remote call test fails with the following error.  The PTPDBTST process runs successfully via the scheduler.

Application Program Failed
 Action Type     : SQL CONNEC
 In Pgm Section  : SQLRT:GG100 SQL-CONNECT                            
 With Return Code: 00404
 Error Message   : SQLRT: Unable to connect to database: PSTST1

PeopleSoft application uses cobol remote call for several processes that provide application functionality e.g benefits administration, pay confirm etc.   If the remote call test fails, that indicates that none of the remote called processes will run.




To view full details, 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 a vibrant support community of peers and Oracle experts.