Forum Discussion
Copy Activity Fabric Pipeline error
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
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:
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
That worked. cast as varchar2. many thanks
Glad that it worked.