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

Replication Error

I started having an issue with replication this week. I did the release upgrade on DBAmp and I am still having this issue. This one object is the only one failing.

--- Starting SF_Replicate for LoginHistory V3.4.9
09:52:21: Parameters: Veeva_CRM LoginHistory Version: V3.4.9
09:52:21: Drop LoginHistory_Previous if it exists.
09:52:21: Create LoginHistory_Previous with new structure.
09:52:22: DBAmpNet2 3.4.9.0 (c) Copyright 2015-2017 forceAmp.com LLC
09:52:22: Parameters: exportsoap LoginHistory_Previous ATLVMPLISTAGE\STAGE VEEVA_CRM Veeva_CRM
09:52:53: Error: System.NullReferenceException: Object reference not set to an instance of an object.
at DBAmpNet2.SFDataLayer3.IsDBNull(Int32 i)
at System.Data.SqlClient.SqlBulkCopy.GetValueFromSourceRow(Int32 destRowIndex, Boolean& isSqlType, Boolean& isDataFeed, Boolean& isNull)
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.Processor.Run()
09:52:53: 0 rows copied.
09:52:53: DBAmpNet2 Operation FAILED.
09:52:54: Error: Replicate program was unsuccessful.
09:52:54: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe Exportsoap "LoginHistory_Previous" "ATLVMPLISTAGE\STAGE" "VEEVA_CRM" "Veeva_CRM"
--- Ending SF_Replicate. Operation FAILED.
Error: SF_Replicate failed for table LoginHistory
Error 50000, Severity 16, State 1, Line 362
--- Ending SF_Replicate. Operation FAILED.

I have tried suggestions posted on here and nothing sees to resolve my issue.
1 person has
this problem
+1
Reply