I am not sure whether this was the exact reason but after starting a watch on the workflow I noticed that I am not passing the ORDER_NO from the Event and because of this it was giving the following error during inspection -
 

I made a change to pass the ORDER_NO from the event and then there was no issue -
 

Thanks,
Dananjaya Misso.

you have correctly identified the issue. When we try to use an API task to Read collection, if we are reading large amount of data in, we would get the BPA_RESULT_SET_LIMIT_REACHED_EXCEPTION_ERROR.

Its best practice to reduce the amount of data read into a workflow using proper filters and options to avoid this case.

Thanks for the answer @kamnlk