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

SF_Refresh failed for table Task

Hi,
We are getting an error during the refresh process on the Task table. This was working fine until a few backs back when we started seeing this error:

--- Starting SF_Refresh for Task
06:26:06: Using Schema Error Action of yes
06:26:06: Using last run time of 2014-10-22 04:07:00
OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" returned
message "Error 5103 : FAHttp::Send::WinHttpReceiveResponse
Win32Error::
The server returned an invalid or unrecognized response
".
Error: SF_Refresh failed for table Task
Error 7320, Severity 16, State 2, Line 1
Cannot execute the query "SELECT "Tbl1006"."AccountId"
"Col1115","Tbl1006"."Acct_Mngmt_Task_Purpose__c"
"Col1116","Tbl1006"."Activity_Location__c"
"Col1117","Tbl1006"."Activity_Owners_Manager__c"
"Col1118","Tbl1006"."ActivityDate"
"Col1119","Tbl1006"."Approver_One__c"
"Col1120","Tbl1006"."Approver_One_Name__c"
"Col1121","Tbl1006"."Approver_Two__c"
"Col1122","Tbl1006"."Approver_Two_Name__c"
"Col1123","Tbl1006"."Assign_to_UW_Lead__c"
"Col1124","Tbl1006"."Assigned_To_First_Name__c"
"Col1125","Tbl1006"."Audience__c"
"Col1126","Tbl1006"."Call_Outcome__c"
"Col1127","Tbl1006"."CallDisposition"
"Col1128","Tbl1006"."CallDurationInSeconds"
"Col1129","Tbl1006"."CallObject" "Col1130","Tbl1006"."CallType"
"Col1131","Tbl1006"."Child_Agency__c"
"Col1132","Tbl1006"."Communication_Method__c"
"Col1133","Tbl1006"."Create_Date_Time__c"
"Col1134","Tbl1006"."Created_By_User_Plan__c"
"Col1135","Tbl1006"."CreatedById" "Col1136","Tbl1006"."CreatedDate"
"Col1137","Tbl1006"."Date_of_Engagement__c"
"Col1138","Tbl1006"."Days_btwn_Ltr_Sent_Ltr_Recd__c"
"Col1139","Tbl1006"."Dental__c" "Col1140","Tbl1006"."Description"
"Col1141","Tbl1006"."Duration__c"
"Col1142","Tbl1006"."Engage_Category__c"
"Col1143","Tbl1006"."Engage_Engagement_Outcome__c"
"Col1144","Tbl1006"."Engage_HCC_addressed__c"
"Col1145","Tbl1006"."Engage_Perceived_Call_Value__c"
"Col1146","Tbl1006"."Engage_Referred_To__c"
"Col1147","Tbl1006"."Engage_Representative__c"
"Col1148","Tbl1006"."Enrolled_Date__c"
"Col1149","Tbl1006"."First_Approval_Date__c"
"Col1150","Tbl1006"."Follow_up_Next_steps__c"
"Col1151","Tbl1006"."Follow_Up_Next_Steps_del__c"
"Col1152","Tbl1006"."Former_Call_Outcome_Regence__c"
"Col1153","Tbl1006"."Group_Name__c"
"Col1154","Tbl1006"."Group_Task_Details__c"
"Col1155","Tbl1006"."Group_Task_Purpose__c"
"Col1156","Tbl1006"."Hours_Expended__c" "Col1157","Tbl1006"."Id"
"Col1158","Tbl1006"."Internal_Link__c"
"Col1159","Tbl1006"."IsArchived" "Col1160","Tbl1006"."IsClosed"
"Col1161","Tbl1006"."IsDeleted" "Col1162","Tbl1006"."IsRecurrence"
"Col1163","Tbl1006"."IsReminder...

Any help is appreciated.
1 person has
this question
+1
Reply