topic Re: Copy Activity Fabric Pipeline error in Pipelines

Copy Activity Fabric Pipeline error

IAZ — Sat, 14 Jun 2025 08:02:26 GMT

Trying to copy data from Oracle using copy activity and the follwing message comes up:

ErrorCode=UserErrorWriteFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The file operation is failed, upload file failed at path:'.,Source=Microsoft.DataTransfer.Common,''Type=System.ArgumentException,Message=Could not determine JSON object type for type Microsoft.DataTransfer.DataTypes.OracleBigDecimal.,Source=Newtonsoft.Json,'

Schema used is as below and for test pupose used just one column:

[

{

"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

}

]

Re: Copy Activity Fabric Pipeline error

mabdollahi — Mon, 16 Jun 2025 06:31:11 GMT

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

Re: Copy Activity Fabric Pipeline error

HimanshuS-msft — Wed, 18 Jun 2025 17:36:21 GMT

I am facing the same issue .

Re: Copy Activity Fabric Pipeline error

v-prasare — Wed, 18 Jun 2025 18:19:36 GMT

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

Re: Copy Activity Fabric Pipeline error

IAZ — Wed, 18 Jun 2025 19:37:25 GMT

That worked. cast as varchar2. many thanks

Re: Copy Activity Fabric Pipeline error

mabdollahi — Thu, 19 Jun 2025 01:53:19 GMT

Glad that it worked.