Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Data-Level Comparison/ Data-Level Comparison Error: service SDV failed! cause by: the size of records in one shard[ *** ] of target database, exceeds the max size 200000
Updated on 2024-09-25 GMT+08:00

Data-Level Comparison Error: service SDV failed! cause by: the size of records in one shard[ *** ] of target database, exceeds the max size 200000

Scenarios

During a value comparison task, an error is reported, and the log information is as follows: service SDV failed! cause by: the size of records in one shard[ ***.*** ] of target database, exceeds the max size 200000

Figure 1 Comparison failed

Possible Causes

The data model of the table to be compared is special. As a result, automated sharding cannot be performed for the comparison task, and the task fails.

Solution

Create a value comparison task again and deselect the table for which the error is reported.

  1. Click the task name. The Basic Information page is displayed.
  2. Take a synchronization task as an example. Choose Synchronization Comparison.
  3. Click the Data-Level Comparison tab and click Create Comparison Task.
  4. Deselect the table where the error is reported and click OK to submit the comparison task again.
  5. If the fault persists, choose Service Tickets > Create Service Ticket in the upper right corner of the management console and contact DRS customer service.