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

MALFORMED_QUERY: Implementation restriction: FeedItem requires a filter by Id

We have the FeedItem object from SF being replicated for a while. But got the below error now on refresh for FeedItem table. verified that no access or schema changes to the object. Any thought on why the refresh failed? Thanks.

Msg 7320, Sev 16, State 2, Line 1 : Cannot execute the query "SELECT "Tbl1006"."BestCommentId" "Col1033","Tbl1006"."Body" "Col1034","Tbl1006"."CommentCount" "Col1035","Tbl1006"."CreatedById" "Col1036","Tbl1006"."CreatedDate" "Col1037","Tbl1006"."HasContent" "Col1038","Tbl1006"."HasLink" "Col1039","Tbl1006"."Id" "Col1040","Tbl1006"."InsertedById" "Col1041","Tbl1006"."IsDeleted" "Col1042","Tbl1006"."IsRichText" "Col1043","Tbl1006"."LastEditById" "Col1044","Tbl1006"."LastEditDate" "Col1045","Tbl1006"."LastModMsg 0, Sev 16, State 1, Line 46 : --- Starting SF_Refresh for FeedItem V3.2.1 [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 258 : 16:01:17: Using last run time of 2017-02-09 09:31:00 [SQLSTATE 01000]
Msg 7412, Sev 16, State 1, Line 1 : OLE DB provider "DBAmp.DBAmp" for linked server "SF_DB_LS" returned message "Error 1 : MALFORMED_QUERY: Implementation restriction: FeedItem requires a filter by Id". [SQLSTATE 01000]
1 person has
this question
+1
Reply