Forum Discussion

IAZ's avatar
IAZ
Helper I
1 year ago
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.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
      }
    }
  }
]
 
Pipeline
  • mabdollahi's avatar
    mabdollahi
    1 year ago

    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

5 Replies

  • mabdollahi's avatar
    mabdollahi
    Advocate IV
    1 year ago

    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