Copy Activity Fabric Pipeline error

[IAZ]

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

}

}

}

]

[v-prasare]

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

[HimanshuS-msft]

I am facing the same issue .

[mabdollahi · Accepted 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:

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

[IAZ]

That worked. cast as varchar2. many thanks

[mabdollahi]

Glad that it worked.