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

SF_Replicate - Error: Replicate program was unsuccessful.

We are facing issue in DBAmp replicate. It was working till yesterday but suddenly start throwing following exception. Although It is still working fine on DEV environment. Please let us know the root cause of this issue.

-- Replicate Data
USE [LEAD_QA]
exec SF_Replicate 'LEAD_QA', 'Account'

************************************************************************************
--- Starting SF_Replicate for Account V3.7.1
23:37:37: Parameters: LEAD_STAGE Account Version: V3.7.1
23:37:37: Drop Account_Previous20190105T233737313 if it exists.
23:37:37: Create Account_Previous20190105T233737313 with new structure.
23:37:38: DBAmpNet2 3.7.1.0 (c) Copyright 2015-2017 forceAmp.com LLC
23:37:38: Parameters: replicate Account_Previous20190105T233737313 EC2AMAZ-KBMF4LT LEAD_STAGE LEAD_STAGE
23:41:19: Error: System.InvalidOperationException: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. ---> System.InvalidOperationException: String or binary data would be truncated.
at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed)
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed)
at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col)
at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
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.ReplicateSOAP.Run()
23:41:19: 0 rows copied.
23:41:19: DBAmpNet2 Operation FAILED.
23:41:20: Error: Replicate program was unsuccessful.
23:41:20: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe Exportsoap "Replicate" "Account_Previous20190105T233737313" "EC2AMAZ-KBMF4LT" "LEAD_STAGE" "LEAD_STAGE"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 383 [Batch Start Line 0]
--- Ending SF_Replicate. Operation FAILED.

************************************************************************************
1 person has
this problem
+1
Reply