Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #31169

    I’m trying to backup a database that was created with an older CO version (1053 or 1055 – whatever was current in June) then just upgraded to 1058 before backup. Using CO starter edition v1058.

    I’m getting an error as in the screenshot – this is on a single user PC with DB in local folder, and there is only one copy of CO running. VSS is enabled for Mozy and Shadowprotect Desktop backups.

    Tried doing a Check and Repair – this found no errors and didn’t fix the problem.

    There’s no important data in the DB but it does have the customizations I’ve done to date – is there some way to export those to a CSV file or similar?

    #32615

    Support
    Keymaster

    Hi – thanks for your post. You can download the 1053 or 1055 updates from the following links :-

    http://pioneersoftware.co.uk/files/cov4/update_1053.exe
    http://pioneersoftware.co.uk/files/cov4/update_1055.exe

    Installing these older update files will ‘roll back’ your ClinicOffice installation to that version. However, this shouldn’t be necessary and you should be able to restore any database on any version.

    If you have no success, please send our support team an email (support@pioneersoftware.co.uk) with the database backup attached (as long as it’s not too big) along with a full description of the problem and we take a look for you.

    #32616

    Hi – for some reason the screenshot upload didn’t work… trying again with this post, see attachment (scroll down a bit for the error):

    [attachment=0:y8w9k9s1]Error on backup.png[/attachment:y8w9k9s1]

    The problem is with creating a backup, not with a restore – no backup file is created and the error 700 shown in screenshot is displayed.

    There is only one CO process on this system, and it’s a single user setup.

    #32617

    Support
    Keymaster

    Please can you send our support team an email (support@pioneersoftware.co.uk) with the database backup attached (as long as it’s not too big) along with a full description of the problem and we take a look for you.

    If the backup is larger than 2 MB then please can you upload it following these instructions :-
    https://pioneersoftware.co.uk/forums/topic/faq-301-how-do-i-upload-my-database-to-your-ftp-server

    Many thanks.

    #32618

    Uploaded the DB to your FTP site and emailed support – thanks.

    #32619

    Support
    Keymaster

    Thanks for sending your database. We have restored it on a test machine, we have logged on, tested the core features, logged off, taken a backup, restored the new backup and re-tested the restored database and we cannot find any problem at all.

    If this problem persists, then most likely it is an issue with the installation of ClinicOffice on your computer. Please completely uninstall ClinicOffice then download the full installation again from here :-
    pioneersoftware.co.uk/files/cov4/cov4_setup.exe

    #32620

    Thanks for the response. I’ve tried some more things, with no effect on this except as mentioned:

    – uninstalled CO then re-installed v1058
    – rebooted PC
    – exited CO then ran again, and tried the backup before logging onto the main SLT DB
    – did backup of the sample database – first backup went fine, but on re-running CO and trying again I got the same error. So I’m getting this error on both DBs, but it’s intermittent on the sample DB and fully repeatable on the main SLT DB (which is the one I’ve been using).

    As you mentioned, it does seem to be something to do with this installation, not the DBs.

    Are there any issues with CO and VSS (volume shadow copy) based backups? I’m using both Mozy and ShadowProtect Desktop. Would it help if I excluded the COv4 data directories from Mozy temporarily? I can’t exclude from ShadowProtect as it’s an image based backup.

    Also, what happens if CO is run in the morning and is still open when Mozy does a VSS based backup at night – do the files get backed up in the state as of first run, due to VSS?

    #32621

    Support
    Keymaster

    >> Are there any issues with CO and VSS (volume shadow copy) based backups?
    No, there are no known issues.

    >> Would it help if I excluded the COv4 data directories from Mozy temporarily?
    Yes it might be an idea to try that.

    >> Also, what happens if CO is run in the morning and is still open when Mozy does a VSS based
    >> backup at night

    That’s really a question for your backup company and how it handles files that are in use.

    The error in the ClinicOffice screenshot that you posted indicates that the database files are in use and locked at the time when ClinicOffice is trying to work on them. We’d recommend disabling any applications (continuous backups/anti-virus etc.) which may be locking the files to see if you can discern which program is causing the problem.

    #32622

    This seems to have fixed itself – I deleted some test data, and also restored from a separate file-level backup to revert some customizations, and backups now work fine on this database… same installation of ClinicOffice. Can’t quite work out how this has fixed things but it has, for now at least.

    It’s also rather odd that the specific error message suggests a syntax error in a statement – see the screenshot in my 2nd post.

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic.