Loading...
Loading...
On Domain Separated instances, decision answers are not displaying in decision builder, as answer records are deleted and the reference to decisions is broken. This is happening due to a scheduled job 'Decision Table Multi Result Cleaner'. The expectation of this job is to clean all stale answer records from the sys_decision_multi_result table. But due to this error it's deleting valid answer records as well. Steps to Reproduce 1. Hop onto instance: empmpratapsinghrome (on any domain-separated instance prior to Vancouver) 2. Switch to any other domain than global [on this we switched to "TOP/MSP/MSP Technicians (Optional)"] 3. Navigate to System Definitions > Decision Tables or access the below link https://empmpratapsinghrome.service-now.com/sys_decision_list.do?sysparm_query=&sysparm_view= 4. Click on New > Decision Builder will be opened > Populated all details like Name, Inputs, Decision table, Conditions, Results 5. For now created "Test2 - created in Domain" https://empmpratapsinghrome.service-now.com/now/decisiondesigner/decisiontable/3704f691874dad109c8aa6880cbb356a?sys_id=3704f691874dad109c8aa6880cbb356a&sysparm_record_list=name%3dTest2+-+created+in+Domain%5eORDERBYDESCname&sysparm_record_row=1&sysparm_record_rows=1&sysparm_record_target=sys_decision 6. Entry got created in Decisions [sys_decision_question] and Decision Table Multiple Result [sys_decision_multi_result] https://empmpratapsinghrome.service-now.com/sys_decision_question_list.do?sysparm_query=decision_table%3D3704f691874dad109c8aa6880cbb356a&sysparm_view= https://empmpratapsinghrome.service-now.com/sys_decision_multi_result_list.do?sysparm_query=decision_table%3D3704f691874dad109c8aa6880cbb356a&sysparm_view= 7. Navigate to Scheduled Script Execution: Decision Table Multi Result Cleaner and Execute Now https://empmpratapsinghrome.service-now.com/nav_to.do?uri=sysauto_script.do?sys_id=3517e93fa3210110e355f99246fcdaa4 8. Entry still exists in Decisions [sys_decision_question] but missing value in Answer field id viewed in List view, if record opened and show XML is performed then sys_id still exists https://empmpratapsinghrome.service-now.com/sys_decision_question_list.do?sysparm_query=decision_table%3D3704f691874dad109c8aa6880cbb356a&sysparm_view= 9. Entry got deleted from Decision Table Multiple Result [sys_decision_multi_result] https://empmpratapsinghrome.service-now.com/sys_decision_multi_result_list.do?sysparm_query=decision_table%3D3704f691874dad109c8aa6880cbb356a&sysparm_view= *** Current Behavior: Along with Stale entries, Valid entries are also being deleted from Table "Decision Table Multiple Result [sys_decision_multi_result]" as part of OOB Scheduled Script Execution "Decision Table Multi Result Cleaner" ***
It should only delete stale entries from Table "Decision Table Multiple Result [sys_decision_multi_result]" as part of OOB Scheduled Script Execution "Decision Table Multi Result Cleaner"
This issue is fixed as a part of Vancouver release. For customers on instances with earlier release the workaround is to disable the scheduled job 'Decision Table Multi Result Cleaner' in their instance. This step may require MAINT access and can be found by navigating to Menu-> System Definition -> Scheduled Jobs -> "Decision Table Multi Result Cleaner" -> Configure Job Definition (in the Related Links) -> Uncheck "Active" Once they upgrade to Vancouver, they can activate the job.
PRB1642563
Click on a version to see all relevant bugs
ServiceNow Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.