Could Not Start Transaction - Too Many Transactions Already Nested

Could Not Start Transaction - Too Many Transactions Already Nested

PROBLEM

  • When attempting to add an action into Gorilla, you get the error message "could not start transaction, too many transactions already nested."

SOLUTION

  1. First, run the Database Fixer and Compact Database utilities.
    Database Fixer
    1. Make sure that everyone has closed out of Gorilla.
    2. If you haven’t done so already, make a backup of your database.
      • See the knowledge base article How to do a Backup in Gorilla 4.
    3. Click on Start>All Programs>BGM – Gorilla CRM System for Financial Services>Database Fixer.
    4. Verify the directories shown are the directories for your database and data.
      • You will notice some options below.
        • The “Fix Gorilla Database” and “Fix Playground Database” buttons will toggle between your regular database and the playground database.
        • The “Add Sample Contact Groups” checkbox will add several sample contact groups to the database. These are especially useful for sending test messages so you can make necessary adjustments before sending it to any clients.
    5. Click “Next” to continue.
    6. 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.
    7. Click “Close,” and the Database Fixer will close.

    Compact Database
    1. Click on Start>All Programs>BGM – Gorilla CRM System for Financial Services>Compact Database.
    2. This will open an instance of Gorilla and present two fields, one showing your database location, and another that will need to be filled in.

    3. Click on the three dot box to the right of the blank field.
    4. Choose where you want to store your backup that will be created during the compact process.
    5. Enter in a name for the backup in the File Name field and then click “Open.”

    6. Now click “OK” and your database will then start compacting. Once it has completed, you will be presented with a log in screen.

    • Related Articles

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

    • How to Create a Contact Group in Gorilla® 4.x

      QUESTIONS THAT APPLY TO THIS TOPIC How do I create a new Contact Group? How do I edit a Contact Group’s information? ANSWER Before you create a new Contact Group you need to first verify that they are not already in Gorilla. Open Gorilla and go to ...

    • Tech Talks - Worksheets and Scratchpad

      Creating Worksheets   Open the Define Worksheets screen by clicking on  Tools , then  Define Worksheets. Click on the arrow to the right of the “New” and select the type of worksheet you’d like to create.  There are 3 types of worksheets that you can ...

    • How to Set Up Google Alerts

      QUESTIONS THAT APPLY TO THIS TOPIC How can I get google to alert me on topics that I am interested in?   ANSWER Go to http://www.google.com/alerts Enter in a search query by typing in one or more keywords. Examples of keywords include your name, your ...

    • An Unexpected Unrecognized Database Format

      PROBLEM When opening a contact group within Gorilla, the following error comes up: “program error intercepted 'an unexpected unrecognized database format' \\gorilla server\c\database\b40.mdb. Error occurred in Gorilla CRM.” CAUSE This is caused by a ...