Tekoa SoftwareTEKOA

 software  

 Tekoa Software Home Page

 Home

|

 Tekoa Software News

 News

|

Tekoa Software Support

 Support

|

 Tekoa Software Login

 Sign In

Tekoa Software Home 

Tekoa Software Development and Dedicated Server Hosting. 

 
Customer Service 

Contact Customer Service if you need more help. 

 
Sage MAS 90 200 Application Host 

Secure Application Hosting for Sage MAS 90 200 for todays enterprise. Get more from the software you already own. 

 
 
Sage MAS 200 Cloud Computing

Web Services, Tekoa MAS Web Browser, Customer Portal, Essential Technical Support...

All part of Tekoa's Cloud Computing Solution for MAS90 and MAS200.  Technology for today's web enabled enterprise.
MAS 90 200 Support
MAS 90 200 Paperless Office Email that Works!
 More Information...

Tekoa Software Knowledgebase Tekoa Software Knowledgebase 

Find answers to your technical support questions using our knowledgebase.

Using the seach below, enter keywords related to your technical support question. We will search our support database and find support articles related to your inquiry.

 
 
Title

Rebuilding key files in MAS 90 and MAS 200 
ID 0000000032 
Subtitle For Library Master 3.71 and above 
Description For MAS 90 or MAS 200 
Text Use caution when working with this task. ALWAYS MAKE A BACKUP FIRST.

If you are unfamiliar with doing this, make sure you contact an experienced MAS 90 or MAS 200 consultant for assistance. Performing this task incorrectly can seriously corrupt your MAS 90 or MAS 200 system!

Use Rebuild Key Files to rebuild direct or multi-keyed files. This utility removes all records that contain character values outside of the standard alphanumeric character set and completely rebuilds the data file directory. The directory is rebuilt using the information contained in the individual data records. 
 
Resolution FOR MAS 90 OR MAS 200 VERSION 4.0 AND LATER:
1. Expand "Modules", "Library Master" and "Utilities". Double-click on 'Rebuild Key Files'.

2. A warning message appears; click 'OK' only if you are familiar with this utility. Click 'Cancel' if you are unfamiliar with this utility, and contact an experienced MAS 90 or MAS 200 consultant for help.

3. At the "Rebuild Application Key Files" window, select the applicable company code and module.

4. Select the 'Rebuild' check box for the files that must be rebuilt. Click the 'Select All' button to rebuild all files.

5. Select the 'Scan Files' check box to return the number of records that will be recovered before rebuilding the files. Scanning the files is not required, BUT IS HIGHLY RECOMMENDED.

6. Choose the 'Optimize File' check box to rewrite the existing file to a new file with the following updates:
a. Excess data blocks are removed,
b. The primary keys are arranged in alpha-numeric order.

7. The 'Save Original File' check box is automatically selected for you. Using this feature is highly recommended. A backup file with the extension .old is created in the current data location (e.g., ...\Mas90\Mas_abc\Apabc\Ap1abc.old).

8. Click 'Proceed'.

9. If the 'Scan Files' check box was selected, the 'Scanning (Module and file description)' window shows the number of records to be recovered. After the scan, a message prompts you to proceed.
a. If most or all of the records will be recovered, click 'Yes'.
b. If a large number of records will be lost, click 'No' and seek assistance to determine why so many records are damaged. There may be something else wrong in the system to have caused this condition. Take no chances unless you are sure!

10. On the "Rebuild Key Files Error Log" window, click 'Print' or 'Preview'. The error log provides detailed information about the files that were repaired, including information about records that were removed. IMPORTANT: Printing the error log is not required, but is highly recommended. The log cannot be reprinted and is useful if the lost records must be re-created!

11. When the "Rebuild Application Key Files" window again appears, click 'Cancel' to close the window.


FOR MAS 90 AND MAS 200 VERSIONS 3.71 AND EARLIER:
1. Expand "Library Master" and "Repair". Double-click 'Rebuild Application Key Files'. IMPORTANT: IF "REBUILD KEY FILES REQUIRES SUPERVISOR RIGHTS" APPEARS, THE USER DOES NOT HAVE SUPERVISOR PERMISSIONS. LOG ON TO MAS 90 OR MAS 200 WITH A USER ID THAT HAS SUPERVISOR RIGHTS!

2. A warning message appears; click 'OK' only if you are familiar with this utility. Click 'Cancel' if you are not and contact an experienced MAS 90 or 200 business partner.

3. When the "Rebuild Application Key Files" window appears, select the applicable company code and module. The list of the key files for that company will appear.

