Blank Database Statistics Page
|
Logged in as: Guest
|
|
Users viewing this topic:
none
|
|
Login  | |
|
Blank Database Statistics Page - 8.Jun.2008 7:59:03 AM
|
|
|
ajm
Posts: 7
Joined: 8.Jun.2008
Status: offline
|
Hi,
We are running Mailarchiver 4 build 20070616 on exchanger server 2003.
I recently noticed that on one of the archive stores the stastics page contains no values at all.
e.g.
quote:
Archive Store Name:
Archive Store Type:
Archive Store created on:
First email archived on: N/A
Last email archived on: N/A
Archive store contains: 0 emails
Server:
Database:
Database size:
Path to search index: N/A
Search index size: N/A
Indexed emails: N/A
Allow user browsing and searching:
Allow further archiving:
The database seems to still be searchable and functional however.
So far I have tried re-applying the settings for the store in question on the Archive Stores page and also rebuilt the search index, however the statistics page still has no values.
Any ideas?
thanks,
Alex
|
|
|
|
|
RE: Blank Database Statistics Page - 8.Jun.2008 4:43:56 PM
|
|
|
ajm
Posts: 7
Joined: 8.Jun.2008
Status: offline
|
Ok, further to this it seems the rebuild of the index never completed so the situation is now this:
1) Index says 'Rebuilding', however the index files stopped growing after about two hours. It looks like the indexing process just stopped after 2 hours. No errors in event log. As the index never finished rebuilding we can no longer search the store.
2) Trying to browse the store in question gives error: "Error: 3158: QueryFailed"
3) There are still no values in the statistics page for the store
Fortunately this isn't the active store so no new emails are going to it, however we still need to be able to search it!
|
|
|
|
|
RE: Blank Database Statistics Page - 9.Jun.2008 3:37:53 AM
|
|
|
josephd
Posts: 99
Joined: 3.Nov.2005
Status: offline
|
Hello Alex,
Do you have all patches applied to GFI MailArchiver 4? These patches are described in http://kbase.gfi.com/showarticle.asp?id=KBID003218.
If you have a valid Software Maintenance Agreement, we recommend to upgrade to the latest GFI MailArchiver 5 Service Release 1. In this version we added a lot of optimisations to Search and includes all patches mentioned in the kb above.
Thanks for using GFI products. Kind regards,
Joseph D'Emanuele
GFI Software Ltd
|
|
|
|
|
RE: Blank Database Statistics Page - 9.Jun.2008 5:51:50 AM
|
|
|
ajm
Posts: 7
Joined: 8.Jun.2008
Status: offline
|
Joseph,
Thanks for the reply. I have been able to get this store running again by restoring the database and index from backups. Fortunately a) I had backups and b) it was the 2008 1st Quarter store and so hasn't changed since March. I am guessing the problem was some sort of database corruption?
I did the following:
To clear 'Rebuilding' status
1. Stop the GFI MailArchiver Store service
2. Move the updatescache.fdb out of Store\Cache (C:\Program Files\GFI\MailArchiver\Store\Cache)
3. Restart the GFI MailArchiver Store service.
Then
1. Stopped the Mail Archiver Search service
2. Renamed both the Database and Index folders for the store in question
3. Restored Database and Index folders from backup
4. Restarted the Mail archiver Search service
We do have a maintenance agreement, so I will take your advice and upgrade to version 5 as soon as possible.
regards,
Alex
|
|
|
|
|
RE: Blank Database Statistics Page - 27.Jun.2008 4:16:02 PM
|
|
|
mbrunmeier
Posts: 17
Joined: 28.Apr.2008
Status: offline
|
Do you have any antivirus software running on the same server as GFI MailArchiver, its very possible this software can be hindering our software's ability to access the database. You should make sure this is properly excluded or even disabled to see if this is causing an issue.
http://kbase.gfi.com/showarticle.asp?id=KBID003311
This include any database and index locations that may be stored elsewhere.
_____________________________
Regards,
Matthew
GFI Software - www.gfi.com
|
|
|
|
|
RE: Blank Database Statistics Page - 30.Jun.2008 5:00:22 AM
|
|
|
ajm
Posts: 7
Joined: 8.Jun.2008
Status: offline
|
Matthew,
Thanks for the response, but unfortunately it was definitely database corruption. I used Firebird's gfix tool and it identified a corrupt database but was unable to fix it. I had to restore from backups again.
Basically all the binary and index files are still there, however the .FDB file is 24 hours earlier (restored from backup). Is there any way to rebuild the fdb database from the binary files?
It seems that the entire store is at the mercy of one large fdb file. If that gets corrupted then the store is goosed. Not necessarily a problem on a non-active store that can be restored from tape, but a nightmare on the live store where mail is being currently archived to.
Alex
|
|
|
|
|
RE: Blank Database Statistics Page - 6.Jul.2008 1:45:50 PM
|
|
|
John Letourneau
Posts: 923
Joined: 28.Apr.2008
From: Clayton, NC
Status: offline
|
Alex,
If you do have any antivirus software running on this server please make sure you do have D:\Archive\* excluded from these scans. This could potentially be causing the corruption you are seeing.
_____________________________
Regards,
John Letourneau - Technical Support Representative
GFI Software - www.gfi.com
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
 Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts |
|
|
Printable Version
