none
Stored Proc action error: Cannot write more bytes to the buffer than the configured maximum buffer size: 10485760 RRS feed

  • Question

  • I have a Logic app which is triggered from and HTTP request and when triggered it executes a stored procedure to create a CSV file and write the data to blob storage.  after running for about a minute the logic app bombs out on the procedure with the following error

    Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600.'

    This procedure returns over a million rows so it will definitely blow out 100MB.  Is there a way around this?  I found documentation around paging and handling bulk data which even mentions creating a stored proc but I see no way of implementing this as there is no pagination option in the Stored Proc V2 action:

    https://docs.microsoft.com/en-us/azure/connectors/connectors-create-api-sqlazure

    Wednesday, October 16, 2019 8:37 PM

All replies