On DOMAIN when a SD process crash or is killed during SD job operations, some rows in SD tables could be lost (with missing links) or inconsistent.
This could generate some SD problems and/or performance problems.
Example of possible errors :
- When trying to delete a package following error appears :
SDM000126 - Software cannot be removed/archived because of an ongoing job and/or is included in a template group.
But package is not in ongoing SD job or in Software Policies.
- Some SD Jobs remain in GUI with executing status but SD Job Container has been deleted.
- Build of SD Job Container failed.
How to clean the SD tables from incorrect rows ?