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.

Data Integration CData DBAmp
, , , ,
1

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”.

2

This error is related to an issue that our development team recently addressed. If you are running into this error, please reach out to dbampsupport@cdata.com for instructions on resolving this.