Asset ID+ field values on AST:AssetPeople form are set to NULL / BLANK  when  People records are associated to a CI

Version 3
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy IT Service Management Suite


    COMPONENT:

    Remedy Asset Management Application



    PROBLEM:

    When People records are associated to any CI, the Asset Entry-ID and Asset ID+ field values on AST:AssetPeople form are set to NULL / BLANK .


    CAUSE:

    This is a know defect SW00564346


    SOLUTION:

    The use case has been fixed in ITSM 20.02 version. 
    In order to correct the data previously present in the  AST:AssetPeople we need to perform below steps

    After upgrading to the 20.02, perform below steps:

    Capture the records count by running below SQL queries.
    SELECT * FROM arschema WHERE name = 'AST:AssetPeople';
    SELECT Count(*) FROM <<SCHEMAID>> WHERE C260100009 IS NULL;

    1.            Login to Dev-studio Import attached definition file which contains one  escalation and one filter.
    2.            Search for the “AST:AST:People_SetAssetEntryID” escalation and Right click on it, click on Run Now option
    3.            This manual run of escalation may show the timeout message which is for client side. Server side the process is still running. Please wait to process gets completed.
    4.            Rerun the above count query once it is showing zero count disable the filter “AST:AST:People_SetAssetEntryIDEscl_SkipAll”
     


    Article Number:

    000183706


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles