Urchin WebAnalytics Software is discontinued and is no longer supported. All Urchin documentation applies only to the Urchin product as it was at the time of discontinuation, and does not apply to any Google Analytics products or services.

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

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

WARNING: (7063-54-63) Unable to open database for writing
since it has been archived
This error occurs since the log tracking databases are stored on a per month basis with Urchin 5. 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 since Urchin will not allow reading/writing to databases that have been archived.There are several 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).
See Also

  • Wildcard & Date Substitution in Log Path: http://www.google.com/support/urchin45/bin/answer.py?answer=28776

  • Search
    Clear search
    Close search
    Google apps
    Main menu
    Search Help Center