How To Migrate\Refresh Repository Database From PROD\High To DEV\Low Environments In SmartReporting?

Version 2
    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:

    ITSM In-App Reporting


    APPLIES TO:

    BMC Remedy Smart Reporting 9.1



    PROBLEM:

     

       
    • Migrate the PROD database for Remedy and Smart Reporting to QA database.
    •  
    • The Smart Reporting configuration table contains information about the data source for production.
    •  
    • The multi-tenant clients data sources of QA environment are pointing to production.

     


    SOLUTION:

     

      Verify ReportViewSource and ReportViewSourceParameter tables in Smart Reporting Repository Database: 
      
        
      
       
    • There are two Database tables which contains the host name 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 on-boarding is executed more than once.
    •  
    • However, it depends onto the IpOrg column value. One can get the currently used Organization (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

     


    Article Number:

    000119790


    Article Type:

    Solutions to a Product Problem



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