Hi,
Does anyone know the reason for the error ‘BPA_RESULT_SET_LIMIT_REACHED_EXCEPTION_ERROR’ to be thrown when a workflow is executed?
Thanks,
Dananjaya Misso.
Solved
BPA throws error 'BPA_RESULT_SET_LIMIT_REACHED_EXCEPTION_ERROR'
+9Best answer by kamnlk
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.
+9I 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.
+9Thanks for the answer
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.