I'm doing real-time replication between two SQL Server using Data Transmission Service (DTS) which provided by Alibaba Cloud. And after the full data migration completed, the task was suspended during incremental data migration.

Then I checked task details, it says:

"DTS task failed Region: Malaysia (Kuala Lumpur)

Task ID/Name: dts-task-id-string / dts-task-name

DTS-077100: Record Replicator error in table asyncprocess.outgoing bot. cause by [com.microsoft.sqlserver.jdbc.SQLServerException:Operationfailed.Theindexentryof length 1910 bytes for the index ' WA Sys 00000004 3D2915A8' exceeds the maximum length of 1700 bytes for nonclustered indexes.]

Also, I refer the related document as below, nothing found similar to my case. https://www.alibabacloud.com/blog/solving-the-dts-077100-error-during-data-synchronization_598444

CodePudding user response：

In this case, the structure of the table mentioned in the output may not meet the requirements. Check data schema, be sure the table has primary key or at least has a unique non-null index.

Reference: https://www.alibabacloud.com/help/doc-detail/34357.htm

All prerequisites for SQL Server incremental migration using DTS