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

Problem with the copie SF data TO my DATABASE

Hello,
The copie of data from SF to SQL works for the 3 first table (AcceptedEventRelation/Account/AccountContactRole) , but after that, I have problem with the table (AccountHistory) .
This's my error if you have any idea to resolve it.
Thank you.

15:17:28: Opening SQL Server rowset [SQLSTATE 01000] (message 0)
15:19:26: 38912 rows copied. [SQLSTATE 01000] (message 0)
15:19:26: Drop Account if it exists. [SQLSTATE 01000] (message 0)
15:19:26: Rename previous table from Account_Previous to Account [SQLSTATE 01000] (message 0) Attention : changer une partie du nom de l'objet peut inhiber les scripts et les procédures stockées. [SQLSTATE 01000] (message 15477)
15:19:26: Create primary key on Account [SQLSTATE 01000] (message 0) --- Ending SF_Replicate. Operation successful. [SQLSTATE 01000] (message 0) --- Starting SF_Replicate for AccountContactRole [SQLSTATE 01000] (message 0)
15:19:27: Drop AccountContactRole_Previous if it exists. [SQLSTATE 01000] (message 0)
15:19:27: Create AccountContactRole_Previous with new structure. [SQLSTATE 01000] (message 0)
15:19:27: Run the DBAmp.exe program. [SQLSTATE 01000] (message 0)
15:19:27: DBAmp Bulk Operations. V3.3.1 (c) Copyright 2006-2016 forceAmp.com LLC [SQLSTATE 01000] (message 0)
15:19:27: Populating local table AccountContactRole_Previous , TC-MSSQL2-DZ2 / Salesforce Backups . [SQLSTATE 01000] (message 0)
15:19:27: DBAmp is using the SQL Native Client. [SQLSTATE 01000] (message 0)
15:19:27: Opening SQL Server rowset [SQLSTATE 01000] (message 0)
15:19:28: 0 rows copied. [SQLSTATE 01000] (message 0) 15:19:28: Drop AccountContactRole if it exists. [SQLSTATE 01000] (message 0)
15:19:28: Rename previous table from AccountContactRole_Previous to AccountContactRole [SQLSTATE 01000] (message 0) Attention : changer une partie du nom de l'objet peut inhiber les scripts et les procédures stockées. [SQLSTATE 01000] (message 15477)
15:19:28: Create primary key on AccountContactRole [SQLSTATE 01000] (message 0) --- Ending SF_Replicate. Operation successful. [SQLSTATE 01000] (message 0) --- Starting SF_Replicate for AccountHistory [SQLSTATE 01000] (message 0)
15:19:28: Drop AccountHistory_Previous if it exists. [SQLSTATE 01000] (message 0)
15:19:28: Create AccountHistory_Previous with new structure. [SQL... L'étape a échoué.
1 person has
this problem
+1
Reply