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

SF_Replicate fails to replicate _hd (Historical Trend) tables

SF_Refresh is working fine on the Historical Trend tables.

Error below:

--- Starting SF_Replicate for zqu__QuoteRatePlanCharge__c_hd V3.6.8
10:13:57: Parameters: glob zqu__QuoteRatePlanCharge__c_hd Version: V3.6.8
10:13:57: Drop zqu__QuoteRatePlanCharge__c_hd_Previous20181105T101357727 if it exists.
10:13:57: Create zqu__QuoteRatePlanCharge__c_hd_Previous20181105T101357727 with new structure.
10:13:57: DBAmpNet2 3.6.8.0 (c) Copyright 2015-2017 forceAmp.com LLC
10:13:57: Parameters: replicate zqu__QuoteRatePlanCharge__c_hd_Previous20181105T101357727 Glob glob
10:14:00: Error: System.InvalidOperationException: The given ColumnMapping does not match up with any column in the source or destination.
at System.Data.SqlClient.SqlBulkCopy.AnalyzeTargetAndCreateUpdateBulkCommand(BulkCopySimpleResultSet internalResults)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader)
at DBAmpNet2.Processor.Run()
10:14:00: 0 rows copied.
10:14:00: DBAmpNet2 Operation FAILED.
10:14:02: Error: Replicate program was unsuccessful.
10:14:02: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe Exportsoap "Replicate" "zqu__QuoteRatePlanCharge__c_hd_Previous20181105T101357727" "" "Glob" "glob"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 383
--- Ending SF_Replicate. Operation FAILED.
1 person has
this problem
+1
Reply