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
I am facing the same issue .