This document describes action to be taken in the event of corruption of Escape data files as the result of network failure or ongoing network problems. Problems that can affect the integrity of your Escape system generally fall into two categories:
Sometimes it is easy to identify that a network catastrophe has occurred. If a server crashes, or the power goes out, everyone knows immediately. But when a router goes bad, or cabling is damaged, it can be more difficult to identify. Whatever the cause, the symptoms Escape reports will generally be one of the following:
The following steps are a guideline to recovering from a network disaster, once you have determined and corrected the cause. The assumption here is that you believe that your Escape system has been compromised.
Always notify Escape Customer Care immediately when you suspect that network problems have affected the integrity of your system!
Lock the system and exit all users. Verify at the server console that no Escape files are opened by ANY users. Keep the system locked down until you are certain system integrity exists.
TIP: Search the Knowledge Base for any up-to-the-minute disaster recovery suggestions.
Copy your production system to a "recovery" system location so you can test to determine the existence and nature of Escape system problems.
NOTE: Do not overwrite your existing Test system! We may need data from there to complete a recovery. You may also want to zip up your production system for extra protection if there are issues during recovery.
In the Recovery system, have several users run a variety of tests within the software to insure the integrity of the system. View and edit requisitions, view accounts by different sort methods, view journal entries, etc. Run critical processes such as PO printing, AP check runs, Payroll calculations. Review system log and .DMP files. If you are confident that the Escape data files are intact, go to step 8. Otherwise, report your findings to Escape Customer Care and proceed with step 4.
Verify that you have a good full backup from the previous day. Tell users that you will be restoring backup and that they need to note all work done today, since they must redo that work.
Restore your good backup to the Production location. Verify that the restore was successful, that all files were restored.
Check File attributes or NetWare flagging in the \ESCAPE folder. Check Trustee Rights. Check user folder & file rights for the Escape data folders.
Go into Escape System Manager module, lock this restored system, and verify that user authorities, system setup and user menus match those in the Recovery system database. (Changes may have been made since the backup.)
Run the utilities outlined in the subsequent section Escape System Utilities.
Copy the restored and/or repaired system to Recovery before performing any further tests.
Repeat the test procedures you performed in step 3 above. If problems persist, call Escape Technology immediately. If you are satisfied that your network is stable and the Escape system is repaired, go to the next step.
Allow a few system users, representative of various departments back into the system. Monitor the system closely. Check logs and .DMP files often. If the consensus is that the system is stable, continue rollout.
At the end of the day, make a full Escape backup, verify it, and store it out of your backup rotation.
The following utilities should be run in the event of a system corruption due to network problems.
TIP: Complete instructions for these utilities can be found in the Troubleshooting section of the Escape Finance Setup and Maintenance Guide.
Run the Escape utility CHKACCTS on the current fiscal year to verify the integrity of your account-related data files. This will read and report errors in all files, including accounts, account balance, account index and extract files, and account key files. When the utility is finished, review the *.ERR files in the \ESCAPE\FY sub-directory. For the 2004 FY, check \ESCAPE\2004.
Run FIXUSERS to clear stranded records from Escape data files. To run this utility, start from the \ESCAPE\COMMON directory and type the following: \ESCAPE\UTIL\FIXUSERS.EXE.
This utility creates its own error log called FIXUSERS.AUD. You will see information about the process displayed on the screen. This same information will be recorded to the AUD file. If there are any error messages print out FIXUSERS.AUD and notify Escape Technology.
Once you are sure of the integrity of the accounts files and the JEHDR and JEDTL key files, run FIXACCTS from the Chart module. FIXACCTS will read through the posted journal entries and update account balances based on the journal entries. (For more information about FIXACCTS, please see the Finance Setup and Maintenance Guide, Troubleshooting section.)
Run the Escape utilities SCANJE and SCANJDTL to search for partially posted journal entries. Partially posted journal entries are very rare and only occur when there are power or system problems during the posted process. Since the above utilities are powerful and can affect your database integrity, please consult with Escape Customer Care before using them. (For more information about SCANJE and SCANJDTL, please see the Finance Setup and Maintenance Guide, Troubleshooting section.)
Trial balance reports should be run on a regular basis while all users are out of the system. After system problems, it is important to run a trial balance while all users are out of Escape, to verify the integrity of the database. Please see the Batch Processing FYI for more information about running this report.