Known issue - Copy activity from Oracle to lakehouse fails for Number data type
The copy activity from Oracle to a lakehouse fails when one of the columns from Oracle has a Number data type. In Oracle, scale can be greater than precision for decimal/numeric types. Parquet files in Lakehouse require the scale be less than or equal to precision, so the copy activity fails.
Status: Open
Product Experience: Data Factory
Symptoms
When trying to copy data from Oracle to a lakehouse, you receive an error similar to: ParquetInvalidDecimalPrecisionScale. Invalid Decimal Precision or Scale. Precision: 38 Scale:127
.
Solutions and workarounds
No workarounds at this time. This article will be updated when the fix is released.
Next steps
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir