Issue saving favorites - DB out of space - Internal Derby OM Web Viewer 12.1

Products

• Output Management Web Viewer

Issue/Introduction

There are issues creating favorites and not seeing favorites that have been previously created. Restarting the application only briefly resolves the issue.

 

Environment

• Output Management Web Viewer 12.1
• Apache Derby

Cause

many SQL exceptions in logs suggesting a memory / space problem:
Caused by:

ERROR XSDG1: Page Page(162,Container(0, 15424)) could not be written to disk, please check if the disk is full, or if a file system limit, such as a quota or a maximum file size, has been reached.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)

Resolution

/database/RunTimeCacheDB directory...
The space in which this directory is located was at 100% full, cleaned up so now at 57%

1. Stop the application
2. Delete the /database/RunTimeCacheDB  directory (the whole folder), which will be recreated when the application is restarted.
3. Ensure that the directory where the /database/AdminDB lives is allocated ample memory/space.

Additional Information

The real solution is to follow the recommendation in the product documentation and NOT use the internal Derby database for production. Instead, use a commercial, JDBC-compliant database like DB2, Oracle, SQL Server, etc.