admin管理员组

文章数量:1417469

I’m using ADF Self-hosted Integration Runtime (SHIR) in a pipeline with a copy activity that queries a DB2 database. The query filters and retrieves records. The SHIR is connected to a backend server hosting DB2, and when I run the query using ADF's debug mode, the number of records matches the number of records I get from DBVisualizer.

However, the DB2 server has been moved to the cloud, and the SHIR is still connecting through a VPN tunnel. Now, when I run the query through ADF's copy activity, I get fewer records than when I run the same query using DBVisualizer.

I’ve checked all settings, but I can’t find the reason for the missing records. The issue seems to happen when the data exceeds a certain size (in KB) — the records are dropped, but it’s not truncating columns, just the records themselves.

If I point the linked service back to the old DB (on-premises), it works fine. Is there any way I can troubleshoot this issue, or has anyone experienced a similar problem?

本文标签： Truncated number of records while using self hosted IR with azure data factoryStack Overflow

版权声明：本文标题：Truncated number of records while using self hosted IR with azure data factory - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1745267728a2650703.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。