User Passwords Are Not Being Re-encrypted During The Database Upgrade From 6.0.1 to 7.0.1 (Doc ID 1536167.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Argus Safety - Version 7.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 30-Sep-2014***
***Checked for relevance on 23-JUN-2017***

Symptoms

The 7.0.1 upgrade is not able to re-encrypt the existing users passwords (error log excerpt shown below), and as such after the upgrade users cannot login with their existing password. We would have to reset them all and force the users to change their password on first login. Other than user password issue, the upgrade completed normally
-- Migrate password started

1. Error while updating user password encryptions
Error While upgrading password for User: xxxxx Enterprise: DEFAULT
This user's password can be reset from Argus Console -> Access Management.
ERROR: Padding is invalid and cannot be removed.
at ArgusDBInstall.frmDBUpgradeExec.UpdateUserPasswords(String HashAlgo, Int64 DeoptCounter)

2 . Error while updating user password history encryptions
Error While upgrading password for User: xxxxx Enterprise: DEFAULT Seq_Num: 1
Delete this entry from CFG_USERS_PASSHIST table.
ERROR: Padding is invalid and cannot be removed.
at ArgusDBInstall.frmDBUpgradeExec.UpdateUserHistPasswords(String HashAlgo, Int64 DeoptCounter)

3. Error while upgrading reset password for enterprise: 1
Correct this entry in CMN_PROFILE_ENTERPRISE table through back-end.
ERROR: Padding is invalid and cannot be removed.
at ArgusDBInstall.frmDBUpgradeExec.UpdateProfilePasswords(String HashAlgo, Int64 DeoptCounter)

4. Error while upgrading common password for key: COMMON_PASSWORD
Correct this entry in CMN_PROFILE_GLOBAL table using Cryptography Key Editor.
ERROR: Object reference not set to an instance of an object.
at ArgusDBInstall.frmDBUpgradeExec.UpdateProfileSwitches()

Cause

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 hundreds of Community platforms