4. Click on the files to be rebuilt and then choose the 'Select' button. 'YES' relaces 'No' in the "Rebuild" column. You can also click on the 'All' button if all files are needing rebuilding.

5. After you confirm that all appropriate files are selected, click on 'Proceed'.

6. "Do you want to scan files first" now appears. IMPORTANT: Scanning the files is not required but is highly recommended!
Click 'Yes' to scan the records before rebuilding. The number of records that will be recovered out of the number of records scanned displays with an option to continue.
a. If most of the records wil lbe recovered, click 'Yes'.
b. If a large number of records will be lost, click 'No' and seek the assistance of an experienced MAS 90 or 200 support partner. There could be an underlying reason why there are so many that will not be recovered.
Click 'No' to rebuild the files without scanning.

7. "Do you want to save original files?" appears. IMPORTANT: SAVING THE CILES IS NOT REQUIRED, BUT IS HIGHLY RECOMMENDED!
a. Click 'Yes'. A copy of the original file will be saved on the data folder with a .old extension, e.g., ...\Mas90\Apabc\Ap1abc.old.
b. Click 'No' to proceed without creating a copy of the original file.

8. "Do you want to print the Error Log?" appears when the rebuild completes. The error log provides detailed information about the files that were repaired, including information about records that were removed. IMPORTANT: Printing the error log is not required, but is highly recommended. The log cannot be reprinted and is useful if the lost records must be re-created!

9. When the "Rebuild Application Key Files" window again appears, click 'Cancel' to close the window.


FOR MAS 200 - SQL EDITION
IMPORTANT: KEY FILES CANNOT BE REBUILT ON SQL VERSIONS. AS A WORKAROUND, RUN DBCC MAINTENANCE ON THE SQL DATABASE AND TABLES ONCE EACH WEEK BY:
a. Start SQL Query Analyzer
b. Type 'DBCC'
c. Highlight the text above and press 'Shift+F1'.
 
Related Link 1 http://www.tekoasoftware.com/Support 
Related Link 2  
 Sage MAS Knowledgebase Search
Clear

Sage MAS 90 MAS 200 Knowledgebase Articles 
Kb Title Kb ID Category Type
Barcode Printing Crystal Reports Sage MAS 90 200 

0000000003 

 Sage MAS 90 200 Technical Support  Technical Support 
Downloading, Installing and Updating Tax Tables 

0000000031 

 Sage MAS 90 200 Technical Support  How To Instructions 
What if I forget my password? 

0000000002 

 Frequently Asked Questions  General Information 
Printer using ports not COM, LPT or USB 

0000000059 

 Sage MAS 90 200 Technical Support  Technical Support 
PVXWIN32.EXE - DLL Initialization Failed 

0000000013 

 Sage MAS 90 200 Technical Support  Technical Support 
MAS 90 200 Q1 2009 Tax Table Update 

0000000039 

 Frequently Asked Questions  How To Instructions 
How To Use Item Alias Codes in MAS 90 200 

0000000010 

 Sage MAS 90 200 Technical Support  How To Instructions 
MAS 90 200 Paperless Office Email Errors 

0000000044 

 Sage MAS 90 200 Technical Support  Technical Support 
Can I Export MAS 90 200 Reports to Excel or Word? 

0000000011 

 Frequently Asked Questions  How To Instructions 
Reversing a Credit Card Payment in MAS 90 or 200 

0000000026 

 Sage MAS 90 200 Technical Support  Technical Support 
Rebuilding key files in MAS 90 and MAS 200 

0000000032 

 Sage MAS 90 200 Technical Support  Technical Support 
Invoice Already Being Paid of Balance Exceeded 

0000000034 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 11 POWUZA 3330 when Rebuilding Sort Files 

0000000006 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 11 POSUZA 3330 

0000000020 

 Sage MAS 90 200 Technical Support  Technical Support 
Crystal Reports Export To Text Do Not Prompt 

0000000025 

 Sage MAS 90 200 Technical Support  How To Instructions 
Moving MAS 90 or MAS 200 to a new location 

0000000022 

 Sage MAS 90 200 Technical Support  Technical Support 
Runtime DLL Files for Special Formulas 

0000000023 

 Sage MAS 90 200 Technical Support  General Information 
How to register .DLL and .OCX files 

0000000057 

 Sage MAS 90 200 Technical Support  How To Instructions 
Creating a one-sided journal entry 

0000000028 

 Sage MAS 90 200 Technical Support  Technical Support 
Installing Workstation Setup for MAS 90 & 200 

0000000027 

 Sage MAS 90 200 Technical Support  Technical Support 
