Unexpected Invalid System Owner Checksum

Unexpected Invalid System Owner Checksum

PROBLEM

  • When Opening Gorilla you get an “Unexpected invalid system owner checksum”, or similar message.

CAUSE

This error generally occurs when something corrupts a part of the database.

IE: A failed Campaign import, or an interrupted upgrade.

SOLUTION

Running the Compact Utility on your database can sometimes correct this issue. In some cases, the ESP code has to be reentered and the database utilities may have to be run again afterwards. If that’s the case, run the database utilities and then open Gorilla.

There are other potential causes and fixes for this issue and are listed below.

  1. When the Database Fixer utility is interrupted.
    • To Fix: Run the Gorilla database fixer Utility again, this time without interruption.
  2. When the Compact Database utility is interrupted.
    • To Fix: Restore to the backup copy of the Database the utility created before it was interrupted.
  3. Windows is set to use a short date format that Gorilla cannot support, ie: yyyy/mm/dd
    • To Fix: Change the Windows short date format setting to be mm/dd/yyyy.
  4. Gorilla is set to open a non-Gorilla database file, IE: "B2ExportHelper.mdb"
    • To Fix: Redirect Gorilla to access the correct Gorilla database file.
  5. In some cases it has been noted that after importing a Campaign, this error will come up (so far noticed with Wilson Campaign).
    • To Fix: Run the Gorilla Database Fixer Utility.
  6. If a client was previously in a partnership which is dissolved and the permanent licenses are reduced.
    • To Fix: Run the Gorilla Database Fixer Utility.


    • Related Articles

    • How to Delete a System Owner

      QUESTIONS THAT APPLY TO THIS TOPIC How do I delete a System Owner for an advisor that is no longer with us? ANSWERIf you are changing one System Owner for another, you first need to make sure the new System Owner is added into the system. If you are ...

    • How to Add a System Owner

      QUESTIONS THAT APPLY TO THIS TOPIC The system owner's name is spelled wrong; how can I update that? We just purchased a new system owner, how can we get them added into Gorilla?  ANSWER In Gorilla, open Team Management by clicking on Tools, then Team ...

    • How to Change Which System Owner's Clients You See

      QUESTIONS THAT APPLY TO THIS TOPIC I have multiple System Owners in Gorilla, what if I only want to display one System Owner’s clients?  I cannot display all of the clients in Gorilla, how can I make sure that I see all of them?   ANSWER In Gorilla, ...

    • How To Fix Invalid Documents

      QUESTIONS THAT APPLY TO THIS TOPIC Why am I getting a warning that “The documents listed in the Gorilla   database do not match the actual document files on your system”?   How do I fix an invalid document? ANSWER This message is appearing because ...

    • Unexpected Record Deleted

      PROBLEM When Logging into Gorilla you get the message:  Program Error Intercepted "Unexpected Record Deleted". The above error has also been seen to come up when switching between screens in Gorilla, Example: Switching from the Finder screen into the ...