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

Error Refreshing Knowledge Table

I'm getting this error when trying to refresh a knowledge table that I previously replicated:

--- Starting SF_Refresh for Troubleshooting__kav V3.3.5
11:14:08: Using last run time of 2017-05-21 10:36:00
OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" returned message "Error 1 : MALFORMED_QUERY: Implementation restriction: When querying or searching the Troubleshooting__kav object, you must filter using the following syntax: Id = [single ID], Id IN [list of ID's] or PublishStatus = [status]. In addition PublishStatus is only permitted in a top-level AND condition.".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT "Tbl1005"."Approver__c" "Col1086","Tbl1005"."ArchivedById" "Col1087","Tbl1005"."ArchivedDate" "Col1088","Tbl1005"."ArticleCreatedDate" "Col1089","Tbl1005"."ArticleNumber" "Col1090","Tbl1005"."ArticleType" "Col1091","Tbl1005"."Attachment01__Body__s" "Col1092","Tbl1005"."Attachment01__ContentType__s" "Col1093","Tbl1005"."Attachment01__Length__s" "Col1094","Tbl1005"."Attachment01__Name__s" "Col1095","Tbl1005"."Attachment02__Body__s" "Col1096","Tbl1005"."Attachment02__ContentType__s" "Col1097","Tbl1005"."Attachment02__Length__s" "Col1098","Tbl1005"."Attachment02__Name__s" "Col1099","Tbl1005"."Attachment03__Body__s" "Col1100","Tbl1005"."Attachment03__ContentType__s" "Col1101","Tbl1005"."Attachment03__Length__s" "Col1102","Tbl1005"."Attachment03__Name__s" "Col1103","Tbl1005"."Attachment04__Body__s" "Col1104","Tbl1005"."Attachment04__ContentType__s" "Col1105","Tbl1005"."Attachment04__Length__s" "Col1106","Tbl1005"."Attachment04__Name__s" "Col1107","Tbl1005"."Attachment05__Body__s" "Col1108","Tbl1005"."Attachment05__ContentType__s" "Col1109","Tbl1005"."Attachment05__Length__s" "Col1110","Tbl1005"."Attachment05__Name__s" "Col1111","Tbl1005"."Attachment06__Body__s" "Col1112","Tbl1005"."Attachment06__ContentType__s" "Col1113","Tbl1005"."Attachment06__Length__s" "Col1114","Tbl1005"."Attachment06__Name__s" "Col1115","Tbl1005"."Attachment07__Body__s" "Col1116","Tbl1005"."Attachment07__ContentType__s" "Col1117","Tbl1005"."Attachment07__Length__s" "Col1118","Tbl1005"."Attachment07__Name__s" "Col1119","Tbl1005"."Attachment08__Body__s" "Col1120","Tbl1005"."Attachment08__ContentType__s" "Col1121","Tbl1005"."Attachment08__Length__s" "Col1122","Tbl1005"."Attachment08__Name__s" "Col1123","Tbl1005"."Attachment09__Body__s" "Col1124","Tbl1005"."Attachment09__ContentType__s" "Col1125","Tbl1005"."Attachment09__Length__s" "Col1126","Tbl1005"."Attachment09__Name__s" "Col1127","Tbl1005"."Attachment10__Body__s" "Col1128","Tbl1005"."Attachment10__ContentType__s" "Col1129","Tbl1005"."Attachment10__Length__s" ...
1 person has
this problem
+1
Reply