No one should be in FundWare when performing the procedures below.
Make sure you have a backup and read the full instructions below before proceeding.
If you are not familiar with using the dos prompt as below, please contact Support for assistance.
1. Use FileMaint.exe to find the ##ots file and see if there are any error messages on it (## represents your 2 digit division number).
2. If the ##ots file does not show any errors, then look at the division ##syp file. There is normally an error 8 on one of the files. The comments column state: Error reported from MicroFocus Rebuild
The most thorough file correction is done at the dos prompt in the Fundware\data directory by using an mftosq command with a forced record length.
The easiest way to get to the correct directory is to use System Utilities in Division 00.
Use Program Name: AFW800 Switches: Blank Parameters: AFW807. Use the default Business Date and select your division, the select Run.
This will take you to the command prompt.
After checking with the dir command that there are no *.sq or tp1 files in the Data folder (delete them if there are), you will run the mftosq commands.
The command to find the files is dir *.sq or dir tp1.
The command to delete them is del *.sq or del tp1. (be extremely careful with the delete command).
Make sure if you delete a .sq file that it does not have a current date on it. If any are there with current dates, it indicates something was unsuccessful with a prior utility run on a file. In that case, you should check with Support.
Before running an mftosq make sure you have made backup copies of the files involved (i.e. ##ots and ##ots.idx)
The command for the ots file is:
mftosq ##ots ##ots.sq tp1 /F158 (Note: If there are any significant records deleted. - if there were you probably need to copy back the original files from your backup).
After that step completes run:
The same command for the syp file is:
mftosq ##syp ##syp.sq tp1 /F512
When any build is complete, the tp1 file should be deleted.
If there are any *.sq files left, then the utility was not successful and Support assistance will be needed.
Note: The ##ots files are fairly static in that they hold the stages being used in AP. Often the file pair can be copied into the data directory from an earlier backup.
This is not true of the ##syp file which has constant changes to it.