Forum Discussion
Resolver IICopy Data with VNET gateway error
Resolver IIHi,
Thanks for your reply. For the destination I will share the screenshot. FYI, I've tested with a new lakehouse, our normal lakehouse connection, delta, parquet, new schema, dbo, files parquet. Besides that, it is also just a duplicate of another pipeline that is just working fine with the exact same logic. There are no multiple pipelines running, just 1, with 1 table.
Preferably I would write this data into tables. But checked all the options, all with same error message.
Community SupportHi TK12345
Thank you for the clarification.
Since another pipeline with the same logic is working successfully, this helps narrow the issue specifically to this pipeline/activity configuration or the source table metadata rather than the VNET gateway or Lakehouse itself.
Could you please try the following:
Create a new Copy Activity in the same pipeline and configure the source/destination manually instead of duplicating the existing activity.
Test with a minimal query:
Then test with:
SELECT TOP 10 *
FROM YourTable
If schema mapping is enabled, please remove and re-import the schema mapping.
Also verify whether the source table contains unsupported datatypes or special characters in column names.
This will help determine whether the issue is related to the specific pipeline configuration or the source table metadata.
- TK12345
Hi v-aatheeque,
Thanks for helping.
I've tested your suggestions again (tested it before myself), still the same issue. Created a new pipeline just from the UI, new connection, new lakehouse. Just a select limit 10. Still preview data to see, but same error with target.