Common Integrity Error Actions

How do I fix some of the integrity errors?
Is there a list of integrity errors?

If you need insight to better understand integrity errors, click here.

This is an incomplete list. If you need assistance in dealing with an integrity error, use the "Contact" link above to request that it be explained here.

For aID#12345 the order (0) number is INVALID. To correct, click the Payment action for this attendee.
This is one of the "easiest" to fix. Simply find this attendee in the basic attendee listing and in the far left action column click the "Payment" button. This will automatically fix the problem. This problem can occur for a variety of reasons. One of the most common is when an admin performs an action on this person's record prior to the attendeeing pulling up the "payment" page on their own.


Fund Entry (12345) Inv# 98765 was reset to be associated with room [4444] instead of (4443)
This is an internal note that requires no action. This is basically telling you that the fund ID for a particular room has been reassigned. Here's an example of how this can happen. An attendee reserves three rooms and guarantees all three with the same credit card. The card is "registered" with the first room. In the above case, room 4443. All three rooms reference the same fund ID line (12345) and the fund ID line records room 4443 as the associated reference.  But then at a later time the attendee comes back and cancels room 4443, the reference room. No problem there, but the integrity check goes out and checks that every fund ID is connected to a room but it can't find an active 4443 room. It then looks to see if there are other rooms still on this invoice connected to 12345 and finds 4444 as an active room still being guaranteed by that original credit card. So the system simply moves the reference ID from 4443 to 4444. If it can't do it cleanly, it just leaves it and then requires Tier 3 assistance to help, but that is rare.

Group Identifed by ____ containing (_) members does not have a Group Leader
This  is telling you that this family* group does not have a group leader assigned. The next line should contain the names and aID numbers of the members of this group. To fix this you need to identify which of these people should be designated as the group leader. It most likely is the lowest aID number but not always. If you don't have enough information, you can use the "Linked Registration Groups" view from the attendee listing to see if they are part of a "Linked Invoice" that has a designated leader already. If you can't identify who the group leader should be, may need to contact the group members to make an inquiry.

How to Fix: Once you know who you want to assign as the group leader, you simply EDIT that person's record and scroll down to the special "Admin" section at the bottom. It should show this person as a member of this leadersless group. If not, make them a member of the group and hit save.  Once you have them in the correct group, simply select the checkmark to make them the group leader and hit "submit" to save your changes.

*A "Family" group is different than a linked invoice group. We also have a longer description.

You have a fund Entry (____) Inv# _____ where the recorded room (____) does not match the connected hID [____].
This happens when the person makes a room reservation, reserves a second room but then cancels the first. This requires programming to fix but at this point it happens so rarely that it is easier to simply fix the error manually than do the complext programming work to fix it. If you get this message, please send an email to: support@cruglobal.freshdesk.com. You can forward the verification error you received or simply forward a message that says that you received a verification area. Be sure to state the site number. There is no charge for fixing this since it is a known programming problem. 

Tier 3 Notes:
 OPTION ONE
  1. From verification report note the Order Number & Fund ID.
  2. Go to house table and find all that match the listed order number.
  3. Select one that does not have a fund ID assigned and assign it the fund ID number. (most likely a cancelled room). Put the fundID into that field. Note the hID. 
  4. Go back to "fund" table and put that hID number in the f_valid field.
OPTION TWO
  1. On FUNDS table enter the fundID where error is showing.
  2. Grab the houseID that is showing in the f_valid field.
  3. Open HOUSE table search for that houseID
  4. See what fund ID is showing. If not a match, expand search to show all other rooms with that fund ID
  5. See if you can figure out issue and change to match.

    6. Run the integrity check again to insure all are done right.

    Next.