Uninstall CA Service Management 17.2.0.8

This article contains the following topics:
Uninstalling 17.2.0.8 patch will revert to CA Service Management 17.2 version on which 17.2.0.8 is installed.
Example
: If 17.2.0.8 is installed on 17.2.0.1, uninstalling 17.2.0.8 will revert to CA Service Management 17.2.0.1.
Uninstall CA SDM 17.2.0.8 (Windows)
Perform the following steps to uninstall CA SDM 17.2.0.8 on Windows:
  1. Log in to CA SDM as an Administrator.
  2. Shut down CA Service Desk Manager Server.
  3. Navigate to the location
    where you have extracted the
    CA Service Management
    Installer zip package
    .
  4. Locate
    CASM-17.2.0.8-CommonPatchInstaller-Win\filestore\utils\ApplyPTF
    folder.
  5. Run the
    APPLYPTF.exe
  6. Select
    Backout PTF
    from the local or remote node option.
  7. Click
    Next
    .
  8. Enter the
    patch number for the language that is installed in your environment:
    • Binary
      : leh-381_cum_C
    • Language Master
      : leh-381_langcombo
    • English
      : leh-381_en_US
    • French
      : leh-381_fr_FR
    • French Canadian
      : leh-381_fr_CA
    • German
      : leh-381_de_DE
    • Spanish
      :leh-381_es_ES
    • Italian:
      leh-381_it_IT
    • Japanese
      : leh-381_ja_JP
    • Brazilian Portuguese
      : leh-381_pt_BR
    • Simplified Chinese
      : leh-381_zh_CN
  9. Click
    Next
    to continue backing out the specific patch.
  10. Repeat steps 6-9,
    to back out the language English (leh-381_en_US) patch.
  11. Repeat steps 6-9 to back out the language master (leh-381-langcombo) patch.
  12. Repeat steps 6-9 to back out the binary (leh-381_cum_C) patch.
  13. Reboot the server.
  14. Repeat steps 6-12 on all standby, application, or secondary servers in your environment
  15. Restore the MDB database to the database backup that you took before applying the patch.
  16. Navigate to
    NX_ROOT/site/config.properties
    file and ensure that the value of
    resources.created
    parameter is set to
    0.
    This must display as
    resources.created=0
    in the file.
  17. Open a command prompt and run the following command:
    pdm_configure
Uninstall the
xFlow Interface
17.2.0.8 (Windows)
Perform the following steps to uninstall the
xFlow Interface
(Windows):
  1. Click
    Start
    ,
    Control Panel
    ,
    Uninstall a Program
    to uninstall
    xFlow Interface
    17.2.0.8.
    Or
  2. Navigate to where you have installed the
    xFlow Interface
    (for example,
    C:/Program Files/CA/xFlow)
    .
  3. Select
    xFlow Interface
    17.2.0.8_installation
    and click
    Change
    xFlow Interface
    17.2.0.8 Installation.exe
    to complete the uninstallation process.
  4. If you are using Microsoft SQL Server Database, run the following query:
    update ofProperty set propValue='select c.access_token from casm_active_sessions c WHERE UPPER(CONVERT(varchar(32), c.contact_uuid ,2)) = UPPER(?)' where name = 'jdbcAuthProvider.passwordSQL'
  5. If you are using Oracle Database, run the following query;
    update ofProperty set propValue='select c.access_token from casm_active_sessions c WHERE UPPER(CAST( c.contact_uuid AS varchar2(32))) = UPPER(?)' where name = 'jdbcAuthProvider.passwordSQL'
Uninstall CA SDM 17.2.0.8 (Linux)
Perform the following steps to uninstall CA SDM 17.2.0.8 on Linux:
  1. Log in to CA SDM as the root user.
  2. Shut down the CA Service Desk Manager Server.
  3. Navigate to the location where you have extracted the
    xFlow Interface
    Installer tar.gz package.
  4. Navigate to the
    casm_dvd.x86Linux
    \filestore\utils\ApplyPTF
    folder.
  5. The following binary/language-independent and language-dependent patches are supported:
    • Binary name: leh-381_x86Linux_cum_C
    • Language Master: leh-381_langcombo
    • English: leh-381_x86Linux_en_US
    • German: leh-381_x86Linux_de_DE
    • French: leh-381_x86Linux_fr_FR
    • Japanese: leh-381_x86Linux_ja_JP
  6. Execute the following command to remove the binaries or the language-dependent patches. Replace the <patch_name> with the binary or language-dependent patch name: 
    ./applyptf.<platform> -b <patch_name> -e <NX_ROOT>
    Here, <platform> specifies the operating system and <NX_ROOT> specifies the CA SDM installed location.
    For example:
    ./applyptf.linux -b leh-381_x86Linux_cum_C -e /opt/CA/ServiceDeskManager
  7. Repeat step 6
    to back out the language English (leh-381_x86Linux_en_US) patch.
  8. Repeat step
    6 to back out the language master (leh-381_langcombo) patch.
  9. Repeat step 6 to back out the binary (leh-381_x86Linux_cum_C) patch.
  10. To restore MDB database, revert to database backup that you took before applying the patch.
  11. Navigate to
    NX_ROOT/site/config.properties
    file and ensure that the value of
    resources.created
    parameter is set to
    0.
    This must display as
    resources.created=0
    in the file.
  12. Open a command prompt and run the following command:
    pdm_configure
