CA PPM: Deleting Custom Object Deletes Unrelated Dependencies.

Document ID : KB000006888
Last Modified Date : 10/08/2018
Show Technical Document Details
Issue:

Deleting Custom Object Deletes Unrelated Dependencies
When I delete a custom object, the list of "dependencies" that are listed on the delete confirmation screen, are completely unrelated to the object being deleted.

Steps to Reproduce:

1. Create Custom Object: name=nt_a, ID=a

2. Create Custom Object: name=nt_abc, ID=abc

3. Create Query: name=nt_abc, ID=abc

SELECT @SELECT:DIM:USER_DEF:IMPLIED:X:id:id@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:X:name:name@
FROM odf_ca_abc WHERE @FILTER@

4. Create Portlet: name=nt_abc, ID=abc using query created in step 3.

5. Go to object list. Filter by Object name=nt_a. Select it and hit Delete button.

6. Check "dependencies" on the delete confirmation screen.

Expected Result: 

When deleting a custom object only dependencies associated with that object to be deleted.
portlet 'nt_abc' and query 'nt_abc' should not be included in the list. Delete confirmation screen should show:

The following dependent items will also be processed, there may also be reports or database views/stored procedures/functions using this object which will not be removed
Name   Type Action
a Default Layout Page Delete
a List   Portlet Delete
a Tabs   Portlet Delete
a Contents  Portlet Delete
a Properties  Portlet Delete
a Processes  Portlet Delete
a Audit Trail  Portlet Delete.

Actual Result: 

When deleting a custom object only dependencies associated with that object to be deleted.
Portlet 'nt_abc' and query 'nt_abc' are included in the list. Delete confirmation screen shows:
The following dependent items will also be processed, there may also be reports or database views/stored procedures/functions using this object which will not be removed
Name   Type Action
a Default Layout Page Delete
a List   Portlet Delete
a Tabs   Portlet Delete
a Contents  Portlet Delete
a Properties  Portlet Delete
a Processes  Portlet Delete
a Audit Trail  Portlet Delete
nt_abc   Portlet Delete
nt_abc   Query Delete

Cause:

 

 

Caused by DE31819

Resolution:

 

 

Fix is available in 15.3.