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

SF_Replicate Error

Hi Bill and Team,

For the last week we have experiencing issues replicating an attachment table. We have restarted the SQL Server and ensured all properties were as expected. Error is:--- Starting SF_Replicate for Attachment V3.5.4
04:27:08: Parameters: MT_OLD_PROD Attachment Version: V3.5.4
04:27:08: Drop Attachment_Previous if it exists.
04:27:08: Create Attachment_Previous with new structure.
04:27:09: DBAmpNet2 3.5.4.0 (c) Copyright 2015-2017 forceAmp.com LLC
04:27:09: Parameters: replicate Attachment_Previous MT-SQL MT_OLD_Production MT_OLD_PROD
05:04:40: Error: System.Reflection.TargetInvocationException: An exception occurred during the operation, making the result invalid. Check InnerException for exception details. ---> System.InvalidOperationException: Response is not well-formed XML. --->
System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
at System.Xml.XmlReader.MoveToContent()
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.InvokeAsyncCallback(IAsyncResult result)
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at DBAmpNet2.SFDataLayer3.Read()
at System.Data.SqlClient.SqlBulkCopy.ReadFromRowSourceAsync(CancellationToken cts)
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()
05:04:40: 0 rows copied.
05:04:40: DBAmpNet2 Operation FAILED.
05:04:40: Error: Replicate program was unsuccessful.
05:04:40: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe Exportsoap "Replicate" "Attachment_Previous" "MT-SQL" "MT_OLD_Production" "MT_OLD_PROD"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 373
--- Ending SF_Replicate. Operation FAILED.

Thanks!
Eve
1 person has
this question
+1
Reply