HP ALM, Micro Focus ALM, Oracle, Upgrade
On an Oracle database, the project schema's passwords were recently updated during an ALM upgrade from 11.52 to 12.53. Once the Site Admin schema was upgraded, in site admin the user would click on a project and the project would tell us it could not connect. The logs say it was a bad username/password. In the Site Admin projects table, we copied the password from a newly created project into the password field of an old project.
We restarted the ALM service and the issue repeated itself.
Be sure to click the Commit button on the Oracle SQL Developer studio after executing the SQL query.