Reserved Seating Integrity Check

In a distributed multi-user database environment such as the one Trak Pro operates in, there can be instances where under heavy network loads, or during equipment or server failures, your database may not be updated correctly. A workstation may fail to commit updates if Windows locks up, or your server might not post database changes promptly after signaling the POS workstation that everything was OK.

These events could lead to conditions where someone is occupying a reserved seat for one of your events, but has an incomplete transaction record of when and how the seat was purchased.

If you suspect you are having database networking issues, you can execute this diagnostic procedure, called the RESERVED SEATING INTEGRITY CHECK. This can be found in the DIAGNOSTICS Menu, if you are logged in as a user with Diagnostics rights.

This procedure does the following:

After selecting an Attraction, along with a specific Date and Time, the computer will scan all seat assignments and check:

Does the seat assignment have a valid customer associated with it?

Is there a VALID TICKET issued for the seat assignment?

Is there a corresponding transaction detail record for the seat assignment?

Do the totals for the Transaction add up for the seat assignment?

After you run an Integrity Check, you will be able to identify (and therefore pre-emptively respond to) any potential seating conflicts that might exist. In the example above, what you see is the result of a NORMAL Integrity Check. In other words, there are NO PROBLEMS.

Please bear in mind that you SHOULD NOT have problems of this sort under normal operational conditions. If you are consistently getting errors reported with either the Reserved Seating Integrity Check, or the Find Mis-Matched Transactions Check, then there are problems with either your network topology, server settings or SQL components that need to be addressed. This is intended as a diagnostic tool, and a remedy of last resort.

See Also:

Failed Internet Transactions
Finding Mis-Matched Transactions
Transaction Viewer
Transaction Searches