dbsrv8: cannot open transaction log file

  • 3181205
  • 15-Jun-2007
  • 30-Apr-2012

Environment


Novell ZENworks 7 Desktop Management on Linux Support Pack 1 - ZDML7 SP1 Inventory
Novell ZENworks 7 Desktop Management Support Pack 1 - ZDM7 SP1 Inventory

Situation

The DBSRV8 is unable to open a database for inventory (or other ZDM databases).

On the java console you see the following errors:
Error: Cannot open transaction log file - no such file or directory
*** ERROR *** Assertion failed: 201117 Attempt to close a file marked as dirty

Resolution

To fix this problem you need to do the following:
  1. copy sys:\system\mgmtdbs.ncf to sys:\system\mgmtrec.ncf
  2. edit the mgmtrec.ncf. Add the parameter -f
    If you have multiple databases loaded, you need to check the java screen which database has the problem and you then need to remove all other from mgmtrec.ncf
  3. on the server unload dbsrv8.nlm
  4. on the server start mgmtrec.ncf. This will take a while. At the end you will be asked to press space to continue.
  5. on the server start mgmtdbs.ncf.

Additional Information

Sysbase documentation:
Use the -f database option for recovery—either to force the database server to start after the transaction log has been lost, or to force the database server to start using a transaction log it would otherwise not find. Note that -f is a database option, not a server option. Once the recovery is complete, you should stop your server and restart without the -f option.