Issue
While uploading a file, the following error appears:
“ERROR:java.lang.IllegalArgumentException: Scale 19 greater than precision 18”
Environment
Browser Upload
Answer
To resolve this error, please follow the steps below:
- Identify the column in the source file which contains a large number of digits to the right of the decimal point.
- From the Fivetran dashboard, click Uploads.
- Follow the upload wizard until the Select columns type, precision, and the table primary key(s) screen.
- Click the problem column.
- Click the $ icon.
-
Click ->0.00 (Fewer decimals places) to one less than the precision number which appeared in your error message.
Cause
Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. A column had a scale greater than precision.