Troubleshooting Upgradedb Problems
Here are some problems you may encounter when using the upgradedb utility.
The following message occurs shortly after the upgradedb utility starts processing a database: “E_SC0206 An internal error prevents further processing of this query.”
This message is seen when upgradedb –all is used, and the database data ROOT location is not the same as others processed in the same upgradedb run. The errlog.log shows the message ”E_DM9004_BAD_FILE_OPEN” referencing a filename: aaaaaaaa.cnf, shortly before the E_SC0206 message.
This message has occasionally been seen in various versions of upgradedb. Simply rerun upgradedb for the one failed database, and continue the upgrade.
After the upgrade running ALTER PASSPHRASE for an encrypted database reports the error “E_US24C1 Incorrect passphrase specified.” even though the passphrase is correct.
The upgrade for the encrypted database might not have been completed by unlocking the database after running the upgradedb utility. Try directly connecting to the database and running the statement “ENABLE PASSPHRASE ‘<pass phrase>’;” to complete the upgrade of this database.
After the upgrade running DISABLE PASSPHRASE for an encrypted database reports the error “E_US24D4 Database upgrade is not yet complete. Please enable passphrase to complete upgrade first.”
Try directly connecting to the database and running the statement “ENABLE PASSPHRASE ‘<pass phrase>’;” to complete the upgrade of this database.
For a database, the upgradedb utility reports the error “Aborting upgrade of this database because of error E_US255A Access to locked/encrypted database is not allowed.”
This is an encrypted database that is still locked and therefore upgradedb cannot connect to this database. As the installation owner, use the Terminal Monitor (the sql utility) and connect to the iidbdb database. In this database, unlock the respective database by running the statement “ENABLE PASSPHRASE ‘<pass phrase>’ ON DATABASE <database>;”. Then run the upgradedb utility again for this individual database: “upgradedb <database>”. After successfully running the upgradedb utility for this database, remember to complete the upgrade by running “ENABLE PASSPHRASE ‘<pass phrase>’;” in a direct connection to the database.
Last modified date: 12/19/2024