Skip to main content

Skip Schema Migration Exception

This page describes how to skip a schema migration exception.

Issue​

An exception icon 5 occurs during schema migration, which prompts that "There is an exception in this DataJob. Click to view details".

Cause​

Some data types are not supported for schema migration, or bugs occur (welcome to report the bugs in our forum). In these cases, you can skip the schema migration exception.

Solution​

  1. Open Schema Migration Log and locate the DDL statements that cause the exception.
  2. Copy the DDL statements, and modify them to the right ones according to the actual situation. Then execute the modified DDL statements in the target database.
  3. Go to the DataJob list page. Click the icon 5 next to the DataJob ID, and click Retry in the upper-right corner of the failed ConsoleJob.