Forum Discussion

FabricLearner's avatar
FabricLearner
Frequent Visitor
2 years ago

Error When Creating Pipeline in Fabric Warehouse: Arithmetic Overflow

Hi everyone,

 

I'm encountering an issue while trying to create a pipeline in Fabric Warehouse to retrieve data from SQL Server. The error message I'm receiving is related to column mappings and specifically states: "Arithmetic operation resulted in an overflow."

 

Any advice or insights would be greatly appreciated!

Thank you in advance for your help.

 

 

 

pipelines

5 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hi FabricLearner 

     

    Thanks for using Microsoft Fabric Community.

     

    The error message “Arithmetic operation resulted in an overflow” typically occurs when performing mathematical operations that exceed the limits of the data type being used.

    Confirm that the data type set for the affected column is appropriate. If you’re dealing with large numbers, ensure that the column is set to a 64-bit integer (Whole Number). This data type can handle larger values without causing overflow errors. Double-check the data lineage and ensure that any changes in the data source (such as switching blob storage accounts) are reflected correctly. Sometimes, discrepancies in the lineage view can lead to unexpected behavior.

    For similar issue please refer thread link : Solved: Arithmetic Operation Overflow - Microsoft Fabric Community

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Thank you.

    • FabricLearner's avatar
      FabricLearner
      Frequent Visitor
      2 years ago

      Hi v-cboorla-msft,

       

      I appreciate the assistance provided so far. I encountered this issue while attempting to copy a table “AS-IT-IS” from SQL Server to the Fabric Data Warehouse using the COPY Activity.

      • Here the table is being copied without any column transformations; it’s a straightforward copy operation
      • Interestingly, when I use Dataflow Gen2, the process works flawlessly
      • The same table is successfully copied to the Fabric warehouse without any issues
      • To connect to SQL Server, I rely on an ODBC connector and on-premises gateway

      Are there any Gateway Limitations while using pipelines?

      I suspect that the error might be related to the fact that the copy activity in Fabric may not properly support data sources connected via an on-premises gateway.

       

      Please advise me further on this.

       

      Thank you.