I have multiple open CRs which did not close out due to certain technical issues, but while we search for the root cause, we need to close the CRs. Should I proceed with the closure of CRs or check on closing the open watches as well. Kindly let me know what efficiency watches provide over closing CR, and whether closing of CRs will work prefectly.
Please do not proceed this way. Closing CRs using SQL queries is a very bad practice and will never clean-up all dependencies as the UI would do.
For example here are some things that the proper cancel button from the UI will handle:
I know that you may be using a SQL script provided by RSA support at one point, but any of such scripts are provided to be run for a specific case and are not to be used to generally close CRs.
Here are some alternatives: