E-UPG: Get "Invalid Column Name 'PTOPERPSWDV2'" When Performing the Step "Reviewing Additional PeopleTools Objects" of the PeopleTools Upgrade
(Doc ID 2636662.1)
Last updated on APRIL 01, 2021
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.
When doing a PeopleTools upgrade from 8.54.33 to 8.57, after running the step "Running the Updated PeopleTools Script", the following failure occurred when attempting to open up App Designer:
E:\PT857P08B_1907010952-retail\peopletools\src\pssys\stmget.cppSQL error. Stmt #: 2705 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'PTOPERPSWDV2'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180
Failed SQL stmt: SELECT VERSION, PTOPERPSWDV2, OPERPSWDSALT, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM PSOPRDEFN WHERE OPRID = :1
The oracle version of the failure is as below:
System Error : File: E:\PT857P04B_1901030800-retail\peopletools\src\pssys\stmget.cppSQL error. Stmt #: 2705 Error Position: 16 Return: 904 - ORA-00904: "PTOPERPSWDV2": invalid identifier
Failed SQL stmt: SELECT VERSION, PTOPERPSWDV2, OPERPSWDSALT, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE OPRID = :1
System Error : Invalid User ID and password for signon.
The issue can be reproduced at will with the following steps:
1. Setup the environment to perform the upgrade
2. Run the step "Running the Updated PeopleTools Script" in Change Assistant
3. Access App Designer
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document