Overview

Users experience issues with the DBRecalc function after upgrading the iAvenue database to SQL Server 2012 and Windows 2016 and wonder if they should be using SQL Server Native Client 11.0 instead.

Resolution

ODBC Driver 11 is the standard driver associated with SQL Server 2012. When running DBRecalc from either DBAdmin or Update Center, these utilities look at UAdmin - Set Global SQL Data for the Global SQL ID. This ID should have full rights (Add/Read/Delete/Update) to all the Saratoga tables.

So if DBRecalc was run with an ID that did not have full access to delete rows after the records were successfully recalculated, it would make sense that DBRecalc would fail with the error: Cannot find the object "SSIDBRECALC" because it does not exist or you do not have permissions.

Adding those permissions manually to the SSIDBRECALC table would resolve that specific error, but other database errors might occur if the Global SQL ID in UAdmin does not have appropriate rights.