Multi Row Variable Set data getting wiped out after closed completing the task.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-18-2024 11:35 PM
Issue with Data Loss in sc_multi_row_question_answer Table After Closing SCTASK Record
I am encountering an issue where, upon submitting a form through a Request, a Request (RITM) and subsequent SCTASK are generated. The SCTASK contains a variable set, and the corresponding values are stored in the sc_multi_row_question_answer table.
However, the problem arises when an edit operation is performed on the variable set of the SCTASK record, and the record is marked as "Closed Complete". After the record is closed, the data in the sc_multi_row_question_answer table appears to be wiped out.
Has anyone experienced this behavior? Why would marking the SCTASK record as "Closed Complete" cause data to be deleted from the sc_multi_row_question_answer table? Is there a configuration or process I should be aware of that could be leading to this data loss?
Any insights or solutions would be greatly appreciated!
My main concern is that why the data is getting wiped out from the variable set. (From my investigation I got to know that the data is getting wiped from the table: sc_multi_row_question_answer , however the resolution needed is that the data should be there even after the SCTASK record moves to "Closed Complete" status).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-19-2024 05:39 AM
Do you have any client scripts or business rules that run after that task is closed? I've not observed that behavior, and we use MRVSs a lot. I would guess something is running that is wiping it out. Also check your UI Policies and make sure none of them are set to Clear the Value of the MRVS.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-19-2024 09:44 PM
I have checked all possible Client Script, UI Policy, Business Rules, Scheduled Job, nowhere there is a code to wipe out the multi row variable set.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-20-2024 05:41 AM
Are you using this same MRVS in another catalog item? You may have to check the scripts and UI policies in that catalog item, too. I go to this URL to search for field names in UI policies to make sure they aren't hidden in unexpected places.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
9 hours ago
Hi,
were you able to find a solution for this issue?
