Error Executing Process: Could not Read a Hi Value

Products

• CA Release Automation - Release Operations Center (Nolio)
• CA Release Automation - DataManagement Server (Nolio)

Issue/Introduction

Problem:

When attempting to execute any action on a new installation of Release Automation, the following error occurs: 

Unexpected error on server [Failed to create job for this test. Cause: org.hibernate.id.IdentifierGenerationException: could not read a hi value - you need to populate the table: uid_table]. 

 

Cause:

The "uid_table", one likely among various empty tables in the database, does not have a value, whereas it should have a numerical value coinciding with the number of users that exist in the "users" table. 

Database tables such as this one will be empty if there was a database permissions problem during installation that prevented this table from being properly updated after users were created. The following example shows errors found if Oracle database is used (similar errors will occur with other databases), which would be found in the "center_upgrade.log" file:

[localhost-startStop-1] ERROR (com.nolio.platform.server.dataservices.services.upgrade.UpgradeDBServiceImpl:209) - Upgrade failed - Exception caught during upgrade [ORA-01950: no privileges on tablespace 'USERS'

; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: ORA-01950: no privileges on tablespace 'USERS' 

]. Please manually update the version table back to the previous version. 

org.springframework.dao.InvalidDataAccessResourceUsageException: ORA-01950: no privileges on tablespace 'USERS' 

; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: ORA-01950: no privileges on tablespace 'USERS' 

 

 

Resolution:

Because of the installation error above and the various empty DB tables, a fresh installation should be performed with care to ensure proper database user permissions are in place. Installation logs should be reviewed after installation to ensure no errors were encountered before attempting to use the software.

Environment

Release: NOLNAC99000-5.5-Nolio-Automation Center
Component: