An error occurred with the pass-through SQL connection. Action: TableExists(RSES_Approval_Log_MSTR, DYNAMICS) of form Rockton_Helpers

Error:
When a user tries to access a window the following error message is being thrown.

An error occurred with the pass-through SQL connection. Action:TableExists(RSES_Approval_Log_MSTR, DYNAMICS) of form Rockton_Helpers

Resolution:

  1. Be sure that you have fresh backups created before going through any troubleshooting steps.
  2. Go to Microsoft Dynamics GP | Tools | Setup | Auditor | Auditor Setup.
  3. Click the Troubleshooting tab.
  4. Click Rebuild.
  5. Mark the following check-boxes.
    • Rebuild SQL Tables Master
    • Rebuild SQL Triggers
    • Rebuild SQL Scripts
  6. Mark Rebuild All Databases From Scratch
  7. Click Process.
  8. In the Auditor Setup window click the Setup Tab.
  9. Then click Install/Upgrade Auditor to go through the Install Wizard.

Related Content