We’ve recently upgraded to the latest version of dbamp. Since doing so we are constantly seeing the following error on one of sf objects when we bring it down to SQL via the “exec sf_refresh” command.
Executing the query "DECLARE @IncludeArchiveDeleted BIT, @Table VARCHA..." failed with the following error: "Cannot fetch a row from OLE DB provider "MSOLEDBSQL" for linked server "SalesForce_ls".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
We only get this error on this one particular object. Task is probably the largest object in salesforce whose data we bring down locally to our SQL environment. Any help would be very much appreciated. Thanks and have a great day.
Running DBAMP 22.0.8991.0 version
