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 ###################
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.