Error HTTP Status 500/database configuration problem when connecting to Clarity

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Database configuration problem/error HTTP status 500 when attempting to open the link to the Clarity application.

Error in logs:

ERROR 2021-04-26 14:36:04,371 [http-nio-80-exec-2] niku.union (none:none:none:none) Clarity failed to initialize. 
com.niku.union.config.ConfigurationException: The application failed to start because of a database configuration problem.  Please review the application log for specific error information.

Environment

Release : Any

Resolution

This database configuration error can be due to two main things:

1. The database version does not match the application version

• Check cmn_install_history and version.properties for any recent changes (install/upgrade/patch maintenance)

2. The database configuration is incorrect. 

• Follow the Technical Documentation to set up the database correctly 
• Ensure the database user and permissions and roles are set up correctly. There should be no missing permissions, or additional roles.
  
  

After the changes, restart Clarity and you should be able to connect again.

Additional Information

• If the issue started happening after a Distribute, check Unable to connect to database after Distribute
• This message can be logged when there is a DNS resolution issue with the DB Hostname.