This documentation supports the 9.1 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

If you have not already done so, plan the BMC Remedy Smart Reporting deployment. BMC recommends that you do not install BMC Remedy Smart Reporting and BMC Remedy AR System Server on the same computer.

Note

You must perform the user onboarding process from BMC Remedy AR System to BMC Remedy Smart Reporting only after BMC Remedy ITSM installation. 

Before you begin

Before you perform the installation, consider the following:

  • Ensure that the machine on which you are installing this component meets the following requirements:
    • Java version 8 update 45 or later is installed

    • Terminal server configuration is completed
  • 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  

To configure 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 for installation of the Smart Reporting database on 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:

    SQL> create tablespace reporting datafile 'reporting' size 500M reuse autoextend on
    
    SQL> create user repadmin identified by RP#Admin# default tablespace reporting;
    
    SQL > grant unlimited tablespace to repadmin;
    
    SQL> create role RRole not identified;
    
    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;
    
    SQL> grant RRole to repadmin;

Preparing for installation of the BMC Remedy Smart Reporting database on 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.

DB creation preferenceUserPre-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

  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. Right-click the newly created user, under Owned Schemas and Database role membership, select db_owner .
    5. Click OK

    Or,
    Right-click the newly created database, click New Query, and run the following command:

    # Creates the login <username> with password '<password>'.
    CREATE LOGIN <username> 
    WITH PASSWORD = '<password>';
    GO
    # Creates a database user for the login created above.
    CREATE USER <username> FOR LOGIN <username>;
    GO

To install BMC Remedy Smart Reporting with an external Tomcat

Note

BMC recommends you to use Tomcat version 8.0.35 for external Tomcat.

  1. You must update the context.xml file.
    1. Go to <external tomcat installation directory>\conf\ context.xml.
      1. 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


    2. 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. David k Hill

    In the Note: BMC recommends you to use Tomcat version 8.0.35 for external Tomcat. Is that 8.0.35 or greater or just 8.0.35 only?

    I'm goin got assume 8.0.35 or greater.

    Oct 16, 2018 12:27
    1. Ashwini Mathad

      BMC has tested and certified only 8.0.35 version for external Tomcat.

      Oct 23, 2018 06:05