My Oracle Support Banner

E-SEC: Unable To Run Command "encrypt password *" in Data Mover, after a SQL Update (Doc ID 2423096.1)

Last updated on DECEMBER 16, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.56 [Release 8.4]
Information in this document applies to any platform.


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





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

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