UVMS process is down and can't be restarted

Document ID : KB000087009
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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