In our application in preprod env we are getting an error like "Processing was cancelled due to an interrupt.. SQL Code = 952, SQL State = 57014"
This error is coming for a particular condition. The same functionality works fine for different user and different condition. Please note its coming for a report definition generated query.
I googled the error and it appears someone fixed this issue by setting CommandTimeout in the application. Please let me know if in pega we have any such option to do the same or this needs to be set up from DB side