This documentation supports the 9.1 version of Remedy IT Service Management Suite.

To view the latest version, select the version from the Product version menu.

Deleting BMC Atrium CMDB attributes copied to AST:Attributes

Upgrading from a pre-8.0 version of BMC Remedy IT Service Management (BMC Remedy ITSM) requires a significant data model change and movement of data from the BMC Atrium CMDB to BMC Remedy ITSM. During upgrade to BMC Remedy ITSM 8.0 or later, a new table structure for the BMC Remedy ITSM attributes is created and lifecycle data is copied from the BMC Atrium CMDB to BMC Remedy ITSM AST:Attributes form and a workflow is introduced to keep the data synchronized. For details, see Changes to the BMC Atrium CMDB for BMC Remedy ITSM.

After upgrading to BMC Remedy ITSM 9.1.02, you can manually delete CMDB attributes by running the DeleteCMDBAttributesUtility that is available in the BMC Remedy ITSM Suite installation directory. The utility deletes the attributes and the workflow implemented in BMC Atrium CMDB.

Note

Before you delete the BMC Atrium CMDB attributes, consider the following:

  • Atrium Web Services do not work for moved attributes.
  • CMDB data using Atrium Integrator cannot populate data for moved attributes.
  • Reconciliation Engine and Normalization Engine rules do not work if the moved attributes were used in those rules.

Before you begin

  • Ensure that all the BMC Atrium CMDB attributes are copied to AST:Attributes.
  • Remove custom fields to avoid failures with deleting attributes. For information on identifying field customizations, see Finding whether and where fields are used in the system.
  • For attributes that remain in BMC Atrium CMDB, see BMC Remedy ITSM attributes that remain in the BMC Atrium CMDB.
  • Ensure that the following environment variables are specified:
    • Path variable is set to <JAVA_HOME>\bin
    • ATRIUMCORE_HOME and BMC_AR_SERVER_HOME are set to BMC Atrium Core and BMC Remedy AR System home directories, respectively.
      For example, C:\Program Files\BMCSoftware\AtriumCore and  C:\Program Files\BMCSoftware\ARSystem, respectively.
  • (On UNIX) For cmdbdriver, add the path of the directory containing shared libraries (such as libcmdbapi91_lx64.so) to "LD_LIBRARY_PATH".
  • Ensure you have permissions to execute the .bat, .sh, or .jar file contained in the DeleteCMDBAttributesUtility:

    For Windows, use DeleteAttributesAndWorkflows.bat
    For Linux and Solaris, use DeleteAttributesAndWorkflows.sh

To delete attributes and workflows on BMC Atrium CMDB

  1. Go to <InstallDirectory>\BMCRemedyITSMSuite\Utilities, open the DeleteAttributesAndWorkflows.bat or DeleteAttributesAndWorkflows.sh, and update the following parameters based on the values specified for them in your environment:

    • AR_SERVER_HOST

    • AR_SERVER_USER

    • AR_SERVER_PASSWORD

    • AR_SERVER_PORT

  2. On the command prompt, type the following command:
    For Linux:

    [root@<localhost>]# ./DeleteAttributesAndWorkflows.sh

    For Windows:

    <installDirectory>\Utilities\DeleteAttributesAndWorkflows> DeleteAttributesAndWorkflows.bat
    

    Running the utility deletes the attributes and associated workflows from BMC Atrium CMDB.

  3. Verify whether the attributes are deleted from the BMC_CORE:BMC_BaseElement form.
  4. Verify whether the following workflows are deleted: 
    • Filters: 

      • ASI:BAB:SynchABT

      • ASI:BAB:SynchABT-Modify

      • ASI:BAB:SynchABTGetProdDataset

      • ASI:SYA:SYNCTOBASE

      • ASI:BAB:PullASTAttributes

    • Active Links:

      • ASI:BAB:SetFlagField

      • ASI:SHR:All_PushSyncRecord

    • Escalation

      • ASI:SYA:ProcessSyncRecords

  5. In the SHARE:Application_Properties form, verify whether the phase property for Application ID "RA00C04FA081BAydPrRwNkQKqAbOMA" is set to "3-Complete". 

Related Topics

Upgrading the applications

Was this page helpful? Yes No Submitting... Thank you

Comments

  1. Vishakha Thalpati

    Hello Team,

        Regarding the start of the docs page: "Upgrading from a pre-8.0 version"  is it pre-8.0 or 8.0 and 8.1 both versions.

    Thanks in advance.

    Regards,

    Vishakha

    Mar 21, 2017 09:50
    1. Priya Ayyar

      Hi Vishakha,

      It is pre-8.0, which means all versions prior to 8.0, for example, 7.6.04.x.

      Hope that makes sense.

      Thanks,

      Priya

      Mar 31, 2017 07:17
  2. Manoj Patil

    Hi Team,

    Do we need to run 'Delete CMDB Attribute Utility' if we are upgrading from 8.x to 9.1 SP2?

    Regards

    Manoj Patil 

    Jun 07, 2017 11:33