CMDB Relationship editor - If cmdb_rel_type and cmdb_rel_group relationships are deleted at the same time, only the cmdb_rel_group is actually deleted - Known Error

CMDB Relationship editor - If cmdb_rel_type and cmdb_rel_group relationships are deleted at the same time, only the cmdb_rel_group is actually deleted Description Since San Diego, the CI Relationship Editor does not delete all relationships selected on Save, if they are a mixture of kinds of relationship - CI and Group. (This might also affect Person relationships)

Steps to Reproduce

On a San Diego instance with demo data Open computer "*ANNIE-IBM" /cmdb_ci_computer.do?sys_id=b4fd7c8437201000deeabfc8bcbe5dc1 Add 2 relationships: a cmdb_rel_group type: Backup done by::Does backups for group: NY DB a cmdb_rel_ci type: DR provided by::Provides DR for CI: Bond Trading - DR Save

Now to delete them: select both relationships, and click the red Bucket to delete Save You will see that the cmdb_rel_ci relationship remains on the screen when it reloads, which is because they have not been deleted.

App node logs (with SQL debug) look like this: #4395607 /api/now/ cmdbrelation/delete-rels Parameters ------------------------- sysIds=593d90c4db7aff00368ed18c6896190a api=api type=sys_user_group *** Start #4395607 /api/now/cmdbrelation/delete-rels, user: david.piper@snc DELETE FROM cmdb_rel_group WHERE cmdb_rel_group.`sys_id` = '593d90c4db7aff00368ed18c6896190a'

This seems to be doing just 1 rest request for type=sys_user_group. There is no request for the other type.

select the remaining relationship and Save

App node logs (with SQL debug) look like this: #4396921 /api/now/cmdbrelation/delete-rels Parameters ------------------------- sysIds= c0f8544cdb76ff00368ed18c689619f2,c0f8544cdb76ff00368ed18c689619f2 api=api type=cmdb_ci *** Start #4396921 /api/now/cmdbrelation/delete-rels, user: david.piper@snc DELETE FROM cmdb_rel_ci WHERE cmdb_rel_ci.`sys_id` = 'c0f8544cdb76ff00368ed18c689619f2'

We see the type=cmdb_ci happen now, but also get the same sys_id listed twice in the parameters, which looks like another related issue in this code.

Do the same in a Rome instance. Both rest requests are sent as part of the same Save: 06:57:15.932 #12166 /api/now/ cmdbrelation/delete-rels Parameters ------------------------- sysIds=87bd04511bb559105a855311604bcbf9 api=api type=cmdb_ci 06:57:15.969 Time: 0:00:00.000 for: empdpipergeneva_1[glide.2] DELETE FROM cmdb_rel_ci WHERE cmdb_rel_ci.`sys_id` = '87bd04511bb559105a855311604bcbf9' 06:57:16.411 #12167 /api/now/ cmdbrelation/delete-rels Parameters ------------------------- sysIds=16bd04511bb559105a855311604bcb74 api=api type=sys_user_group 06:57:16.436 Time: 0:00:00.000 for: empdpipergeneva_1[glide.7] DELETE FROM cmdb_rel_group WHERE cmdb_rel_group.`sys_id` = '16bd04511bb559105a855311604bcb74' Expected behaviour: Everything you have ticked and deleted should be actaully deleted when you click Save

Actual Behaviour: Only the cmdb_rel_group is deleted.

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.

The workaround is to tick the remaining undeleted relationships again, click the red bucket, and Save. The remaining relationships will be deleted.