E-COB: Tools 8.56.14 and 8.55.27 - All COBOL Programs error. ORA-01005: null password given; logon denied or ORA-00987: missing or invalid username(s) or Return Code: 00404 SQLRT: Unable to connect to database (Doc ID 2498068.1)

Last updated on AUGUST 04, 2023

Applies to:

Symptoms

Applies to Tools 8.55.27  and 8.56.14 on ANSI platform only.   Not an issue on UNICODE.

After upgrading to PeopleTools 8.55.27  or Tools 8.56.14,  all COBOL processes are erroring. 

When running PTPDBTST process via process scheduler,  one of the following messages will appear in the process log file.

Application Program Failed
Action Type     : SQL CONNEC
In Pgm Section  : SQLRT:GG100 SQL-CONNECT                            
With Return Code: 01005
Error Message   : ORA-01005: null password given; logon denied

FAIL TO CONNECT
PTPDBTST:
Application Program Failed
In Pgm Section  : CONNECT FAILED                                      
With Return Code: 01005
Error Message   : ORA-01005: null password given; logon denied

Or

Application Program Failed
Action Type : SQL CONNEC
In Pgm Section : SQLRT:GG100 SQL-CONNECT
With Return Code: 00987
Error Message : ORA-00987: missing or invalid username(s)

FAIL TO CONNECT
PTPDBTST:
Application Program Failed
In Pgm Section : CONNECT FAILED
With Return Code: 00987
Error Message : ORA-00987: missing or invalid username(s)

Or

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

FAIL TO CONNECT
PTPDBTST:
Application Program Failed
In Pgm Section : CONNECT FAILED
With Return Code: 00404
Error Message : SQLRT: Unable to connect to database

The sqltrace for the COBOL process will show that the accessid in the connect statement is corrupted.

..

..

07:11:26.876 11 0.000 0.000 #1 RC=0 COM Stmt=SELECT A.STM_ACCESS_ID, A.STM_ACCESS_PSWD, A.STM_ACCESS_PART1, A.STM_ACCESS_PART2, A.ENCRYPTED FROM EMDBO.PSOPRDEFN O, EMDBO.PSACCESSPROFILE A WHERE O.OPRID=:1 AND A.SYMBOLICID = O.SYMBOLICID
07:11:26.876 12 0.000 0.000 #1 RC=0 Bind position=1, type=SQLPSTR, length=0, value=VP1
07:11:26.876 13 0.000 0.000 #1 RC=0 SSB column=1, type=SQLPSTR, length=41
07:11:26.876 14 0.000 0.000 #1 RC=0 SSB column=2, type=SQLPSTR, length=41
07:11:26.876 15 0.000 0.000 #1 RC=0 SSB column=3, type=SQLPSTR, length=45
07:11:26.876 16 0.000 0.000 #1 RC=0 SSB column=4, type=SQLPSTR, length=45
07:11:26.876 17 0.000 0.000 #1 RC=0 SSB column=5, type=SQLPSIN, length=4
07:11:26.881 18 0.010 0.000 #1 RC=0 EXE
07:11:26.881 19 0.000 0.000 #1 RC=0 Fetch
07:11:26.882 20 0.000 0.000 #1 RC=0 Disconnect
07:11:27.998 21 1.110 0.000 #0 RC=404 Connect=PS92DMO/�S'Iѡ;㴸e(l��+_�?��n�;�Њ����/?..

..

..

In another scenario:

After upgrading DEV from PeopleTools 8.56.06 to 8.56.15, getting the following error in the cobol process log file, when trying to run cobol test program.

Application Program Failed
Action Type : SQL CONNEC
In Pgm Section : SQLRT:GG100 SQL-CONNECT
With Return Code: 09990
Error Message : SQLRT: Operator ID not allowed to submit COBOL

FAIL TO CONNECT
PTPDBTST:
Application Program Failed
In Pgm Section : CONNECT FAILED
With Return Code: 09990
Error Message : SQLRT: Operator ID not allowed to submit COBOL

The sqltrace shows the following:

--------------------------------------

PeopleSoft Batch Timings Report: cobsql_579092.trc

Encoding Scheme Used: Ansi

