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

Replicate Failed for OauthToken table, can we exclude?

When I run SF_ReplicateAll, I get an error:

--- Starting SF_Replicate for OauthToken V3.5.8
09:51:59: Parameters: SALESFORCE OauthToken Version: V3.5.8
09:51:59: Drop OauthToken_Previous if it exists.
09:51:59: Create OauthToken_Previous with new structure.
09:51:59: DBAmpNet2 3.5.8.0 (c) Copyright 2015-2017 forceAmp.com LLC
09:51:59: Parameters: replicate OauthToken_Previous DEV-SQL-EDW01\DM01 salesforce backups SALESFORCE
09:52:07: 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:07: 0 rows copied.
09:52:07: DBAmpNet2 Operation FAILED.
09:52:07: Error: Replicate program was unsuccessful.
09:52:07: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe Exportsoap "Replicate" "OauthToken_Previous" "DEV-SQL-EDW01\DM01" "salesforce backups" "SALESFORCE"
--- Ending SF_Replicate. Operation FAILED.
Error: SF_Replicate failed for table OauthToken
Error 50000, Severity 16, State 1, Line 370
--- Ending SF_Replicate. Operation FAILED.

Is there anyway to exclude that table from the list when we run All?
1 person has
this question
+1
Reply