Forum Discussion
Solved
Copy Activity Fabric Pipeline error
Trying to copy data from Oracle using copy activity and the follwing message comes up: ErrorCode=UserErrorWriteFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryExcep...
Hi IAZ
It looks like the issue is with how Oracle’s BigDecimal type maps to JSON — it doesn’t match well with a simple Float. Try casting INVOICE_ID as FLOAT in your SQL query, like:
SELECT CAST(INVOICE_ID AS FLOAT) AS INVOICE_ID FROM IFS....This helps avoid serialization errors. Also, double-check your mapping settings and source data to make sure everything lines up with your target types.
Regards,
Mehrdad
Hi IAZ ,
In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thanks,
Prashanth Are
MS Fabric community support