If a file has been damaged and no longer has the correct record length, the MicroFocus to Sequential (MFTOSQ) Utility converts a data file to the correct record length and compresses the file so there are no deleted records in the file. This utility is normally run only when a reorg through FileMaint.exe had errors.
1. Make sure you have a good backup through Division 00, Division Maintenance, and that everyone is out of Fundware.
2. Look at the file in question in FileMaint.Exe and note the number of data records, and what is in the deleted rec and sys rec columns.
3. Log into Fundware verifying that 00 - System Administration appears in the drop down box, click OK.
4. Select System Administration -> System Utilities.
5. Enter the following in the Execute Program portion of the screen:
Program Name AFW800
Business Date Use default.
Division Select the appropriate division.
6. Hit enter at the blue screen. (you may need to minimize Fundware to see the resulting DOS screen).
7. The DOS prompt appears. It shows the location of the FundWare data directory (i.e.,\fundware\data)
8. Click on the black screen to make it active.
9. At the DOS prompt, type: del tp*.* (press enter)
10. Type: dir sye*.* (press enter) It should say "File not found." If a file is found, return to the System Utilities screen and hit the "Process Error log" button on the top right of the screen.
Contact FundWare Support to verify the error is not affecting the current process.
11. Type: dir *.sq (press enter). It should say "File not found." If a file or files are found with an old date, they can be deleted by typing del *.sq. If files are found with current dates, again contact FundWare Support.
For the following instruction we use 02CSD as an example. You will use your division number instead of "02" and the file you are correcting instead of "CSD".
12. Type: copy 02csd*.* 02csdold*.* (this is to make a copy of the file in case there are any problems in the mftosq.
13. Type: mftosq 02csd 02csd.sq tp1 (press enter).
You should get a good number of records that the system has written.(It should be equal or very close to the number of data records seen in Step 2.) You may see deleted and system records. If there are any system records, you must call FundWare support before proceeding if you are not already working with them. Any loss in the number of data records in a file indicates there will be missing records that will create problems. The file in question also affects the criticality of the issue.
The system records indicates bad records it has been unable to correct. Note the number of records written, sys records and deleted records. Sometimes the only way the file can be corrected will involve having system records, but in that case, your Support tech will need to guide you through further diagnostic programs for the module involved.
Note the number of records in each category on the screen to report to Support so it can be kept in Call History.
On the next step, you will have a better display screen if you exit the dos prompt (by typing: exit) and come back in. Without doing that you can't always see the input and output records correctly (the processing step doesn't display)
13. Type: afwrun nwsrbld1 (press enter)
You should see input and output for the same number that the mftosq step had as written.
If you do not, the rebuild is not working and a restore may be the only available option.
14. Type: dir *.sq (press enter). It should say "File not found".
If a file is found, the rebuild did not complete and FundWare Support needs to be contacted.
15. Type: exit (press enter, to return to menus)
16. Display the file in question again in FileMaint.Exe and note the number of data records, and what is in the deleted rec and sys rec columns.
If the number of data records does not match what you started with (or is over 10 records) there will be a problem and the original file pair should be copied back
Type: copy 02csdold*.* 02csd*.*
17. If there is ANY difference in the number of data records, diagnostics on the module will need to be run to determine next steps.