When deleting a User Define Collection the data is still shown in the UDC dashboard (4377831)

When deleting a User Define Collection the data should not be shown in the UDC dashboard. When a user deletes a UDC the data that has been collected will keep in the topology and won’t be deleted.

The User Define Collection topology purges after 390 days by default

WORKAROUND

Run the attached groovy script. Contact Support for groovy scripts for other cartridge versions.

def topologyService = server.get("TopologyService");
def Userdefinedcollections = #!DBSS_Custom_Query_Instance where name like 'DBSS_Cust_%'#.topologyObjects;
if ((Userdefinedcollections == null) || (Userdefinedcollections.isEmpty())) {
return "User defined collection does not exists!";
}
else {
for(item in Userdefinedcollections){
    println item
item = item.getUniqueId()
item = topologyService.getObject(item);
topologyService.deleteObject(item);
}
return "Done!";
}

STATUS

This issue has been logged as defect FOG-9368 and will be fixed in a future release of the database cartridge.