Error: An error occurred with the pass-through SQL connection. Action: TableExists of form Rockton_Helpers

Error:
You receive the following message in Dynamics GP.

An error occurred with the pass-through SQL connection. Action: TableExists of form Rockton_Helpers

Cause:
The following are potential causes of this error:

    • A table(s) and/or database(s) where you have SQL Table Audits defined was deleted.
    • A table(s) and/or database(s) where you have SQL Table Audits defined was restored.

Resolution:

  1. Have everyone log out of the system and make a complete restorable backup.
  2. Go to Microsoft Dynamics GP | Tools | Setup | Auditor | Auditor Setup.
  3. In the Auditor Setup window, click on the Troubleshooting tab.
  4. Click Rebuild.
  5. In the Auditor Rebuild window, mark the following:
    • Rebuild SQL Tables Master
    • Rebuild SQL Triggers
    • Rebuild SQL Scripts
    • Rebuild All Databases From Scratch
  6. Click Process.
  7. In the Auditor Setup window, click on the Setup Tab.
  8. Perform the Welcome to the Installation Wizard for Auditor.