Time Line Elapsed SQL Cursor Return DB API Statement
------------ --------- ------- ------- ------ ------- ----------------
10:21:56.542 1 0.062 0.062 #1 RC=0 Connect=PSHRDEV/people/?
10:21:56.542 2 0.000 0.000 #1 RC=0 COM Stmt=SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME = :1
10:21:56.542 3 0.000 0.000 #1 RC=0 Bind position=1, type=SQLPSTR, length=0, value=PSHRDEV
10:21:56.543 4 0.000 0.000 #1 RC=0 EXE
10:21:56.543 5 0.000 0.000 #1 RC=0 SSB column=1, type=SQLPSTR, length=31
10:21:56.543 6 0.000 0.000 #1 RC=0 Fetch
10:21:56.545 7 0.000 0.000 #1 RC=0 CEX Stmt=SELECT OWNERID, UNICODE_ENABLED FROM SYSADM.PSSTATUS
10:21:56.545 8 0.000 0.000 #1 RC=0 SSB column=1, type=SQLPSTR, length=31
10:21:56.545 9 0.000 0.000 #1 RC=0 SSB column=2, type=SQLPSIN, length=4
10:21:56.546 10 0.000 0.000 #1 RC=0 Fetch
10:21:56.546 11 0.000 0.000 #1 RC=0 COM Stmt=SELECT A.STM_ACCESS_ID, A.STM_ACCESS_PSWD, A.STM_ACCESS_PART1, A.STM_ACCESS_PART2, A.ENCRYPTED FROM SYSADM.PSOPRDEFN O, SYSADM.PSACCESSPROFILE A WHERE O.OPRID=:1 AND A.SYMBOLICID = O.SYMBOLICID
10:21:56.546 12 0.000 0.000 #1 RC=0 Bind position=1, type=SQLPSTR, length=0, value=TST1234
10:21:56.546 13 0.000 0.000 #1 RC=0 SSB column=1, type=SQLPSTR, length=41
10:21:56.546 14 0.000 0.000 #1 RC=0 SSB column=2, type=SQLPSTR, length=41
10:21:56.546 15 0.000 0.000 #1 RC=0 SSB column=3, type=SQLPSTR, length=45
10:21:56.546 16 0.000 0.000 #1 RC=0 SSB column=4, type=SQLPSTR, length=45
10:21:56.547 17 0.000 0.000 #1 RC=0 SSB column=5, type=SQLPSIN, length=4
10:21:56.548 18 0.000 0.000 #1 RC=0 EXE
10:21:56.548 19 0.000 0.000 #1 RC=0 Fetch
10:21:56.549 20 0.000 0.000 #1 RC=0 Disconnect
10:21:56.550 21 0.000 0.000 #1 RC=0 Connect=PSHRDEV//?
10:21:56.551 22 0.016 0.000 #1 RC=0 SET OprId=TST1234
10:21:56.551 23 0.000 0.000 #1 RC=0 SET type= cursor=persistent
10:21:56.552 24 0.000 0.000 #1 RC=0 COM Stmt=SELECT PTOPERPSWDV2, OPERPSWDSALT FROM PSOPRDEFN WHERE OPRID = :1
10:21:56.552 25 0.000 0.000 #1 RC=0 Bind position=1, type=SQLPSTR, length=0, value=TST1234
10:21:56.552 26 0.000 0.000 #1 RC=0 SSB column=1, type=SQLPSTR, length=93
10:21:56.552 27 0.000 0.000 #1 RC=0 SSB column=2, type=SQLPSTR, length=89
10:21:56.554 28 0.000 0.000 #1 RC=0 EXE
10:21:56.554 29 0.000 0.000 #1 RC=0 Fetch
10:21:56.554 30 0.000 0.000 #1 RC=0 COM Stmt=SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD-HH24.MI.SS."000000"'), CMDLN, TO_CHAR(CREATED_DTTM ,'YYYY-MM-DD-HH24.MI.SS."000000"'), TIMETOLIVE, HASH_SIGNATURE FROM PSBATCHAUTH WHERE GUID = :1
10:21:56.554 31 0.000 0.000 #1 RC=0 Bind position=1, type=SQLPSTR, length=0, value=797634a9-6c1c-11e9-8545-ef3762116392
10:21:56.554 32 0.000 0.000 #1 RC=0 SSB column=1, type=SQLPSTR, length=27
10:21:56.554 33 0.000 0.000 #1 RC=0 SSB column=2, type=SQLPSTR, length=255
10:21:56.554 34 0.000 0.000 #1 RC=0 SSB column=3, type=SQLPSTR, length=27
10:21:56.554 35 0.000 0.000 #1 RC=0 SSB column=4, type=SQLPSIN, length=4
10:21:56.555 36 0.000 0.000 #1 RC=0 SSB column=5, type=SQLPSTR, length=29
10:21:56.557 37 0.000 0.000 #1 RC=942 EXE
10:21:56.557 38 0.000 0.000 #1 RC=9990 Operator ID not authorized to run COBOL
10:21:56.578 39 0.016 0.000 #1 RC=0 Disconnect
10:21:56.605 40 0.031 0.000 #0 RC=0 DON
10:21:56.624 41 0.015 0.000 #0 RC=8098 DON
C_LOGDUMP: No log entries

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.