TCP/IP Connection Failure in MAS 200 

0000000014 

 Network Support  Technical Support 
MAS 90 MAS 200 2009 Payroll 941 Program Update 

0000000045 

 Sage MAS 90 200 Technical Support  Technical Support 
Setting Default Printers in MAS 90 & 200 

0000000040 

 Sage MAS 90 200 Technical Support  Technical Support 
Setting a Default Device Configurator Printer 

0000000046 

 Sage MAS 90 200 Technical Support  How To Instructions 
Microsoft IIS Loses MAS 90 200 ODBC Connection. 

0000000041 

 Sage MAS 90 200 Technical Support  Technical Support 
How to Back Up and Restore Data Files 

0000000030 

 Sage MAS 90 200 Technical Support  Technical Support 
"A goods receipt is currently referencing this PO" 

0000000055 

 Sage MAS 90 200 Technical Support  Technical Support 
A goods receipt is currently referencing this PO 

0000000015 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 88 SY_ReportEngine.pvc 1127  

0000000051 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 88 SY_ReportEngine.pvc 1535 when printing 

0000000052 

 Sage MAS 90 200 Technical Support  Technical Support 
Add the ability to edit/revise menus in MAS90/200 

0000000019 

 Sage MAS 90 200 Technical Support  General Information 
Installing Service Packs, Updates or Program fixes 

0000000029 

 Sage MAS 90 200 Technical Support  Technical Support 
Displaying Data File Records with the DFDM Utility 

0000000035 

 Sage MAS 90 200 Technical Support  Technical Support 
Modifying Records using the DFDM Utility 

0000000036 

 Sage MAS 90 200 Technical Support  Technical Support 
Deleting Records Using the DFDM Utility 

0000000037 

 Sage MAS 90 200 Technical Support  Technical Support 
Sage MAS 90 200 Payroll Tips on W-2 Are Incorrect 

0000000005 

 Sage MAS 90 200 Technical Support  Technical Support 
Error: "(CheckOFSIConnection) 8900: 

0000000042 

 Sage MAS 90 200 Technical Support  Technical Support 
Finance Charges Not Calculated  

0000000024 

 Sage MAS 90 200 Technical Support  Technical Support 
Reports Default to Wrong Printer in Crystal Report 

0000000047 

 Sage MAS 90 200 Technical Support  Technical Support 
The object SO_SalesOrder_UI does not exist 

0000000017 

 Sage MAS 90 200 Technical Support  Technical Support 
Install or Uninstall PDF Converter 

0000000058 

 Sage MAS 90 200 Technical Support  How To Instructions 
Object ProvideX.Script was invalid 

0000000021 

 Sage MAS 90 200 Technical Support  Technical Support 
Connection failure to host 

0000000012 

 Network Support  Technical Support 
Financial Reports Defaulting to Incorrect Printer 

0000000048 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 13 SO_PurgeSalesHistory.pvc Line 140 

0000000004 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 65 CI_Audit Tracking.pvc 132 

0000000016 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 71 SO_SALESORDER_UI.PVC 515 

0000000018 

 Sage MAS 90 200 Technical Support  Technical Support 
"Data is not selected for report printing" in RMA  

0000000049 

 Sage MAS 90 200 Technical Support  Technical Support 
Default RMA date is retained in RMA Entry  

0000000053 

 Sage MAS 90 200 Technical Support  Technical Support 
Credit Memos Posting to Incorrect Warehouse 

0000000038 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 88 Sy_ReportEngine.pvc 702 when printing  

0000000050 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 12 SY_PDF Converter.pvc 369 

0000000056 

 Sage MAS 90 200 Technical Support  Technical Support 
Residential address check box is cleared on SO's 

0000000054 

 Sage MAS 90 200 Technical Support  Technical Support 
Cannot connect to database for pages w/ MAS data 

0000000007 

 Tekoa ERP Software Support  Technical Support 
FireBox VPN instability from remote office to Host 

0000000008 

 Network Support  Technical Support 
Grids with multiple tables pass blank variables. 

0000000009 

 Tekoa ERP Software Support  Technical Support 
FRX: Run-Time Error -2147220503 

0000000043 

 All Categories  Technical Support 
 

 Tekoa Software, Inc.  All Rights Reserved. General: 509-340-3580       Support: 509-340-3733     Contact Us

www.TekoaSoftware.com 
 software for today's web enabled enterprise  Web Software Development  |  Web Design  |  eBusiness Solutions  | Web Enterprise  |  Business Management Software

  Tekoa Software Blog