This topic describes how to view and modify the validation objects of a configured data validation task.
Background information
OceanBase Migration Service allows you to change the validation objects of a data validation task. Each modification made during the running of the task is recorded.
After you change the validation objects, the data validation task updates the allowlist, the blocklist, and the validation object list based on the new objects. However, the status of the data validation task remains unchanged. The changes take effect only when you manually start or resume the task.
Limitations
When you perform data validation from a PostgreSQL database to OceanBase Database (in MySQL or Oracle compatible mode), you can modify the validation objects of a data validation task created by using the Match by Rule method.
You can modify the validation objects of a data validation task in the Not Started, Running, Stopped, Failed, or Completed state.
View the validation objects
Log in to the OMS console.
In the left-side navigation pane, click Data Validation.
On the Data Validation page, click the name of the target task to go to the details page of the task.
Click View Objects in the upper-right corner to view Specify Objects and Modification History.
The Specify Objects tab displays the validation objects of the current task. You can also perform the Add Objects and Remove Objects operations.
The Modification History tab displays the modification time and status of all object modification operations.
Modify validation objects selected by the specifying objects method
Add validation objects
On the details page of the target task, click View Objects in the upper-right corner.
In the View Objects > Specify Objects section, click Add Objects in the upper-right corner.
In the Add Objects dialog box, select the validation objects in the left Source Object(s) section and click > to add them to the right list. You can select one or more tables from a database as the validation objects.
After you select the validation objects to add, you can rename the objects, configure row filters, and select columns.
Notice
By default, the added objects inherit all configuration options of the original data validation task. If you stop the operation during the object addition process, you need to manually delete the added objects from the target database.
If the source data source is configured with a schema name or database name, you can add validation objects only in the schema or database specified by the name.
After you select the validation objects, click Next.
The system automatically performs a precheck on the added objects. If all check tasks pass, click Save.
Confirm the information and click OK in the dialog box that appears.
- If the task is in the stopped or failed state, you can cancel the task and make the modifications again. After you make the modifications, you need to resume the data validation task before you can add validation objects.
- If the task is in the running state, the validation objects will be immediately added after you click Save.
Reduce validation objects
On the details page of the target, click View Objects in the upper-right corner.
In the View Objects > Specify Objects section, click Remove Objects in the upper-right corner.
In the Target Object(s) list on the right side of the Remove Objects page, hover over the target object and click Remove to add it to the left-side list.
After you select the objects, click Remove in the lower-right corner of the dialog box.
In the confirmation dialog box that appears, confirm that the objects to be removed are correct and click OK.
Notice
After you reduce objects, you cannot restore them. Proceed with caution.
The operation to reduce objects succeeds for all objects or fails for all objects.
After the operation to reduce objects starts, the modification record is generated on the View Objects > Modification History page, where you can view the details of the record.
Modify validation objects selected by the match by rule method
On the details page of the target task, click View Objects in the upper-right corner.
On the Synchronization Range tab of the View Objects page, click Modify Rules in the lower-right corner.
In the Modify Rules dialog box, modify the matching rule to add or remove objects.
Click Verify. After the validation is completed, click Preview Objects to view the matching rule.
Click Next.
When you add an object, the system performs a precheck on the object.
When you remove an object, the page displays the specific object to be removed.
After the precheck succeeds or the object to be removed is confirmed, click Submit.
After the object to be removed is removed, the modification record is generated on the View Objects > Modification History page, where you can view the details of the record.