on 04-24-2012 8:30 AM
Hi,
I have been getting the email reminders for one request which was cancelled. I am working on GRC 5.3. anybody has any idea how I can analyse this and solve?
It seems that CUP tool some how does not recognize it as "cancelled" and that is why sending email reminders. How I can make CUP tool recognize that this request is a cancelled one?
Regards,
Faisal
Hi Faisal,
Check if this note solves the problem:
Note 1535358 - How to stop email reminders for the closed requests
Regards,
Ajesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ajesh,
Thanks for your kind reply.
This note seems to be useful. However, when I checked the status of the request in question, in the table "VIRSA_AE_RQD_WPFWD", it was updated as "CLOSED". I still changed it to "CLOSED" and checked in CUP, the status of the request is still "CANCEL".
I then changed the status of the request in question to "CLOSED" in table "VIRSA_AE_RQD_WPTRN". It updated 7 rows as "CLOSED". Earlier, below were the different statuses in the above table for the same request:
STATUS
------------------------------------------------------------
APPROVE
CLOSED
APPROVE
CANCEL
CANCEL
OPEN
OPEN
Now it is as:
STATUS
------------------------------------------------------------
CLOSED
CLOSED
CLOSED
CLOSED
CLOSED
CLOSED
CLOSED
Having changed the status of this request, still I notice that the status is shown as "CANCEL" in CUP. Any idea, where this status is coming from?
Regards,
Faisal
Hi Faisal,
I am not exactly sure where it is stored, dont have access to Database to check the details.
Have the email reminders stopped or you are still getting them?
Check table VIRSA_AE_REQD_HDR or tables VIRSA_AE_REQ*. It might be maintained in the header of the request.
If your reminders are stopped, I suggest you dont run other SQL commits, as its not suggested in note.
Regards,
Ajesh.
Ajesh,
Thanks for your reply.
I have asked the user to let me know if he receives any reminders for the request. I checked the table
"VIRSA_AE_REQD_HDR", it is not available.
I have checked the field "STATUS" for tables:
VIRSA_AE_RQD_WPFWD
VIRSA_AE_EMLLOG
VIRSA_AE_RQD_WPTRN
All of them have status as "CLOSED". I am not sure where the status "CANCEL" is coming from.
Please suggest if possible.
Regards,
Faisal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.