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.

 

Related Content