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

book

Article ID: 198025

calendar_today

Updated On:

Products

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

 

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)

Environment

Release : 12.1

Component : CA OUTPUT MANAGEMENT WEB VIEWER FOR ALL PLATFORMS

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.