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

Cannot replicate table ActivityHistory or OpenActivity - tables never been replicated before. Other replication works fine...

Good Morning. I am having trouble replicating a new table into my salesforce sql server database.

The first call fails. it is a table we have never brought into salesforce before.
The second call succeeds. It is a table we have had in salesforce for a long time.

Please let me know what you can find out. Thanks! Bill.

exec SF_Replicate 'SALESFORCE' , 'ActivityHistory'

--- Starting SF_Replicate for ActivityHistory
12:46:12: Drop ActivityHistory_Previous if it exists.
12:46:12: Create ActivityHistory_Previous with new structure.
12:46:13: Run the DBAmp.exe program.
12:46:13: DBAmp Bulk Operations. V2.12.8 (c) Copyright 2006-2010 forceAmp.com LLC
12:46:13: Replicating into ActivityHistory_Previous , SQLPROD / SalesForceExtract .
12:46:13: Opening SQL Server rowset
12:46:14: Error: RunQuery failed with com_error.
12:46:14: SFWinInet::Send::WinHttpReceiveResponse Server Error
12:46:14: Error: DBAmp.exe was unsuccessful.
12:46:14: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export ActivityHistory_Previous "SQLPROD" "SalesForceExtract" "SALESFORCE"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 168
--- Ending SF_Replicate. Operation FAILED.

exec SF_Replicate 'SALESFORCE' , 'User'

--- Starting SF_Replicate for User
12:47:53: Drop User_Previous if it exists.
12:47:53: Create User_Previous with new structure.
12:47:53: Run the DBAmp.exe program.
12:47:53: DBAmp Bulk Operations. V2.12.8 (c) Copyright 2006-2010 forceAmp.com LLC
12:47:53: Replicating into User_Previous , SQLPROD / SalesForceExtract .
12:47:53: Opening SQL Server rowset
12:47:55: 208 rows copied.
12:47:56: Drop User if it exists.
12:47:56: Rename previous table from User_Previous to User
Caution: Changing any part of an object name could break scripts and stored procedures.
12:47:56: Recreate primary key if needed on User
--- Ending SF_Replicate. Operation successful.
1 person has
this problem
+1
Reply