Return
-
Title
There was a pr -
Description
When run Upgrade Encryption utility, gets error "There was a problem with decrypting xxxx from STATUSER table"
-
Cause
Stat is having problems with the encryption algorithm, it's having difficulty with one of the passwords in the STATUSER table.
-
Resolution
Have the DBA execute the following DML against your Stat db:
1. UPDATE STAT.STATUSER
SET PASSWORD=''
WHERE PASSWORD= 'xxxx'
COMMIT;
2. Now try to run the encryption again to see if you are getting any additional errors. Please keep in mind that if there is a problem with another password for the STATUSER account then you can use the above sql to do the update. However you may need to plug in other passwords that stat is complaining about.