由于存在错误，Http请求失败：'无法向缓冲区写入比配置的最大缓冲区大小更多的字节：104857600。'。 [英] Http request failed as there is an error: 'Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600.'.

问题描述

 使用Logic Apps将Azure SQL数据库中的大表导出为CSV，我有一个包含70列和100万行的表。我使用Logic Apps导出数据并上传到FTP。

我收到以下错误消息：
$


BadRequest。由于存在错误，Http请求失败：'无法向缓冲区写入比配置的最大缓冲区大小更多的字节：104857600。'
b


请注意。如何在逻辑应用中增加MaxResponseContentBufferSize

---

Sagar Gulati

 Export Huge Table from Azure SQL Database to CSV using Logic Apps, I have a table with 70 columns and 1 million rows. I use Logic Apps to export data and upload to FTP.
I get the error message below:

BadRequest. Http request failed as there is an error: 'Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600.'

Please advise. how to increase MaxResponseContentBufferSize in logic app

---

Sagar Gulati

推荐答案

Hello Sagar

Hello Sagar

SQL Server Logic应用程序的连接器支持分页。您可以批量检索数据。 

The SQL Server connector for Logic apps supports pagination. You can retrieve your data in batches. 

请检查此
article 详细步骤。

如果我们知道是否你还有其他问题。

Let us know if you have further questions.

-

-

如果上述答案有用，请点击"Mark作为答案"或"Up-Vote"，这可能对阅读此主题的其他社区成员有益。 

If the above answers were helpful, click "Mark as Answer" or "Up-Vote", which might be beneficial to other community members reading this thread. 

这篇关于由于存在错误，Http请求失败：'无法向缓冲区写入比配置的最大缓冲区大小更多的字节：104857600。'。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！