Run Query and List Results Logic App

%3CLINGO-SUB%20id%3D%22lingo-sub-1601756%22%20slang%3D%22en-US%22%3ERun%20Query%20and%20List%20Results%20Logic%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601756%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20running%20a%20query%20using%20a%20Logic%20App%20that%20pulls%20in%20data%20from%20the%20Security%20Event%20table%20and%20we%20are%20encountering%20an%20error%20a%20majority%20of%20the%20time%20when%20we%20run%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EBadRequest%3C%2FSTRONG%3E%3CSPAN%3E.%26nbsp%3BHttp%20request%20failed%20as%20there%20is%20an%20error%3A%20'Cannot%20write%20more%20bytes%20to%20the%20buffer%20than%20the%20configured%20maximum%20buffer%20size%3A%20104857600.'.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20time%20range%20is%20only%20configured%20to%20look%20at%2015%20minute%20intervals.%20We%20have%20been%20decreasing%20the%20scope%2C%20but%20shortening%20our%20time%20range%20hasn't%20seemed%20to%20make%20any%20difference.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAny%20insight%20into%20this%20would%20be%20great.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20query%20and%20time%20range%20are%20configured%20as%20follows%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESecurityEvent%3CBR%20%2F%3E%7C%20where%20ingestion_time()%20between(datetime(2020-05-22T00%3A00%3A00.0000000)%20..%20datetime(2020-05-22T00%3A15%3A00.0000000))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Ebetween(datetime(2020-05-22T00%3A00%3A00.0000000)%20..%20datetime(2020-05-22T00%3A15%3A00.0000000)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604120%22%20slang%3D%22en-US%22%3ERe%3A%20Run%20Query%20and%20List%20Results%20Logic%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604120%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572555%22%20target%3D%22_blank%22%3E%40mperrotta%3C%2FA%3E%26nbsp%3BIt%20appears%20that%20you%20are%20getting%20too%20much%20data%20returned.%26nbsp%3B%20If%20you%20lower%20the%20time%20range%20do%20you%20get%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

We are running a query using a Logic App that pulls in data from the Security Event table and we are encountering an error a majority of the time when we run it.

 

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

 

The time range is only configured to look at 15 minute intervals. We have been decreasing the scope, but shortening our time range hasn't seemed to make any difference. 

 

Any insight into this would be great.

 

The query and time range are configured as follows:

 

SecurityEvent
| where ingestion_time() between(datetime(2020-05-22T00:00:00.0000000) .. datetime(2020-05-22T00:15:00.0000000))

 

between(datetime(2020-05-22T00:00:00.0000000) .. datetime(2020-05-22T00:15:00.0000000)

1 Reply

@mperrotta It appears that you are getting too much data returned.  If you lower the time range do you get data?