E-SEC: Unable To Run Command "encrypt password *" in Data Mover, after a SQL Update
(Doc ID 2423096.1)
Last updated on APRIL 04, 2025
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.56 [Release 8.4]Information in this document applies to any platform.
Symptoms
Trying to run "encrypt password *" but it is failing with a rollback when executing the following instructions:
Executed the following solution:
Trace shows a rollback:
1-146 16.18.30 0.001000 Cur#4.6772.notSamTran RC=0 Dur=0.000000 Open Cursor Handle=0000000002BF9190
1-147 16.18.30 0.000000 Cur#4.6772.OPS RC=0 Dur=0.000000 COM Stmt=SELECT VERSION FROM PSACCESSPRFL WHERE SYMBOLICID = :1
1-148 16.18.30 0.000000 Cur#4.6772.OPS RC=0 Dur=0.000000 Bind-1 type=2 length=8 value=<SYMBOLICID2>
1-149 16.18.30 0.001000 Cur#4.6772.OPS RC=0 Dur=0.000000 Disconnect
1-150 16.19.19 48.117000 Cur#3.6772.OPS RC=0 Dur=0.000000 Disconnect
1-151 16.19.19 0.002000 Cur#1.6772.OPS RC=0 Dur=0.002000 Rollback
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |