Remedy Smart Reporting What are the Configuration Changes Required Post Repository Database Migration from One Environment to Other

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

    Smart Reporting All versions



    QUESTION:

    What are the Configuration Changes Required when Smart Reporting Repository Database is copied from one to environment to other?


    ANSWER:

    Most of the Smart Reporting Configuration details are stored in its Repository Database. Below are the places where configuration changes are required post database refresh on the Smart Reporting UI and AR System forms:


    1. Onboarded company name should be the same in all the environments. If not, correct it by logging into siadmin console>Administration>Client Organizations

    User-added image

    2. The Clientorg name in step1 should match with 'Reporting Server OrgName' on SmartReportingServer_Info form.

    User-added image

    3. SmartReportingConfig table has onboarded AR server hostname/port number. Update the AR Hostname in the table post DB migration using below KB:

    https://communities.bmc.com/docs/DOC-108594

    4. The data source information is also stored in Smart Reporting database.  Change the AR server host name in the data source connection details under Administration>AdminConsole>ARSystem Data Source.

    User-added image



    - If Hyperlinks or Share reports are used, then it is required to update the custom parameters configuration:

    https://docs.bmc.com/docs/itsm91/updating-cross-launch-settings-608491112.html


     


    Article Number:

    000223757


    Article Type:

    FAQ/Procedural



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