NuGenesis SDMS Data Management module attempts to delete Empower projects with descendants only once, failing deletion with "Deletion Failed with Error - Captured Data not integral" - WKB247185

SYMPTOMS

• If deletion of Empower project fails because the Empower project being deleted has child projects not yet deleted, the delete fails with the delete status in VISION "Deletion Failed with Error - Captured Data not integral", and after that it won't try again
• The DM Delete status is FINAL, and deletion is not attempted again 
• The corresponding NGDMDELETEFLAG value is "6" in the NGCONMTENTMASTER table
• In the DMM log you see an error like this:

[7] : 2022-11-03 14:19:11:Initializing...
[] : 2022-11-03 14:19:11:Inited Successfully : Waters Corp. Empower-Millennium Projects DM EVS Plug~n~Play object!!
[7] : 2022-11-03 14:19:11:Data Management scan for Project [Empower Projects], Vendor [Waters Corp.] Product [Empower-3 Projects] Revision [0] started at [ 03-Nov-22 14:19:11].
[7] : 2022-11-03 14:19:12:Duration of candidate scan: 0h 0m 1s.
[] : 2022-11-03 14:19:21:Not Deleted Project:[EMP3.DMM Order\B\Tea 01] Remote machine: [WB-EMP-CL] it has descendants - Err.=-2147220839 – handle the project manually

ENVIRONMENT

• NuGenesis SDMS, all versions

CAUSE

This is a software defect that has been raised as CRI-5171.

FIX or WORKAROUND

No workaround available. Manual deletion of the parent Empower project is required when SDMS Data Management has deleted the descendants.

ADDITIONAL INFORMATION