When running the Auditor Install/Upgrade process after upgrading Great Plains you receive the following error;
Cannot refind table. Contact support An error occurred with the pass-through SQL connection while dropping a trigger
This error is generated when a group contains SQL Table audits on tables or databases which no longer exist. During the install, it tries to rebuild all the SQL triggers and if the table or database doesn’t exist anymore it results in this error message.
If you only have a few Audit Groups defined look at all of the SQL Table audits to see if any of them no longer exist. If you find any you will want to delete them and then run the install process again.
If you have a number of Audit Groups you can run the reconcile process.
- Go to Microsoft Dynamics GP | Tools | Setup | Auditor | Auditor Setup.
- Click Reconcile.
- Mark SQL Database Table IDs.
- Mark Integrity check only.
- Click Process.
- Review the report and then follow the same steps except mark Remove Stranded Records in step 4.