This documentation supports the 9.0 version of BMC Remedy ITSM Deployment.

To view the latest version, select the version from the Product version menu.

Preparing to install BMC Remedy Smart Reporting

Before you begin

Before you perform the installation, consider the following:

  • Only a fresh installation of BMC Remedy Smart Reporting is available.
  • BMC recommends that you install BMC Remedy Smart Reporting and BMC Remedy AR System Server on different machines.
  • You must onboard BMC Remedy Smart Reporting only after BMC Remedy ITSM.
  • Ensure that the machine on which you are installing this component meets the following requirements:
    • Java JRE version 7.0u55 or later is installed

      Note

      With Service pack 1 and later Java SE 8_u45 and higher is supported. Older versions are not supported.

    • Terminal server configuration is completed
  • Ports: Ensure that your firewall does not block the following ports:
    • Default port 8181 used by Smart Reporting
    • Default SQL Server port 1433  
    • Default Oracle Server port 1521

Configuring the terminal server (Windows only)

  1. Go to Start > Run.
  2. In the Run dialog box, enter gpedit.msc, and press Enter.
  3. Choose Computer Configuration > Administrative Templates > Windows Components > Remote Desktop Services > Remote Desktop Session Host > Temporary Folders.
  4. Enable the following options:
    1. Do not Delete temp folder on Exit
    2. Do not use temp folder per session
  5. Restart the system.
  6. If the settings are not enabled:
    1. Choose Start > Run.
    2. In the Run dialog box, enter regedit and press Enter.
    3. In the Registry Editor, navigate to HKEY_LOCAL_MACHINE\SYSTEMCurrentControlSet\Control\Terminal Server and update the PerSessionTempDir and DeleteTempDir OnExit options to 0.
    4. Restart the system.

Preparing your Smart Reporting database 

Oracle

You must create a database user prior to Smart Reporting installation.

To create a database user (Oracle)

  1. Login to the Oracle db as an Administrator. 
  2. In the SQL prompt, execute the following commands:
    1. SQL> create tablespace reporting datafile 'reporting' size 500M reuse autoextend on
    2. SQL> create user repadmin identified by RP#Admin# default tablespace reporting;
    3. SQL > grant unlimited tablespace to repadmin;
    4. SQL> create role RRole not identified;
    5. SQL > grant CREATE SESSION, alter session, create cluster, create database link, create sequence,create trigger, query rewrite, create synonym, create table, create view, create procedure to RRole;
    6. SQL> grant RRole to repadmin;

MS SQL

When running the Smart Reporting installer, you encounter the following panel:

The following table lists the possible combinations that result from the selections you make on the panel.

DatabaseUserPre-requisitesSQL Server AuthenticationWindows Authentication
New DBNew userInstaller creates the database and the user. DBA credentials are required.SupportedNot supported
Existing DBExisting userValid DB and user must be available. DB must be clean. DBA credentials are not required.SupportedSupported
New DBExisting userInstaller creates the database. DBA credentials are required to create a new DB from the installer. Valid user must be available.SupportedSupported
Existing DBNew userValid DB must be available. Installer creates a new user. DBA credentials are required. SupportedNot supported

To add a pre-created database and user

Follow these steps if you want to use existing database and it's user. 

  1. Login to the MS SQL server database, as an Administrator.
  2. Create the new database: 
    1. In the Object List right-click Databases
    2. Click New Databases
    3. Enter the database name. 
    4. Click OK. The database will get created.
    Or run the following command in the master DB query panel: 
    create database < database name> 
  3. Create the user and give the permissions for the new database you created. 
    1. In the Object List click Security > Logins.
    2. Right-click Logins and click New Login.
    3. Enter the details of the new user.
    4. Give the permissions for the new database you created.
    Or run the following command:

    # Creates the login <username> with password '<password>'.
    CREATE LOGIN <username>
    WITH PASSWORD = '3<password>';
    GO

    # Creates a database user for the login created above.
    CREATE USER <username> FOR LOGIN <username>;
    GO

To install with external tomcat 

  1. You must update the context.xml file.
    1. Go to <external tomcat installation directory>\conf\ context.xml.
    2. Set the xmlBlockExternal to false in the Context parameter. For example:

      <Context xmlBlockExternal="false">

      Adding a new Context xmlBlockExternal tag is not recommended. You must update the existing tag as shown in the table below.

      Before updatingRecommendedTo be avoided


    3. Save the file.
  2. If you have installed the external tomcat as a service you must set the java heap size as following:
    • Minimum: 1024
    • Maximum: 2048 
  3. Proceed with the installation.

