search cancel

Communication error logging into Web Viewer 14.0 after applying maintenance

book

Article ID: 253425

calendar_today

Updated On:

Products

Output Management Web Viewer

Issue/Introduction

Getting message communication error with server when logging in to Webviewer. 

From the Tomcat log in debug mode:

INFO  <ABCD007> <105> CAHVS0116I User abcd007 login requested
WARN  <ABCD007> <105> SQL Error: 90097, SQLState: 90097
ERROR <ABCD007> <105> The database is read only; SQL statement:  delete from CV_MASTER.VIEW_USER where LST_ACTION<? [90097-199]
WARN  <ABCD007> <105> SQL Error: 90097, SQLState: 90097
ERROR <ABCD007> <105> The database is read only; SQL statement: delete from CV_MASTER.ACTIVE_REPORTS where GUID not in  (select distinct usersessio1_.GUID from CV_MASTER.VIEW_USER usersessio1_ 0097-199]

Environment

Release : 14.0

Web Viewer

DVWEB

Cause

The user running the started task did not have write access to the database files.

Resolution

From the config.cfg file:

DBTYPE = "H2";
DBLOCATION = "/usr/lpp/CAOMWeb/MTC_14/CCS/tpv/tomcat/H2FORJES";

which indicates an internal database, so the user running the started task, i.e. user VIEWABC should have write access to files:       (for example)

/usr/lpp/CAOMWeb/MTC_14/CCS/tpv/tomcat/H2FORJES.mv.db 
/usr/lpp/CAOMWeb/MTC_14/CCS/tpv/tomcat/H2FORJES.trace.db

Changed the MODE to 777 and that resolved the problem temporarily. There was no OWNER listed for the files and Directories.  Fixing that will resolve the problem permanently.