Help Center/ DataArts Studio/ FAQs/ DataArts Migration (Real-Time Jobs)/ What Should I Do If an Error Message Containing "tinyint out of range" Is Displayed During Incremental Synchronization from MySQL to DWS?
Updated on 2026-03-20 GMT+08:00
View PDF
Share

What Should I Do If an Error Message Containing "tinyint out of range" Is Displayed During Incremental Synchronization from MySQL to DWS?

Symptom

After a real-time job from MySQL to DWS is started, an exception occurs during the synchronization, and the error message "tinyint out of range" is displayed.

Figure 1 Error message

Possible Causes

When data is written to the destination DWS, the length of the tinyint field exceeds the threshold.

Solution

Determine the overflow field based on the error log and ensure that the type and length of the corresponding field on the destination DWS can cover the length of the source field.