Related Topics

Installing BMC Remedy Smart Reporting

Hardware requirements

Was this page helpful? Yes No Submitting... Thank you

Comments

  1. Nas Remedy

    Under section Before You Begin

    • terminal server configuration is completed

    Is this option for Window Server Installation or Unix as well?

    The  steps provided are for Windows installer, please add the steps for Unix installation as well. If not required for unix systems then please add a Note.

    Thanks

    Jun 11, 2015 03:50
    1. Hemant Baliwala

      Hi Nas,

      Thanks for your comment. I am working with the SME to update this topic.

      Regards,

      Hemant

      Jun 15, 2015 03:36
    1. Hemant Baliwala

       Hi Nas,

      This setting is only for Windows. I have updated the heading.

      Thanks,

      Hemant

      Jun 17, 2015 03:18
  2. Sandeep Das

    Please add steps for pre-creating the database for MS SQL Server? This page only has limited information for Oracle DB and no information for MS SQL Server.

    The URL below only has information for ARSystem.

    https://docs.bmc.com/docs/display/public/brid90/Configuring+the+Microsoft+SQL+Server

     

     

     

    Sep 29, 2015 10:31
    1. Hemant Baliwala

      Hi Sandeep, 

      Thanks for your comment. 

      I have updated the topic. 

      Regards, 

      Hemant

      Oct 05, 2015 01:56
      1. Sandeep Das

        Thanks Hemant. This is a good start. But for sake of consistency, actual SQL commands will be better and unambiguous (similar to the steps for Oracle). Also, it would be really useful if recommended DB settings are provided. 

        For example, I was getting timeout errors during the AR Server install and turned out it was the default timeout setting on the DB (10 mins) that was resulting in an ARERR 90 during the install. Increasing the timeout fixed the issue.

         

        Oct 05, 2015 05:28
  3. Hemant Baliwala

    Hi Sandeep, 

    Thanks for your suggestions. I have added the SQL commands. For more examples, please refer to the SQL documentation. 

    Also, DB settings are not available right now. I am following up with the team. 

    Regards, 

    Hemant

    Oct 12, 2015 01:19
  4. Adriana Linde

    Hello!

    Under the section "Before you Begin", the third step specifies:

    • It is recommended that you install BMC Remedy Smart Reporting before BMC Remedy ITSM installation.

     

    However, if you download this doc as PDF, the same step specifies that:

    • You must install BMC Remedy Smart Reporting only after BMC Remedy ITSM installation.

     

    So, what product I must install first?

    Thanks!

    Nov 17, 2015 03:34
  5. Josh Hester

    For Oracle database, can you create a new database report user on the existing AR system database, or do you need to create an entirely new database for the smart reporting application?

    Jun 02, 2016 12:03
    1. Amit Durgapal

      Hello Josh,

      You can create a new database or use the existing AR System database. But, we recommend creating a separate database for Smart Reporting.

      Regards,

      Amit 

      Jun 03, 2016 05:16
  6. Henrik Hauchwitz

    The artice states to set the table space size to 500M with autoextension enabled. Our database team doesn't want the table space to grow automatically, so I'd like to know if there is a recommendation/estimation about the size that is necessary.

    Maybe you could also tell me what kind of data is stored in the database, so that we can estimate the capacity.

    Sep 08, 2017 06:50
    1. Sirisha Dabiru

      Hi Henrik Hauchwitz,

      I will check and get back to you.


      Regards,

      Sirisha

      Oct 18, 2017 04:10
    1. Sirisha Dabiru

      Hi Henrik Hauchwitz,

      Here is the response for your comments:

      CommentResponse

      The artice states to set the table space size to 500M with autoextension enabled. Our database team doesn't want the table space to grow automatically, so I'd like to know if there is a recommendation/estimation about the size that is necessary.

      There is no specific recommendation as the table space size keeps on increasing. based on the size of the reports data.

      Maybe you could also tell me what kind of data is stored in the database, so that we can estimate the capacity.

      All tables and data of Smart Reporting are stored in the repository.

      Regards,

      Sirisha

      Mar 20, 2019 06:49