the "admin_password" field from "al_process_account" table is created with a space at the end

Products

• CA IT Asset Manager Asset Portfolio Management

Issue/Introduction

The "admin_password" field from  "al_process_account" table is created with a space at the end. See image below:

 

Environment

Release : 17.3

Cause

Defect with ITAM 17.3

Resolution

Workaround:

Rename the field by using below SQL query:

EXEC sp_rename 'al_process_account.admin_password ', 'admin_password';

Solution:

Fixed in 17.3 RU23.

Also, the manual update from above would not be overwritten by any of the later RUs.