How do I recover from 'Unable to open database for writing since it has been archived' error?


This article authored by "FriedrichsoftwareResources", an Urchin Software Authorized Consultant


How do I recover from 'Unable to open database for writing since it has been archived' error?

When attempting to run a profile in Urchin 6, you receive this error:

WARNING: (7063-54-63) Unable to open database for writing
since it has been archived

This error occurs because the log tracking databases are stored on a per month basis with Urchin. During processing, Urchin reads the first couple of lines from the log file, determines which month this log belongs to and attempts to open the databases for that month. Since the databases for that month have been archived, an error is returned because Urchin will not allow reading/writing to databases that have been archived.There are two workarounds:

  1. Turn off the archive feature and uncompress the *-archive.zip files for the affected profiles and remove the *-archive.zip files.
  2. Change the log wildcarding to include a date matching string (perhaps YY* or YYYY* can be used to identify files only for this year).