CPG deprovision operation is affected due to aggressive data flush from order table - Known Error

CPG deprovision operation is affected due to aggressive data flush from order table Description CPG deprovision operation is affected due to aggressive data flush from order table. Steps to Reproduce

Create an active stack Wait for 30 days + time sys_flush script runs post 30 days and remove the order data from table sn_cmp_order for the respective stack Perform de-provision for the same stack, and it fails.

Reason: sn_cmp_order data for active stack used during de-provision and should be available. Workaround This problem is currently under review. You can contact ServiceNow Technical Support or subscribe to this Known Error article by clicking the Subscribe button at the top right of this article to be notified when more information becomes available.

Until then, workaround is to apply the attached fix script update set, that must be imported into the instance and from "System Definition -> Fix Scripts" find the "CPG - Fix Missing Orders for Stacks" and run it.

This is going to restore the order data from the RITM's for active stacks to help for de-provision.

Also turn off the auto-flush on order table to avoid any further deletion.

Steps 1. Open table - sys_auto_flush 2. Look for table - Cloud Orchestration ( sn_cmp_order ) 3. Turn off the active flag

Once upgraded to the Fix Version, active flag on the auto-flush need to be turned on.