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.

Symptoms

Applies to : UNIX / Linux or Windows platforms

Sample Environment:
---------------
PeopleTools 8.55.19
TEST environment
Windows platform

Issue:
--------
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

Impact:
--------
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.

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