PSPPYRUN cobol failing with "INVALID CHARACTER AT END OF DATA" error
Hello,
Environment: HCM 9.2, PeopleTools 8.57, Image 17, MS SQL Server, Windows (all tiers)
Problem:
Payroll calc (PSPPYRUN) fails in lower environment with bind variable mismatch. COBSQL trace shows the SQL statement PSPEARRY_S_ERN has 5 bind placeholders, but the COBOL program passes 6 binds. The 6th bind is a space character (appears to be ORIG_PAYGROUP). Error: RC=8080 "An invalid bind variable number was specified."
Process logs:
Checking PaySheet Update ended at 14:28:14.20.
PTPSQLRT - ERROR IN BIND SETUP/DATA
STATEMENT=PSPSTRUN_S_RECALCO
VARIABLE#=00005
INVALID CHARACTER AT END OF DATA=
Application Program Failed
Action Type : SQL SELECT
In Pgm Section :Error Message :Stored Stmt : PSPSTRUN_S_RECALCO