E-COB: COBOL processes and COBOL remote call error with RETURN CODE: 00404 SQLRT: UNABLE TO CONNECT TO DATABASE after applying PeopleTools 8.52.24, 8.53.17, or 8.54.04 Patches. (Doc ID 1943152.1)

Last updated on NOVEMBER 14, 2016

Applies to:

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

Symptoms

Customers were previously running COBOL jobs successfully, prior to applying one of the three PeopleTools Patches listed below, but are now experiencing issues running COBOL programs after applying one of the listed Patches.

ISSUE 1

---------

Applicable to the 8.52.24, 8.53.17, or 8.54.04 PeopleTools Patches, and not specific to any platform.

COBOL programs fail on connect to the Database when the connectpswd is encrypted and has a length of 8.

The following error message is displayed in the COBOL SQL .trc file for the failure to connect with the connectpswd issue:
 PeopleSoft Batch Timings Report: cobsql_1211.trc

Time Line Elapsed SQL Cursor Return DB API Statement
-------- --------- ------- ------- ------ ------- ----------------
13:36:43 1 0.270 0.280 #32767 RC=404 Connect=HRTST/people/?
13:36:43 2 0.000 0.000 #0 RC=404 Unable to login to database
13:36:43 3 0.000 0.000 #0 RC=0 DON
13:36:43 4 0.000 0.000 #0 RC=8098 DON
C_LOGDUMP: No log entries

Cobol Log file shows error:

In Pgm Section  : CONNECT FAILED                                      
 With Return Code: 00404
 Error Message   : SQLRT: Unable to connect to database: XXXXX

 

ISSUE 2

---------

Applicable to the 8.52.24 and 8.53.17 PeopleTools patches when using a non-unicode Database on UNIX and LINUX platforms.

COBOL programs successfully make the first connection to the Database using the connectid and connectpswd, but fail on attempting the second connection to the Database using the AccessID, due to the missing libpssqlapi_ansi file.

This following is the error message displayed in the COBOL SQL .trc file for the failure to connect to the Database with the accessid issue:

PeopleSoft Batch Timings Report: cobsql_1212.trc

Encoding Scheme Used: Ansi

Time Line Elapsed SQL Cursor Return DB API Statement
------------ --------- ------- ------- ------ ------- ----------------
14:32:18.933 1 0.190 0.200 #1 RC=0 Connect=HRTST/people/?
14:32:18.934 2 0.000 0.000 #1 RC=0 COM Stmt=SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME = :1
14:32:18.934 3 0.000 0.000 #1 RC=0 Bind position=1, type=SQLPSTR, length=0, value=HRTST
14:32:18.937 4 0.000 0.000 #1 RC=0 EXE
14:32:18.937 5 0.000 0.000 #1 RC=0 SSB column=1, type=SQLPSTR, length=31
14:32:18.939 6 0.000 0.000 #1 RC=0 Fetch
14:32:18.941 7 0.000 0.000 #1 RC=0 CEX Stmt=SELECT OWNERID, UNICODE_ENABLED FROM SYSADM.PSSTATUS
14:32:18.941 8 0.000 0.000 #1 RC=0 SSB column=1, type=SQLPSTR, length=31
14:32:18.941 9 0.000 0.000 #1 RC=0 SSB column=2, type=SQLPSIN, length=4
14:32:18.943 10 0.010 0.000 #1 RC=0 Fetch
14:32:18.944 11 0.000 0.000 #1 RC=0 COM Stmt=SELECT A.ACCESSID, A.ACCESSPSWD, A.ENCRYPTED FROM SYSADM.PSOPRDEFN O, SYSADM.PSACCESSPRFL A WHERE O.OPRID=:1 AND A.SYMBOLICID = O.SYMBOLICID
14:32:18.944 12 0.000 0.000 #1 RC=0 Bind position=1, type=SQLPSTR, length=0, value=PS
14:32:18.944 13 0.000 0.000 #1 RC=0 SSB column=1, type=SQLPSTR, length=17
14:32:18.944 14 0.000 0.000 #1 RC=0 SSB column=2, type=SQLPSTR, length=17
14:32:18.944 15 0.000 0.000 #1 RC=0 SSB column=3, type=SQLPSIN, length=4
14:32:18.952 16 0.010 0.000 #1 RC=0 EXE
14:32:18.953 17 0.000 0.000 #1 RC=0 Fetch
14:32:18.959 18 0.000 0.000 #1 RC=0 Disconnect
14:32:19.086 19 0.130 0.000 #0 RC=404 Connect=HRTST/<accessid>/?
14:32:19.086 20 0.000 0.000 #0 RC=404 Unable to login to database
14:32:19.087 21 0.000 0.000 #0 RC=0 DON
14:32:19.088 22 0.000 0.000 #0 RC=8098 DON
C_LOGDUMP: No log entries

Cobol Log file shows error:

In Pgm Section  : CONNECT FAILED                                      
 With Return Code: 00404
 Error Message   : SQLRT: Unable to connect to database: XXXXX

 STEPS TO RECREATE EITHER ISSUE
---------------------------------------
The two issues can be reproduced at will with the following steps:
1. Install either the 8.52.24, 8.53.17, or 8.54.04 PeopleTools Patch.

2. Try running any COBOL program, and note the occurrence of the above error message in the *.out file.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot successfully run COBOL programs in their post-upgrade environments.

Note: As of Nov 12th 2014, PeopleTools 8.52.24, 8.53.17, and 8.54.04 have been reposted and please apply the relevant patch for your release to resolve the issues.

 

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