Users getting SQL error messages trying to logon to OM Web Viewer 14.0

Products

• Output Management Web Viewer

Issue/Introduction

When any user tries to log on to WV 14 the following SQL error is occurring:

No maintenance was applied to View or Web Viewer recently. This task was working properly and stopped working suddenly.

Environment

Output Management Web Viewer™ for z/OS

Cause

The Tomcat log shows there is an issue with the Web Viewer H2 database

Resolution

During startup, OM Web Viewer checks the database to verify that all the expected tables exist – in this case it’s saying that there are tables that cannot be found:

ERROR <*init> <> Failure executing database script
org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "VIEW_USER" not found; SQL statement:
ALTER TABLE CV_MASTER.VIEW_USER
ADD COLUMN IF NOT EXISTS GROUP_ID INT NOT NULL DEFAULT 0 

1. Verify that the filesystem where the database is stored is not close to filled as running out of space can cause database issues.
2. To recover the Web Viewer H2 database you will need to restore it from a backup.
3. If you do not have a backup, you will need to create a new one - keep in mind that if you create a new one then it will be empty and you will need to login as an admin and add your repositories.