UVMS not starting ERROR: data/uvmsdb not found with user other than root

Products

• CA Automic Dollar Universe

Issue/Introduction

After restart UVMS does not start, please note that UVMS was installed as the user uvmsadmin (not by root).

The errors in uvserver.log are:

|ERROR| main | org.hibernate.util.JDBCExceptionReporter | An SQL data change is not permitted for a read-only connection, user or database. 
|ERROR| main | com.orsyp.central.aspect.DataAccessExceptionTranslator | org.hibernate.exception.GenericJDBCException: could not execute native bulk manipulation query 
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute native bulk manipulation query
Caused by: java.sql.SQLException: An SQL data change is not permitted for a read-only connection, user or database.
Caused by: ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database.
|ERROR| main | org.hibernate.util.JDBCExceptionReporter | Cannot create PoolableConnectionFactory (Database '/uvms_folder/data/data/uvmsdb' not found.) 

And in derby.log:

java.sql exception: Database '/uvms_folder/data/data/uvmsdb' not found

Environment

Release : 6.x and 7.x

Component : Univiewer Management Server

Database: Internal (Derby)

OS: Linux

Cause

Permissions issue: The start of the UVMS was done with a different user (root) and this user took ownership of a file in the uvmsdb that could not be written by the regular user (uvmsadmin) that started UVMS before.

Resolution

Restore ownerships for all files within the UVMS folder.

For example, on this case by executing command from root account on the UVMS installation directory

chown -R uvmsadmin:uvmsadmin /path_to_the_uvms_folder