Execu/Tech Systems, Inc.
Knowledgebase
Search:
850-747-0581EmailWebsite
Contents
 
IndexBookmarkPrint This Article

Home > Errors / Fixes > Rebuild Cross Reference

Rebuild Cross Reference

Cross Reference Files are used to reduce the server and network load when processing large amounts of data. Sometimes, these cross references get out of sync. If this has happened, you might notice that availability is out of sync, displayed names don't match the names of guests or information seems to be missing. One solution is to rebuild these Cross Reference Files.

Before running this utility, have all PMS users stop what they're doing and exit out of any guest folios or reservations. 
  1. This is done by running a utility named GANXREF. You run it by clicking File > Special > Run Program by Name



    If you're using the older 'Push Button' menu, where all menu items are displayed in a box in the center of the application, you use a different method to access the Program Name prompt.
    At the Master Menu, type the number 88 and then press Enter.  

  2.  After selecting this option you'll see a small window with a field to type a program name. This is where you type "GANXREF".



  3. After typing "GANXREF" in the field click OK. You'll be asked to select a printer and you should select the first one in the list. Nothing will be printed but you must select a printer to continue.



  4. After selecting the printer you'll see the Cross Reference Rebuild utility. To continue, you should get all other users out of the PMS software. If anyone remains in a guest folio, reservation, or is trying to do anything in the PMS software, either the rebuild or the other user could lock up. After verifying that all other users are out of the software, click Yes to the question "Are all HOTEL users out of the system?" Please note that this does not refer to you, because you are the one running the rebuild. This also doesn't apply to any Point of Sale or Execu/Suite Activities users.



  5. After clicking Yes, you will see a number of things moving on the screen. Sometimes it progresses too fast to see what it's doing, but as long as you see movement, it's running. If you have some very large databases, or large folios, it might seem to pause for several minutes while it's being processed. Your Night Auditor should be able to provide a reasonable estimate for the time it takes this utility to run, since it runs during the Night Audit Reorganize.

  6. At the end of the rebuild, you may see a window asking "Rebuild profile keys?"



    Click No unless Execu/Tech Support as instructed you to click Yes. This can be a lengthy and almost always unnecessary step. 

  7. You should see a window telling you "Cross Reference rebuild complete!" After click OK, you might be asked to log in, again.

  Check to see if this has solved your problem. If not, you should contact Execu/Tech Support for further instructions and troubleshooting. 

 





Article ID
 rebuild_cross_reference
Views
 1444
Last Modified
 11/21/2014 4:38 PM