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

Question

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 .

Answer 1

@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.