AL_SECURITY_IDENTIFIER table error creating new asset

Products

• CA Service Management - Asset Portfolio Management
• CA IT Asset Manager
• CA IT Asset Manager Asset Portfolio Management

Issue/Introduction

When attempting to create a new asset in CA IT Asset Manager, (ITAM), receive an "AL_SECURITY_IDENTIFIER" table error

Environment

CA IT Asset Manager 17.x

All Supported Operating Systems

Resolution

In ITAM, all fields or attributes will have a specific security_id which is auto-generated when that field is created

If the security_id is missing, the "AL_SECURITY_IDENTIFIER" table error is received.

Run the following Stored Procedure against the MDB database that ITAM is configured to use:

EXEC AL_BUILD_SECURITY_HIERARCHY;

Once completed, perform an IISRESET on the ITAM server and clear web browser cache.