"ERROR: "SQL Error: 42102, SQLState: 42S02" H2 database Web Viewer 14.0

Products

• Output Management Web Viewer

Issue/Introduction

A production server lost an H2 database. The splash screen and the repository list were rebuilt and then the server was up and running ok. Everything was working fine until the following errors on the H2 database (internal) occurred and It stopped working.

WARN  <*N/A> <4942> SQL Error: 42102, SQLState: 42S02                                                      
ERROR <*N/A> <4942> Table "REPOSITORY_GROUPS" not found; SQL statement:

The same message continually recurred. After a restart, the same error continued.

Environment

Output Management Web Viewer™ for z/OS

Cause

According to the logs, Web Viewer did not create an empty database. The database checks show that at least the CV_MASTER schema and REPOSITORY table existed at that time. That is why there were subsequent errors - because that database was in an inconsistent state.

Resolution

To recover, the ZFS was renamed and a new one created, then Web Viewer created a new H2 database and it was working again.