Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Accessing Backup data file

Hi Has anyone had the need to access their data backup file? For some reason today my computer is refusing to open the data.ioc file and so we have tried to open and access the latest back up file... with no luck? Not sure what has happened to our original file - we can see it, we can even open it, but when we open it - there is no data in it... so trying to access the backup file to import our data was the next obvious step - but alas... is clearly isn't in the right format for the client file to recognise!

Anyone else had this experience or know how to re-load from a backup file?

Comments

  • I have just found an error log:
    29 Apr 2013 10:44:08,923 WARN (ish.oncourse.server.AngelServer::170) - onCourse server (build 4.0.1) starting...
    29 Apr 2013 10:44:28,953 WARN (ish.oncourse.server.AngelServer:logStartup:432) - Starting database service
    29 Apr 2013 10:44:30,763 WARN (ish.oncourse.server.db.DerbyAdapter::178) - succeeded in initialising the data file : C:\Users\BlackSwan\Documents\Dropbox\Black Swan Institute\Student Management System\Oncourse New\Oncourse New - Data File\onCourse.iocdata\onCourse
    29 Apr 2013 10:44:41,168 WARN (ish.oncourse.server.AngelServer:logStartup:432) - Starting internal services
    29 Apr 2013 10:44:44,444 WARN (ish.oncourse.server.AngelServer:logStartup:432) - Running data upgrades
    29 Apr 2013 10:44:45,458 WARN (ish.oncourse.server.db.DataUpgradeService:upgradeData:133) - data population running...
    29 Apr 2013 10:44:46,550 WARN (ish.oncourse.server.db.DataUpgradeService:upgradeData:143) - applying the data upgrade patches...
    29 Apr 2013 10:44:46,566 WARN (ish.oncourse.server.db.DataUpgradeService:upgradeData:157) - setting new wed version preference...
    29 Apr 2013 10:44:46,566 WARN (ish.oncourse.server.AngelServer:logStartup:432) - Preparing server for client connections
    29 Apr 2013 10:44:57,361 WARN (ish.oncourse.server.AngelServer:logStartup:432) - Configuring cron tasks
    29 Apr 2013 10:44:57,439 WARN (ish.oncourse.server.AngelServer:logStartup:432) - Starting cron
    29 Apr 2013 10:44:57,439 WARN (ish.oncourse.server.AngelServer:logStartup:432) - Server ready
    29 Apr 2013 10:44:57,845 WARN (ish.oncourse.server.services.DelayedEnrolmentIncomePostingJob:executeWithDate:78) - Processing prepaid fees for Mon Apr 29 10:44:57 WST 2013, found 3 records to process
    29 Apr 2013 11:00:00,013 WARN (ish.oncourse.server.services.BackupJob:execute:121) - performing backup
    29 Apr 2013 12:00:00,006 WARN (ish.oncourse.server.services.BackupJob:execute:121) - performing backup
    29 Apr 2013 13:00:00,001 WARN (ish.oncourse.server.services.BackupJob:execute:121) - performing backup
    29 Apr 2013 14:00:00,003 WARN (ish.oncourse.server.services.BackupJob:execute:121) - performing backup
    29 Apr 2013 15:00:00,014 WARN (ish.oncourse.server.services.BackupJob:execute:121) - performing backup
    29 Apr 2013 15:16:18,076 WARN (ish.oncourse.server.AngelServer::170) - onCourse server (build 4.0.1) starting...
    29 Apr 2013 15:31:08,488 WARN (ish.oncourse.server.AngelServer:logStartup:432) - Starting database service
    29 Apr 2013 15:31:08,785 WARN (ish.oncourse.server.db.DerbyAdapter::178) - succeeded in initialising the data file : C:\Users\BlackSwan\Dropbox\WATI BSIT\OnCourse - WATI\OnCourse\onCourse.iocdata\onCourse
    29 Apr 2013 15:31:16,881 ERROR(ish.oncourse.server.db.DatabaseService:start:118) - Database upgrade failed

    Does this mean that we have lost all our files? (sorry for the full page dump)

    Will it impact if we have two different databases on the one computer? I work with another RTO and we share an admin person - so on her computer we have two different data files - stored and accessed from two different folders.... is this what is causing my problems?
  • You can have multiple databases, that's fine. But getting them mixed up could cause problems.

    Restoring the database is slightly complicated, but the docs here are a starting point: http://db.apache.org/derby/docs/10.1/adminguide/tadminhubbkup44.html

    As for your "Database upgrade failed" problem, it looks to me that you had two onCourse servers pointing to the same database at the same time. That's really bad. See how you are starting up one at 10:44am but then 15 minutes later starting up another in a different place.

    Finally, dropbox is a really really bad place to put your data files. You cannot share databases in this way (it isn't like a Word document) and could also be a cause for corruption, as well as very poor performance.
  • Wow - OK Ari thanks for the reply... we have removed our database from Dropbox - where we only used this as a place to store our records and as a back up. however that hasn't solved our problem - and as far as having two servers running... I think what has happened we were having issues, then closed down one computer (as it crashed) and opened it up on another... argh! I guess that was the wrong thing to do... "live and learn".

    We will try reinstalling the data via the link you have given... hopefully if we go step by step it will work for us...
  • ish is now offering a hosted onCourse service if that is of interest to you. That way we take care of the updates and backups at our end. Let me know if you want more information about that.

    Good luck.
Sign In or Register to comment.