Uninstall the
xFlow Interface
17.2.0.8 (Non-Windows)
To uninstall the
xFlow Interface
, complete the following steps on Linux :
  1. Navigate to where you have installed the
    xFlow Interface
    server.
    For example:
    /opt/CA/_
    xFlow Interface
    _installation
  2. Execute the following command to uninstall the
    xFlow Interface
    17.2.0.8:
    ./Change xFlow_Interface 17.2.0.8 Installation
    To uninstall the base version of
    xFlow Interface
    , enter the following command:
    ./Change xFlow_Interface Installation
  3. Click
    Finish
    to complete the uninstallation process.
  4. Run the following query for Oracle Database:
    update ofProperty set propValue='select c.access_token from casm_active_sessions c WHERE UPPER(CAST( c.contact_uuid AS varchar2(32))) = UPPER(?)' where name = 'jdbcAuthProvider.passwordSQL'
Uninstall CA Service Catalog 17.2.0.8
To uninstall CA Service Catalog, perform the following steps:
  1. Click
    Control Panel
    ,
    Programs and Features
    .
  2. Double-click the CA Service Catalog 17.2.0.8 and follow the uninstallation wizard instructions.
Run the Database Cleanup Utility for
CA Service Management
17.2.0.8
During the installation of
CA Service Management
products, each of the installed product is registered in a common mdb table that is reflected in the deployment summary of the selected environment. These entries must be cleared in the following cases:
  • Uninstallation of any
    CA Service Management
    products
  • Moving Database or migration from one server to another
Run the
CA Service Management
database cleanup utility on a Windows or a Non-Windows environment. The database cleanup utility removes the entries and adds to the following tables:
Table Name from where the entries are removed
Table Name to which the removed entries are added
al_cdb_componentinstallstate
al_cdb_comp_installstate_bkup
al_cdb_configurationparameters
al_cdb_config_params_backup
On a Non-Windows Platform, before running the
DBCleanup.sh
Utility, you must export the Oracle Environment variables on the terminal.
Perform the following steps:
  1. Navigate to
    DVD1\DBCleanupUtility
    directory.
  2. For Windows, double-click the
    DBCleanupUtility.bat
    to launch the DBCleanup utility.
    On a Non-Windows platform, you must run the
    DBCleanupUtility.sh
    file.
  3. Enter the following details:
    1. Database Server Type
      : Specify the type of server. Microsoft SQL or Oracle.
    2. Database Host Name:
      Enter the host name of the server where the database resides.
    3. Database User Name
      :
      • SQL Server
        : Enter the privileged user detail that has permission to create and modify the schema.
      • Oracle
        :  Provide the mdbadmin user name.
    4. Database Password
      :
      • MS SQL
        : Enter the database password used by the database admin user.
      • Oracle
        : Enter the password for the Oracle database user.
    5. Database Port Number:
      Provide the database port number.
    6. Enter Database Name
      :
      Enter the database name. For example, mdb.
    7. System Name
      : Provide the host name of the system from where you want to uninstall the
      CA Service Management
      product or products.
  4. Select any of the following products that you want to uninstall:
    • SDM -
      CA Service Desk Manager
    • SLCM-
      CA Service Catalog
    • xFlow Interface
    • ProductUpdates
      Enter product name to be uninstalled:
      ProductUpdates
  5. Enter product to clean up updates:(sdm,slcm,xflow,uss,chatserver,searchserver): For example, slcm
  6. Enter update version to clean up: 17.2.0.8
  7. The utility cleans up the database and removes the entries of the selected product installed on the server.