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

SF_Replicate Error: An error has occurred while fetching rows from salesforce.com

Hi,
Suddenly, we have the sync error on several environments, production, QA and DEV for both Refresh and Replicate jobs.
here is one error for replication:

Parameters: SALESFORCE custon_Table__c Version: V3.1.0
Drop custon_Table__c_Previous if it exists.
Create custon_Table__c_Previous with new structure.
Run the DBAmp.exe program.
DBAmp.exe: 14:36:18: DBAmp Bulk Operations. V3.1.0 (c) Copyright 2006-2015 forceAmp.com LLC
DBAmp.exe: 14:36:18: Populating local table custon_Table__c_Previous , CLESALLEXP01 / SF_Attend .
DBAmp.exe: 14:36:19: DBAmp is using the SQL Native Client.
DBAmp.exe: 14:36:19: Opening SQL Server rowset
DBAmp.exe: 14:48:11: Error: An error has occurred while fetching rows from salesforce.com.
DBAmp.exe: 14:48:11: Error: Replication failed.
DBAmp.exe: Source: ForceAmpAPI.SQueryResults4.1
DBAmp.exe: Description: CQueryResultSet::Next
DBAmp.exe: unclosed token at byte index 7131910
Drop custon_Table__c if it exists.
Rename previous table from custon_Table__c_Previous to custon_Table__c
Create primary key on custon_Table__c
Ending - Operation Successful.

Here is one error to refresh the local tables,
......
Parameters: SALESFORCE Opportunity Subset warn bulkapi Version: V3.1.0
Using Schema Error Action of subset
Using last run time of 2016-04-23 06:33:00
Run the DBAmp.exe program.
Error: DBAmp.exe was unsuccessful.
Error: Command string is \\networklocation\Salesforce\DBAmp\EXE\DBAmp.exe
Ending - Operation Failed.
...........
Parameters: SALESFORCE ADV_Opportunity_Contact_Role__c Subset warn bulkapi Version: V3.1.0
Using Schema Error Action of subset
Using last run time of 2016-04-23 12:00:00
Run the DBAmp.exe program.
DBAmp.exe: 16:30:05: DBAmp Bulk Operations. V3.1.0 (c) Copyright 2006-2015 forceAmp.com LLC
DBAmp.exe: 16:30:05: Populating local table ADV_Opportunity_Contact_Role__c_Delta2016-04-23T16:30:05.077 , CLEVITOSQL01\DMD01 / SFDC .
DBAmp.exe: 16:30:06: DBAmp is using the SQL Native Client.
DBAmp.exe: 16:30:06: Opening SQL Server rowset
DBAmp.exe: 16:30:06: Using the bulkapi with polling every 60 seconds.
DBAmp.exe: 16:30:06: Job Complete.
Identified 2 updated/inserted rows.
Identified 0 deleted rows.
Adding updated/inserted rows into ADV_Opportunity_Contact_Role__c
Ending - Operation Successful.
........
however, not all tables have the refresh problem.

can you help?

Thanks

Brian
1 person has
this problem
+1
Reply