Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Trying to copy data from Oracle using copy activity and the follwing message comes up:
[ |
{ |
"source": { |
"table": "IFS...." |
}, |
"destination": { |
"fileName": "dbo.tt.json" |
}, |
"WaterMark": { |
"table": "WIFSAPP_C" |
}, |
"mapping": { |
"type": "TabularTranslator", |
"mappings": [ |
{ |
"source": { |
"name": "INVOICE_ID", |
"type": "Float" |
}, |
"sink": { |
"name": "INVOICE_ID", |
"type": "Float", |
"physicalType": "Float" |
} |
} |
], |
"typeConversion": true, |
"typeConversionSettings": { |
"allowDataTruncation": true, |
"treatBooleanAsNumber": false |
} |
} |
} |
] |
Solved! Go to Solution.
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
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
I am facing the same issue .
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.
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |