My Oracle Support Banner

E-SEC: Unable To Run "encrypt password *" after SQL update (Doc ID 2423096.1)

Last updated on JULY 15, 2018

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
UPDATE PSACCESSPRFL set ACCESSID = 'SYSADM' , ACCESSPSWD = '' , ENCRYPTED = 0 where SYMBOLICID = 'SYSADM1';
UPDATE PSACCESSPRFL set ACCESSID = 'SYSSTNBY' , ACCESSPSWD = '' , ENCRYPTED = 0 where SYMBOLICID = 'SYSSTNBY';

ENCRYPT_PASSWORD *;

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=SYSSTNBY
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!


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