Daily housekeeping
Background
A programme called LMBU10mins is set to run from system start-up and has two objectives.
- Every ten minutes it will check the date and time value of the database. If it has changed from the previous reading then an interim backup file is created into the folder "LabManServ\Backup\IntrmBu". This is insurance in case of database corruption. It is explained further in the section on database corruption.
- At 2:30 every morning it will interrogate the database and produce a report of the previous day's orders. It will then email the report using the script "AlanRepEmail" to named individuals. This will assist in informing on current Client activity and business turnover.
Each night the script "copyArchived" will run. This will copy all the days reports to the AllArchived folder.
At system startup a script "copyLabDocumentation" is started, it will copy and synchronise the 'Lab Documentation' folder contents to the internal web server for reference from this help application.
At 05:30 each morning the terminal server will be re-booted ready for the coming day.
Application
When LabManager is started for the first time each day then the 'housekeeping' sequence is run. It goes as follows;
Perform a backup of both LabManager database files. (LabManager.mdb, LabManagerMess.mdb)
Empty the previous day's temporary folders, ie. "LabManager\Temp" and "LabManServ\Backup\IntrmBu"
Purge media batch codes which no longer valid.
Update job progress.
Re-assess report dates based on job progress.
Report samples that may be running later than expected. (...\DebugLog\LateSamplesLog###)
Report on jobs completed that haven't yet had a report generated. (...\DebugLog\coareportsGaplogLog###)
Report on any work that has been entered without a valid price code. (...\DebugLog\Log0PricesLog###)
An extract of a debug log file is shown here;
[user name on 2008TS02 (Build date 02/05/2018 12:34:58). Version 7E-6.2.67 05/06/2018]
07:04:28=NCLAll Main - dbPathStart= S:\LabManager\LabManServ\
07:04:29=NCLAll Main - dbpathArch= S:\LabManager\LabManServ\LMArchive\
07:04:30=NCLAll Main - dbPathTrain=S:\LabManager\LabManServ\LMTraining\
07:04:31=NCLAll Main - dataPathStart=J:\LabManager\>
07:04:32=NCLAll Main - datapathArch= J:\LabManager\LMArchive\
07:04:33=NCLAll Main - dataPathTrain= J:\LabManager\LMTraining\
07:04:34=NCLAll Main - dbPathAllArchfolder= S:\LabManager\LabManServAllArchive\
07:04:35=NCLAll Main - dataPathAllArchfolder= J:\LabManDataAllArchive\
07:04:37=NCLAll Main - frmMain = Printer.DeviceName= Xerox Phaser 3260 Reception (Tray 1)
07:04:38=frmMainModule SetDefPr= - Trying to set printer to Xerox Phaser 3260 Reception (Tray 2)
07:04:39=frmMainModule SetDefPr found= - Xerox Phaser 3260 Reception (Tray 2)
07:04:40=frmMainModule SetDefPr Returned= - Xerox Phaser 3260 Reception (Tray 2)
07:04:41=NCLAll= - frmMain = strUnHeadPrinterNameOriginal= Xerox Phaser 3260 Reception (Tray 2)
07:04:42=frmMainModule SetDefPr= - Trying to set printer to Xerox Phaser 3260 Reception (Tray 1)
07:04:43=frmMainModule SetDefPr found= - Xerox Phaser 3260 Reception (Tray 1)
07:04:44=frmMainModule SetDefPr Returned= - Xerox Phaser 3260 Reception (Tray 1)
07:04:45=NCLAll= - frmMain = strHeadPrinterName= Xerox Phaser 3260 Reception (Tray 1)
07:04:46=NCLAll - frmMain = strDefPrinterName= Xerox Phaser 3260 Reception (Tray 1)
07:04:47=getreminders - LogoutYN= doingBU
07:04:48=subbinDoingBU - LogoutYN= doingBU
07:04:49=makeBackup 1 - Entered backup routine
07:04:50=makeBackup 2 - LogoutYN= doingBU
07:04:51=makeBackup 3 - LogoutYN= doingBU
07:05:02=makeBackup 4 - LogoutYN= doingBU
07:05:08=makeBackup 5 - LogoutYN= doingBU
07:05:13=makeBackup 6 - LogoutYN= doingBU
07:05:14=makeBackup 7 - LogoutYN= doingBU
07:05:15=makeBackup 8 - LogoutYN= doingBU
07:05:16=makeBackup 9 - Left backup routine error=
07:05:17=makeBackupMess - LogoutYN= doingBU
07:05:18=makeBackupMess - LogoutYN= doingBU
07:05:19=makeBackupMess - LogoutYN= doingBU
07:05:20=intOperation Clearing Interim Backups Folder... - LogoutYN= doingBU
07:05:21=intOperation Clearing Temp Folder... - LogoutYN= doingBU
07:05:24=intOperation Purging Media Codes.. - LogoutYN= doingBU
07:05:46=intOperation Updating Job Progress.. - LogoutYN= doingBU
07:05:47=frmQryOrders GetReportDates - entered getreportdates
07:06:51=frmQryOrders GetReportDates - Exited frmQryOrders
07:06:52=intOperation intOperation - Left mnu23
07:06:53=getreminders - Done trafficlights
07:06:54=NCLAll - frmMain = done GotReminders, back into MDIForm_Load
07:06:56=Timer2 - Entered timer2
07:06:57=subbinDoingBU - LogoutYN= doingBU
07:06:58=intOperation Calculating late samples.. - LogoutYN= doingBU
07:07:03=intOperation Finding Missing Certificates.. - LogoutYN= doingBU
07:07:31=intOperation Finding zero prices.. - LogoutYN= doingBU
07:07:32=frmMain_timer2 - Housekeeping has completed!
07:07:33=subbinDoingBU - LogoutYN= False
Off Site Backups
Each evening a vpn connection is made to the developer's server and a copy of the most recent databases are saved. Additionally a copy backup of the working folders is taken. In the event of loss or catastrophic damage to the office hardware then the system could be up and running again in a very short time.