firebird db viewer

- The RPM Remote Print Manager service will not run. It starts, then immediately stops.
- The RPM User Interface reports "Error Getting License".
- An entry can be found in the Windows Event Viewer for RPM Remote Print Manager.
Cause
There is a known limitation in the Firebird Database related to Transaction Limits. When this limit is reached, RPM Remote Print Manager is unable to attach to the Firebird Database where it stores its settings.
Resolution 1
The Firebird Database where the configuration settings are stored can be placed into read-only mode, backed up, and restored. The RPM system service should be offline during this process. The commands to achieve this are:
- gfix.exe -mode read_only -user sysdba -password masterkey
- gbak.exe -backup -user sysdba -password masterkey
- gbak.exe -create -user sysdba -password masterkey
- gfix -mode read_write -user sysdba -password masterkey
After completing these steps your old database should still exist, and a new copy of your database with your settings will exist as rpm-new.fdb.
The original rpm.fdb should be renamed or deleted, and the rpm-new.fbd should be renamed to rpm.fdb. Once that has been completed the RPM system service can be restarted.