couple issue. just upgraded to latest version dbamp. Getting unspecified error when trying to bring dow 6k records from application object in salesforce using the linked server directly.

i get error when trying to pull down application data that changed in last 4 days. I’m querying the linked server directly like this . it seems like i’m hitting some threshold and when it’s over a certain amount it gives me this error. this didnt happen in my old dbamp version. ideas onf ix?

                select *

                --  select count(*)

FROM [MATCHFORCE].[CData].[Salesforce].[Application__c_QueryAll]

WHERE [LastModifiedDate] <   dateadd(second,-1,(dateadd(day, datediff(day, 2, getdate()),0)))

                AND [LastModifiedDate] > dateadd(second,-1,(dateadd(day, datediff(day, 3, getdate()),0)))

error:

OLE DB provider "MSOLEDBSQL" for linked server "MATCHFORCE" returned message "Unspecified error".

Msg 7330, Level 16, State 2, Line 162

Cannot fetch a row from OLE DB provider "MSOLEDBSQL" for linked server "MATCHFORCE".