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

Replication AccountHistory failed

Hi,
When I run this query I get this error.

select 'ActivityHistory', * from SALESFORCE_QA1...ActivityHistory;

OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE_QA1" returned message "entity type ActivityHistory does not support query".
Msg 7320, Level 16, State 2, Line 2
Cannot execute the query "SELECT "Tbl1002"."Account_Name__c" "Col1005","Tbl1002"."AccountId" "Col1006","Tbl1002"."ActivityDate" "Col1007","Tbl1002"."ActivityType" "Col1008","Tbl1002"."CallDisposition" "Col1009","Tbl1002"."CallDurationInSeconds" "Col1010","Tbl1002"."CallObject" "Col1011","Tbl1002"."CallType" "Col1012","Tbl1002"."Created_By_Name__c" "Col1013","Tbl1002"."CreatedById" "Col1014","Tbl1002"."CreatedDate" "Col1015","Tbl1002"."CTS_Task_Resolution__c" "Col1016","Tbl1002"."DB_Activity_Type__c" "Col1017","Tbl1002"."Description" "Col1018","Tbl1002"."DurationInMinutes" "Col1019","Tbl1002"."Id" "Col1020","Tbl1002"."IsAllDayEvent" "Col1021","Tbl1002"."IsClosed" "Col1022","Tbl1002"."IsDeleted" "Col1023","Tbl1002"."IsReminderSet" "Col1024","Tbl1002"."IsTask" "Col1025","Tbl1002"."LastModifiedById" "Col1026","Tbl1002"."LastModifiedDate" "Col1027","Tbl1002"."Location" "Col1028","Tbl1002"."Meeting_Summary__c" "Col1029","Tbl1002"."MS_CRM_Legacy_ID__c" "Col1030","Tbl1002"."OwnerId" "Col1031","Tbl1002"."Priority" "Col1032","Tbl1002"."ReminderDateTime" "Col1033","Tbl1002"."Status" "Col1034","Tbl1002"."Subject" "Col1035","Tbl1002"."SystemModstamp" "Col1036","Tbl1002"."Web_Live__c" "Col1037","Tbl1002"."WhatId" "Col1038","Tbl1002"."WhoId" "Col1039",'ActivityHistory' "Expr1003" FROM "ActivityHistory" "Tbl1002"" against OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE_QA1".
1 person has
this question
+1
Reply