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

first error in 2019 - urgent

after the 5th of january, i get this on some of my objects (only sandbox, and newest version of DBAmp, and clean database)

--- Starting SF_Replicate for contact V3.7.2
13:46:29: Parameters: SALESFORCE contact Version: V3.7.2
13:46:29: Drop contact_Previous20190108T134629700 if it exists.
13:46:29: Create contact_Previous20190108T134629700 with new structure.
13:46:30: DBAmpNet2 3.7.2.0 (c) Copyright 2015-2017 forceAmp.com LLC
13:46:30: Parameters: replicate contact_Previous20190108T134629700 DKLT-DDO-04 salesforce backups SALESFORCE
13:47:46: 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()
13:47:46: 0 rows copied.
13:47:46: DBAmpNet2 Operation FAILED.
13:47:48: Error: Replicate program was unsuccessful.
13:47:48: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe Exportsoap "Replicate" "contact_Previous20190108T134629700" "DKLT-DDO-04" "salesforce backups" "SALESFORCE"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure sf_replicate, Line 383 [Batch Start Line 19]
--- Ending SF_Replicate. Operation FAILED.
1 person has
this problem
+1
Reply