UVMS process is down and can't be restarted

Products

• CA Automic Dollar Universe

Issue/Introduction

Error Message :
In the UVMS log file ''userver.log'':
###################
Impossible to start univiewer on "hostname": Caused by: ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database
################### 

Patch level detected:Dollar Universe 6.1.00
Product Version: Dollar.Universe 6.1.0

Description :The Univiewer Management Server crashed and when it's restarted, it goes directly down again.
UVMS cannot be started after a reboot of the server done without the UVMS have been stopped previously

Environment

OS: All
OS Version: All supported versions

Cause

Cause type:
Configuration
Root Cause: After a crash and/or reboot of the hosting server, without a normal stop of UVMS before, a lock is created on the database of the UVMS (derby or external) could occur. In fact, an action was ongoing with the DB related to the UVMS when the crash of the host occurred and this action created this kind of lock even with the host reboot.

Resolution

The lock on the DB is released by removing the .lck files from the UVMS directory:
\univiewer_server\data\data\uvmsdb\

Following this action, a UVMS restart is mandatory.

Fix Status: No Fix
 

Additional Information

Workaround :
N/A