HEAT Discovery- update FRS_IM_Change set FRS_CIComponentLink_RecID Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Version 1

    Details

    HEAT Discovery- update FRS_IM_Change set FRS_CIComponentLink_RecID Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding error found in the assetprocessor.frslog.


    Resolution

    Customer added the following index to the HEATSM database to resolve the issue:



    CREATE NONCLUSTERED INDEX Idx_FRS_IM_Change_FRS_CIComponentLink_RecID ON FRS_IM_Change
    (
    FRS_CIComponentLink_RecID
    )