Remedy Smart Reporting - repoint or connect to a cloned AR/ITSM Server

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 AR System Server


    COMPONENT:

    Smart Reporting Remedy


    APPLIES TO:

    9.1.x



    PROBLEM:

    Cloning AR/ITSM Production Servers and repoint/connect smart reporting to cloned AR/ITSM server.


    SOLUTION:

    Steps needed to perform when refreshing a lower environment from production
     

       
    • Verify SmartReportingServer_Info form
       
       
    • Make sure that BMC Remedy Smart Reporting service is running.  
    •  
    • Log on to BMC Remedy AR System server.
    •  
    • Open the SmartReportingServer_Info form, and verify that the following variables values are defined:     
           
      • Reporting Server Host Name
      •    
      • Reporting Server Port
      •    
      • Reporting Server Admin Name
      •    
      • Reporting Server Admin Password
      •    
      • Reporting Server OrgName
      •    
      • Tenancy Type
      •   
      

       
       
    • Verify UDM:Variable form
      
       
    • Make sure that BMC Remedy Smart Reporting service is running.  
    •  
    • Log on to BMC Remedy AR System server.
    •  
    • Open the UDM:Variable form, and verify that the following variables values are defined:     
           
      • BMC_AR_SERVER_HOST_NAME
      •    
      • BMC_AR_PORT
      •    
      • BMC_AR_USER
      •    
      • BMC_AR_PASSWORD
      •   
      
       
       
    • Kindly follow below steps if your Smart Reporting Repository database has been moved to new server:

      1. Stop the Remedy Smart Reporting service
      2. Go to Web.xml in the path: C:\Program Files\BMC Software\ARSystem\SmartReporting\appserver\webapps\ROOT\WEB-INF\web.xml
      3. Edit the file and search for following parameter "JDBCUrl" in web.xml
      4. Provide the new host name in the following URL :  <param-value>jdbc:jtds:sqlserver://DatabaseHostName:Port/ARSystem</param-value>
      5. Verify the Database user name : <param-name>JDBCUser</param-name>  <param-value>ARAdmin</param-value>
      6. Verify the Database password:  <param-name>JDBCPassword</param-name> <param-value>03Std5z/BjK1XsH7KXtHkg==</param-value>
      7. Restart the Smart Reporting services.
      
       
       
    • Verify ReportViewSource and ReportViewSourceParameter in Smart Reporting Repository Database:
      
    There are two Database tables which contains the hostname entry :   ReportViewSource and ReportViewSourceParameter
       
       
    •  
      
    select * from ReportViewSource
      
    >> This will return the data source information , note that this may contain more than one value, in case onboarding executed more than once. But depends onto the IpOrg column value one can get the currently used Ogranisation (Client Organization), also note the SourceID which is required in subsequent table update
      
    Update ReportViewSource
    set DatabaseURL = 'jdbc:arserver://clm-pun-015622:0;refreshCache=10;DateTimeFormat=MM/dd/yyyy hh:mm:ss a;DateFormat=yyyy-MM-dd;'
    where IpOrg = 12013
      
       
       
    •  
      
    select * from ReportViewSourceParameter
      
    >> This will return the SourceID value, select the source id for the currently used organisation
      
    update ReportViewSourceParameter
    set ParameterValue = 'clm-pun-015622'
    where SourceId = 59005 and ParameterKey = 'HOSTNAME'
      
    [Run the update queries for the single record [IpOrg] first and once you confirm on update from UI console, proceed with full update ]
       
       
    1. Stop the reporting services
    2.  
    3. Run the above mentioned update commands by selecting the current values
    4.  
    5. Start the reporting services
    6.  
    7. Login to  Smart Reporting server and check the AR Connection details
       
       
    • Updating cross launch settings
       
       
    • On the BMC Remedy Smart Reporting console, choose Administration > Configuration.
    •  
    • Choose System > Custom Parameters.
    •  
    • Update the custom parameters for AR Server with AR Server host name.
      
      

     


    Article Number:

    000120856


    Article Type:

    Solutions to a Product Problem



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