cannot open database
Getting an error that the database file "cannot be opened or created" I've been using Surfulater for yearrs and sometimes get erros like this after a crach, but tit always fixes itself on the next start -- not this time (tried restarting several times)
Support Staff 2 Posted by Neville on 13 Nov, 2011 07:29 PM
Shelton, there should be a specific error code displayed as part of the message you are seeing. What is that?
Hopefully your daily backups include Surfulater and you will be able to restore to an earlier good version of the database.
-Neville
3 Posted by sheltono on 17 Nov, 2011 04:29 PM
Neville, I've attached a zip file containing the two error messages. The articles are being saved, but the pages are not.
Hopefully, there is something I can do other than using a backup, as I would lose a lot of stuff added since my last good backup.
-Shelton
Support Staff 4 Posted by Neville on 21 Nov, 2011 06:32 AM
Shelton, I've not seen this specific error before and it is possible the database is damaged beyond repair or if repairable may loose pages etc. you've already saved. I've attached a zip file with a utility you can use to try and repair the database.
Unzip into the folder with the WDB file and run: dpmgr repair "xxx.SurfulaterWDB" from a DOS/Command prompt, where xxx is the name of the Knowledge Base. Backup the Knowledge base first.
The best option by far is to always restore from the previous days backup when something like this occurs.
-Neville
5 Posted by sheltono on 21 Nov, 2011 11:29 PM
Hi Neville,
Thanks for responding.
Wen I run the command, this is what happens:
c:\Users\soliver\Downloads\Surfulator>dpmgr repair
"MyKnowledge.SurfulaterWDB"
dpmgr: MyKnowledge.SurfulaterWDB: stat error
An thoughts?
-Shelton
Support Staff 6 Posted by Neville on 22 Nov, 2011 08:07 PM
Shelton,
You need to run this from the folder where your Knowledge Base files are located. Or you could copy the MyKnowledge.SurfulaterWDB to c:\Users\soliver\Downloads\Surfulator, run dpmgr and if successful copy MyKnowledge.SurfulaterWDB back where it belongs.
-Neville