Forum Discussion
Error When Creating Pipeline in Fabric Warehouse: Arithmetic Overflow
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.
Microsoft Employee
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
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
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.