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

Error: RunQuery failed with com_error.

--- Starting SF_Replicate for SiteDetail V3.3.3
09:19:17: Parameters: SALESFORCE SiteDetail Version: V3.3.3
09:19:17: Drop SiteDetail_Previous if it exists.
09:19:17: Create SiteDetail_Previous with new structure.
09:19:17: Run the DBAmp.exe program.
09:19:18: DBAmp Bulk Operations. V3.3.3 (c) Copyright 2006-2016 forceAmp.com LLC
09:19:18: Populating local table SiteDetail_Previous , UTAXSQL / salesforce backups .
09:19:18: DBAmp is using the SQL Native Client.
09:19:18: Opening SQL Server rowset
09:19:18: Error: RunQuery failed with com_error.
09:19:18: MALFORMED_QUERY: SiteDetail: a filter on a reified column is required [DurableId]
09:19:18: Error: DBAmp.exe was unsuccessful.
09:19:18: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "SiteDetail_Previous" "LocalServerName" "DatabaseName" "LinkedServerName"
--- Ending SF_Replicate. Operation FAILED.
Error: SF_Replicate failed for table SiteDetail
Error 50000, Severity 16, State 1, Line 330
--- Ending SF_Replicate. Operation FAILED.

Getting the above error when executing:

exec sf_replicateall 'LinkedServerName'

This is ran as a SQL Server Agent job and only started throwing this error a few days ago.
1 person has
this problem
+1
Reply