DWP - Updating AR Server References in DWP | Remedy Application Password changed - INCLUDES VIDEO

Version 14
    Share This:

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


    PRODUCT:

    MyIT Digital Workplace


    APPLIES TO:

    DWP A 18.05 and beyond Don't use when: DWP 18.02 and older SmartIT (any)



    DETAILS:



    NOTE - PLEASE READ THIS BEFORE PROCEEDING

     

       
    • For SmartIT 18.00 and beyond check KA - 000130901
    •  
    • Take DB snapshot prior modifying anything at a database level.
    •  
    • You need to update the below values in the new environment.
    •  
    • This is also useful when just upgrading AR Server references
    •  
    • Remedy Application Service password was change and now you are getting 623 Authentication Failed error.
    •  
    • If SSL is in place, new certs having new dns, hosts, ip addresses, aliases, etc. must be created.
      



    USE CASE 1) Remedy Application password was changed and needs to be encrypted

    Encrypting Remedy Application Password

    If the Remedy Application Password was changed, then password has to be encrypted and updated in the database.  
       
    • If you don't have the SmartIT Maintenance Utility handy, log onto EPD and download SmartIT which contains the utility.
              Go the the Smart IT Maintenance Tool location 
               <SmartIT Installdirectory>/SmartIT/SmartITMaintTool/SmartIT Maintenance Tool/
       
       
    1.     Windows: Right Click, run that as an administrator -> click on encrypt tab -> encrypt the password
    2.  
    3.     Linux: sh SmartITMaintenanceTool.sh
      
      User-added image 
      
      
      Save that encrypted string as you will need it for the next steps mentioned in   USE CASE 2) DWP - Cloning and Restoring DWP Environments | Updating AR Server References
      

    USE CASE 2) DWP - Cloning and Restoring DWP Environments | Updating AR Server References

    These steps can be used when:  
       
    • You need to change AR Server/Database References references in DWP
    •  
    • When cloning  DWP environments
    •  
    • You only need to change Remedy Application System
    •  
    • You only need to change Remedy Port
    •  
    • You only need to change Remedy Hostname/Load Balancer
    •  
    • All of the above
      

    A) DWP Tomcat Side
       
      1) Edit the below files and point them to the new host and db --if needed  
      
      
       
    •  /opt/apache/tomcat8.5/conf/Catalina/localhost/dwp.xml
    •  
    • /opt/apache/tomcat8.5/conf/Catalina/localhost/social.xml  
      
               
     
                 Update SQL/Oracle database details as needed
       
      2) Edit the below file 
          
       
    • /opt/apache/tomcat8.5/external-conf/connect-dwp.properties
                   You should be able to see a few lines like this at the bottom:  
        
      
      api.token *user the same for all your DWP Servers*                                        
     
      Update as needed
      

      B) SQL/ORACLE Side
      
       
      Check that the  DWP database has the new/right AR Server Name/Port/Password references.  
     
    If not, update: 
      
      
            1) Updating AR Server
       
       
    1. Select * from DWP_Business.CONFIGURATION_PARAMS where KEY_NAME ='connect.arsystem.hostName' and VALUE = <Primary AR server name>  --this one is to check what the actual value is
    2.  
    3. update DWP_Business.CONFIGURATION_PARAMS SET VALUE= <AR LB Name> where KEY_NAME ='connect.arsystem.hostName' and VALUE = <Primary AR server name> -- this is how you fix it
      
       
      2) Updating AR Server Port
      
       
    1. Select * from DWP_Business.CONFIGURATION_PARAMS where KEY_NAME ='connect.arsystem.port'   
    2.  
    3. update DWP_Business.CONFIGURATION_PARAMS SET VALUE = <AR LB Port Number> where KEY_NAME ='connect.arsystem.port' and VALUE = <Primary AR Port> -- this is how you fix it
      
      
              3) Updating Remedy Application System Password
       
       
    1.     Select * from DWP_Business.CONFIGURATION_PARAMS where KEY_NAME ='connect.arsystem.password' and VALUE = <password> --this one is to check what the actual value is
    2.  
    3.     update DWP_Business.CONFIGURATION_PARAMS SET VALUE = <new password> where KEY_NAME ='connect.arsystem.password' and VALUE = <password> -- this is how you fix it
       
       4) Do the same for DWP_System.PROVIDER_SETTINGS , use the queries above for a reference.
       
       
    1.  update DWP_System.PROVIDER_SETTINGS  SET VALUE= 'value'  where KEYNAME ='connect.arsystem.hostName'
    2.  
    3. update DWP_System.PROVIDER_SETTINGS  SET VALUE = 'value'   where KEYNAME ='connect.arsystem.port'
    4.  
    5. update DWP_System.PROVIDER_SETTINGS  SET VALUE = 'value'         where KEYNAME ='connect.arsystem.password'
    6.  
    7. update DWP_System.PROVIDER_SETTINGS  SET VALUE = 'value'   where KEYNAME ='mid_tier.base.url'
      
        
      
            
    C) DWP Admin Console Side
       
      Update the Pluggable Providers under:  
     
      /dwp/admin/configuration/features.html
     
     
    With the right AR Server, port and credentials where needed. 
      
      
    D) Mobile Apps
       
      If you are using mobile apps on your cloned environment, make sure to update the info.plist if needed  
      https://docs.bmc.com/docs/display/dwpbas18011/Deploying+clients
      
      
      
    E) RSSO
       
      You  also need to edit RSSO agents files and update the rsso-agent.properties with the new RSSO Server URL, sso-sdk.properties with the   ignore-tenant=true.
      
     
      Files location: 
      <apache install directory>/external-conf/
      


    NOTE: If anything was updated, please restart Tomcat for the changes to take effect. 


    Confirm everything's working, if not. Collect the below logs in debug mode and reach out to BMC Support.  
       
    • DWP: dwp.log
    •  
    • Tomcat: all current logs.
      

     


    Article Number:

    000280932


    Article Type:

    Product/Service Description



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