Managed Attribute Modification or Creation Fails

Products

• CA IT Asset Manager Asset Portfolio Management
• CA IT Asset Manager

Issue/Introduction

When trying to configure or create a Managed Attribute in ITAM, an error is generated in the GUI saying:

Error occurred. Check log for details.

Investigation into stdlog shows the following logs:

08/27 12:18:30.18 <SERVER> domsrvr                13228 ERROR        domset.c             13533 P_List_dob_by_helper got NOT FOUND attempting to get nrf:0
08/27 12:18:30.18 <SERVER> spelsrvr                7948 ERROR        cmdb_managed_attribu   176 search_for_attribute0300: Unable to get dob : 'NOT FOUND'
08/27 12:18:30.20 <SERVER> web:local              11604 ERROR        freeaccess.spl       26033  update checkin of ci_managed_attribute:400009 failed: Error occurred. Check log for details.
08/27 12:18:34.35 <SERVER> reminder_nxd           12912 SIGNIFICANT  reminder_nxd.c        1047 0 reminders pending from now to 08/27/2024 12:48:34; 0 backlogged"

Environment

ITAM 17.4 RU2

SDM 17.4 RU2

Cause

08/27 12:18:30.18 <SERVER> domsrvr                13228 ERROR        domset.c             13533 P_List_dob_by_helper got NOT FOUND attempting to get nrf:0

The nrf identifier references the ca_resource_family table

0 is an invalid identifier.

Resolution

After deleting the Family with the invalid identifier creation and modification of Managed Attributes was successful. 

We suggest also creating new families and confirming they are generated with valid IDs.

Additional Information

Possible reasons the invalid identifier exists:

database corruption

someone manually changed the ID

Both possibilities are fairly problematic, so we advise the customer investigate the root cause so it does not happen again.