ROC Down with ORA-28001 Error

Document ID : KB000005861
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

After restarting the data management server, such as for an upgrade, patch, or other maintenance, the ROC page fails to load.

Error ORA-28001 is found in the nolio_dm_all.log file, such as in the following example:

[localhost-startStop-1] WARN (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:1221) - Could not retrieve version info from DB. org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-28001: the password has expired Line 60: org.flywaydb.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource

Environment:
Any Release Automation environment using Oracle database.
Cause:

ORA-28001 is an Oracle-specific message stating that the password used has expired.  This means that for the account Release Automation relies on to connect to the database, the password has expired and thus the connection is rejected.  ROC cannot load without a database connection. 

Resolution:

To ensure a reliable connection between Release Automation and the database, the password used for RA's login to Oracle should never expire, thus having an expiration policy on that specific account is not advised.  Remove the expiration policy, and if the password has been changed, ensure the distributed.properties file is updated to reflect the change.  Restart the Release Automation server service after making changes.