Date picker on extended fields shared with CA CMDB is not displayed

Article Id: 17917

Status: Published

Updated On: 14-02-2018 08:16

Legacy Id: TEC615411

Products:

CA Automation Suite for Data Centers - Configuration Automation , CA Client Automation - Asset Management , CA Client Automation - IT Client Manager , CA Client Automation , CA Client Automation - Remote Control , CA Client Automation - Asset Intelligence , CA Client Automation - Desktop Migration Manager , CA Client Automation - Patch Manager , CA IT Asset Manager , CA Software Asset Manager (CA SAM) , ASSET PORTFOLIO MGMT- SERVER , CA Service Management - Asset Portfolio Management , CA Service Management - Service Desk Manager

Issue/Introduction:

Descriprtion:

After following the instructions of CA APM Implementation Guide to define an asset extended field shared with CMDB, the date fields are not displayed as a date field.

Solution:

On top of the steps described in the Implementation Guide you will need to run SQL queries for each date field you add.

NOTE: before going ahead with any SQL update you should make sure a full valid backup of the MDB is available.

The below queries should be executed against the MDB, changing 'field_name' and 'attribute_name' accordingly to match the CA CMDB fields you are configuring in APM.

USE mdb
UPDATE arg_field_def SET data_type=99 WHERE table_name = 'usp_owned_resource' AND field_name='nr_exp_dt'
UPDATE al_form_attribute_def SET control_type_id=10 WHERE class_name='usp_owned_resource' AND attribute_name='nr_exp_dt'

After that execute IISRESET on the APM Application and Web Servers.

Environment:

Release: UASIT.99000-12.8-Asset Intelligence
Component: