Error When Creating Pipeline in Fabric Warehouse: Arithmetic Overflow

[FabricLearner]

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.

[v-cboorla-msft]

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]

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.

[v-cboorla-msft]

Hi @FabricLearner 

Prerequisites:

• The minimal version of on-premises data gateway supporting Fabric Pipeline capability should be >= 3000.214.1
• *.frontend.clouddatahub.net is allowed to be accessible in the machines hosting on-premises data gateway members.

For more details please refer : Adjust communication settings for the on-premises data gateway | Microsoft Learn

I hope this information helps.

Thank you.

[v-cboorla-msft]

Hi @FabricLearner 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond back with the more details and we will try to help.

Thank you.

[v-cboorla-msft]

Hi @FabricLearner 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thank you.