Unexpected the Search Key was not Found

Unexpected the Search Key was not Found

PROBLEM

  • When trying to add an action into Gorilla, you get the pop up message: Program error intercepted ‘an unexpected the search key was not found in any record’.

CAUSE

There are potentially a few causes for this issue:

  • The Actions table in the database could be missing the primary key
  • Or there is a damaged Action that needs to be repaired through the backend.

SOLUTION

Have everyone close out of Gorilla, then run the Gorilla database Fixer utility.

  1. If you haven’t done so already, make a backup of your database.
  2. Click on Start>All Programs>BGM – Gorilla CRM System for Financial Services>Database Fixer.
  3. The Fix Gorilla Database and Fix Playground Database below the directory lines toggle between which directories you want to fix.
    • The Add Sample Contact Groups checkbox will add several contact groups to the database. They are good for testing purposes.
  4. Click Next to continue.
  5. Click Finish and the database fixer will then proceed through its process, and display the results. You have the option to save and to print from this screen, as well.
  6. Click close, and the Database Fixer will close.

If this does not resolve the issue. Please call Software Support at 801-553-9888 for further assistance with this.


​

    • Related Articles

    • An unexpected item not found in this collection

      PROBLEM Program Error Intercepted. An unexpected 'item not found in this collection' error occurred in GorillaCRM. SOLUTION Have everyone exit out of Gorilla and restart the server. If the problem still persists, send the Database in for repair. Call ...

    • This Key is already Associated with an Element of this Collection

      PROBLEM When running the Action To-Do report in Gorilla you get the message: "An Unexpected 'this key is already associated with an element of this collection' error occurred in GorillaCRM." CAUSE This is caused if the due action is associated ...

    • Unexpected Automation Error Object Invoked has Disconnected from its Clients

      PROBLEM When trying to print, you get the error "unexpected automation error object invoked has disconnected from its clients." CAUSE This happens when the vsprint7.ocx file gets updated to a version that Gorilla cannot work with. SOLUTION You will ...

    • Error Deleting Virtualized Key

      PROBLEM When upgrading Gorilla from 4.0 to 4.3 on Windows 64bit, you get an "error deleting virtualized key: -1" message. CAUSE We believe this happens during the database upgrade step in the Gorilla installation due to the version of Windows being ...

    • 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 ...