Help get this topic noticed by sharing it on Twitter, Facebook, or email.

sf_refresh works on some tables but not others

I get the following error when trying to refresh the recordtype table however other tables refresh ok, Any ideas why this might happen. I think it may be down to referential integrity and keys but would appreciate some guidance?

exec sf_refresh 'SALESFORCE', 'recordtype'

--- Starting SF_Refresh for recordtype
16:14:58: Using last run time of 2013-08-10 00:26:00
16:14:59: Indentified 31 updated/inserted rows.
OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" returned message "SFWinInet::Send::WinHttpReceiveResponse Server Error".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "Select Id from recordtype_Deleted where startdate='2013-08-10 00:26:00'" against OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".

Thakns
1 person has
this problem
+1
Reply