E-COB: Running Cobols Error PTPSQLRT - Error Encountered

(Doc ID 758732.1)

Last updated on OCTOBER 22, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.40 to 8.52 [Release 8.4]
Information in this document applies to any platform.
***Checked for relevance on 01-FEB-2017***


Symptoms

 

Running Cobol process and it error out with below error:

Application Program Failed
Action Type : SQL UPDATE
In Pgm Section : SQLRT: PROCESS-SETUP(BIND)
With Return Code: 08001
Error Message : Invalid bind variable number
Stored Stmt : PTPUSTAT_U_PRCRQSE
SQL Statement : UPDATE PSPRCSRQST SET RUNSTATUS = :1 ,PRCSRTNCD = :2 ,ENDDTT
M = SYSDATE ,LASTUPDDTTM = SYSDATE ,CONTINUEJOB = :3 WHERE P
RCSINSTANCE = :4

at pos 00028

PTPSQLRT - Error Encountered
No longer have connection to DB due to an error from previous
action: SQL UPDATE. Bypassing current action: SQL SELECT.
Terminating Program.

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