Symptoms

There is an undocumented choice Reference Cascade Rule for initiated_from field in sm_order and sm_task tables. The documentation did not have an explanation for it.

Release

All available releases

Cause

It is an invalid Reference Cascade rule. Reference Cascade rule for initiated_from field is not suppose to have any restriction when the referencing record is deleted. 

Resolution

The value "restrain" actually is not a valid value in the DB, therefore the behavior defaults to none - not having any cascade effect (expected behavior). If this value is set to "restrict", the behavior will start restricting cascade deletion when the referencing record is deleted, which we is not intended. So no action is required to resolve the issue.

Additional Information

https://docs.servicenow.com/csh?topicname=t_CascadeDeleteRules.html&version=latest