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

Seelan, Sathiya 40 Reputation points
2024-05-15T11:29:53.5733333+00:00

I have created a workflow in Azure logic app where we can execute the SQL Stored procedures at Azure SQL Database and the result will get created as csv file and stored in Azure blob . We are facing a BadRequest

Http request failed as there is an error: 'Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600.'. issue on one of the workflow . we thought it the table has more records so we alter the stored procedure to fetch only 2 lakh records but still facing the same error at execution step.

we also have similar other workflows which are fetching 1.95 lakh records . Can I have some expert advise for the issue .

User's image

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,240 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Swathi Dhanwada 18,781 Reputation points Microsoft Employee
    2024-05-23T03:56:24.78+00:00

    @Seelan, Sathiya Thanks for reaching out.

    If you are using consumption, then there is no configuration that supports increasing this limit of HTTP connector.

    In case if you are running your workflow in a standard logic app then this configuration can be changed. By default, the max size content is configured as 104857600 bytes as documented here for standard logic app.

    To increase the size of for the build in HTTP trigger you need to configure the Runtime.Backend.HttpOperation.MaxContentSize in the application setting on your standard logic app. Further you may hit the limit value of inputs and outputs that the trigger/action. So, you need to configure the settings for Input and Outputs as mentioned here.

    These configurations are only supported/valid for standard logic apps. In consumption logic app there is no way to configure any setting or increase the default limits.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.