Installation and Upgrade Guides › Policy Server Installation Guide › Installing Reports › How to Install the Report Server

How to Install the Report Server

Complete the following procedures to install the Report Server:

1. Review the installation checklists.
2. Gather information for the installer.
3. Install the Report Server.

Gather Information for the Installer

Review the following sections to identify the information required by the Report Server installer.

Installation Credentials

Depending on the operating system to which you are installing, the installer requires one or more sets of credentials:

• (Windows and UNIX) BusinessObjects Administrator password

  The installer creates a default SAP BusinessObjects Enterprise administrator account (administrator). You use this account to import CA SiteMinder® report templates and to access the BusinessObjects Content Management Console. Determine the password for this account.

  The password must meet the following composition criteria:

  • The password must include at least six characters.
  • The password cannot contain the word "administrator" in any form.
  • The password must include at least two of the following character types:
    • Uppercase characters
    • Lowercase characters
    • Numerals
    • Punctuation
• (UNIX) Non–root user account—You require a root–user account to start the installation and a non–root user account to complete the installation. Identify the non–root user account:
  • User name
  • Group name

MySQL Report Database

If you are using the embedded version of MySQL to function as the report database, the installer requires specific information. Use the report database installation worksheet to gather the following information before starting the installation:

• MySQL root password

  The password for the MySQL root user account.

  Note: You cannot change the name of the root user account. The installer defaults the name to root.

• User

  The name of the report database administrator account.

  Installer default: sa

• Password

  The password of the report database administrator account.

SQLAnywhere Report Database

If you want to use the embedded version of SQLAnywhere to function as the report database, the installer requires specific information. Use the report database installation worksheet to gather the following information before starting the installation:

• SQLAnywhere root password

  The password for the SQLAnywhere root user account.

  Note: You cannot change the name of the root user account. The installer defaults the name to root.

• User

  The name of the report database administrator account.

  Installer default: sa

• Password

  The password of the report database administrator account.

Microsoft SQL Server Report Database

If you are using Microsoft SQL Server to function as the report database, the installer requires specific information. Use the report database installation worksheet to gather the following information before starting the installation:

• Data Source Name (DSN)

  The DSN that Report Server is to use to communicate with the report database.

  Note: The Report Server is compiled as 32–bit native binary and is designed to use 32–bit data source middleware connectivity. If you are installing to a Windows 64–bit operating system, be sure to create the DSN using odbcad32.exe. This executable is located in the following location:

  install_home\Windows\SysWOW64.
  

  install_home

  Specifies the installation path of the Windows operating system.

• Login ID

  The name of the report database administrator account. This account must have the default (DBO) account permissions.

• Password

  The password of the report database administrator account.

Oracle Report Database

If you are using Oracle to function as the report database, the installer requires specific information. Use the report database installation worksheet to gather the following information before starting the installation:

• Oracle Net Client Service name

  The service name that the Report Server is to use to communicate with the report database.

  • (Windows) The installer refers to the Oracle Net Client Service name as Server.
  • (UNIX) The installer refers to the Oracle Net Client Service name as TNSNAME.
• User name

  The name of the report database administrator account. This account must have the following privileges:

  • create session
  • create table
  • create procedure

  Note: You can also use an administrator account with the CONNECT and RESOURCE roles enabled. Be sure to disable the Admin Option setting for both roles.

• Password

  The password of the report database administrator account.

Apache Tomcat Installation

CA SiteMinder® only supports the version of Apache Tomcat that is embedded with the Report Server installation. Use the web application installation worksheet to gather the following information before starting the installation:

• Connection port

  The port to which Apache Tomcat is to connect and wait for requests.

  Installer default: 8080

• Redirect port

  Identify the port to which Apache Tomcat must redirect requests.

  Installer default: 8443

• Shutdown port

  The port to which the Apache Tomcat SHUTDOWN command must be issued.

  Installer default: 8005

Install the Report Server

The following sections detail how to install the Report Server on Windows and UNIX.

Before You Install

Consider the following items before you install the Report Server:

• Installing the Report Server on a host system with any other CA SiteMinder® component is not supported. Be sure to install the Report Server on a separate host system.
• You install the Report Server using the installation media on the Technical Support site.

  Note: For a list of installation media names, see the Policy Server Release Notes.

• The Report Server is compiled as 32–bit native binary and is designed to use 32–bit data source middleware connectivity. If you are installing to a Windows 64–bit operating system, be sure to create the DSN using odbcad32.exe. This executable is located in the following location:

  install_home\Windows\SysWOW64.
  

  install_home

  Specifies the installation path of the Windows operating system.

• A UNIX console installation is not supported.
• The Report Server installation includes the following components that run as processes:
  • The Content Management Server
  • The Server Intelligence Agent

  These components require TCP/IP ports to communicate. The installer lets you modify the default settings to prevent port conflicts on the Report Server host system.

• Important! The installation zip contains multiple folders. The installer executable requires this folder structure. If you moved the Report Server installer after extracting the zip, copy the entire folder structure to the same location. Execute the installation media from this folder structure.
• Important! (UNIX) The user account installing the Report Server must have executable permissions on the directory that contains the installation media. If the user account does not have these permissions, run the following command:

  chmod -R+x directory
  

  directory

  Specifies the directory that contains the installation media.

• (UNIX) If you execute the Report Server installer across different subnets, it can crash. Install the Report Server directly on the host system.
• (UNIX) Before you install the Report Server on an RHEL 6 machine, ensure that you complete the following tasks on the RHEL 6 machine:
  • Install the following RPMs:
    • ncurses-libs.i686
    • Compat-libstdc++-33.3.3-69.el6.i686
    • libXext-1.1-3.el6.i686
    • libXext-devel-1.1-3.el6.i686
    • ncurses-base
    • ncurses-libs 5.9-7.20121017
    • xorg-x11-libX11-7.6-23.1.2.i586
    • xorg-x11-libXau-7.6_1.0.6-9.1.1.i586
    • xorg-x11-libxcb-7.6_1.7-8.1.i586
  • Set the LD_LIBRARY_PATH environment variable to the location of the 32-bit libncurses.so.5 library.

More information:

Locate the Installation Media

Windows

Follow these steps:

1. Be sure that you have reviewed the installation checklists.
2. Be sure that you have gathered the required information for the installer.
3. Exit all applications that are running.
4. Double–click installation_media.

   installation_media

   Specifies the Report Server installation executable.

   The CA Business Intelligence installation wizard appears and prompts you for a locale.

   Note: For a list of installation media names, see the Policy Server Release Notes.

5. Select English and click OK.

   The installer introduction appears.

6. Click Next.

   The CA license agreement appears.

7. Accept the license agreement and click Next.

   The installer prompts you to install CA sample templates.

8. Select No and click Next.

   Note: CA sample templates are not related to the CA SiteMinder® reporting templates. The CA SiteMinder® Report Server Configuration wizard installs the required reporting templates. You run the wizard after installing the Report Server.

   The installer prompts you to save a response file for a silent installation.

9. Select Yes and click Next.

   An installation summary appears.

10. Review the summary and click Install.

    The installer installs the components. The CA Business Intelligence Setup wizard appears.

11. Click Next.

    The installer introduction appears.

12. Click Next.

    The SAP BusinessObjects Enterprise license agreement appears.

13. Accept the license agreement and click Next.

    The installer prompts you to select language packs. English is selected by default.

14. Leave the default English setting and click next.

    The installer prompts you for an installation type.

15. Select New and do one of the following steps to configure the report (CMS) database:
    • (Recommended) To install the embedded version of MySQL, select Install MySQL Database Server and click Next.
    • To configure an existing Microsoft SQL Server or Oracle database, select Use an existing database server and click Next.

      The installer prompts you for the Content Management Server port and the password for the SAP BusinessObjects Enterprise administrator account.

16. Complete the following steps:
    1. Specify the port on which the Content Management Server must listen.
    2. Specify a password for the default SAP BusinessObjects Enterprise administrator.

       Important! Do not select Configure the SAP BusinessObjects Enterprise Administrator password at a later time.

    3. Click Next.

       The installer prompts you for the Server Intelligence Agent node name and port.

17. Specify a node name and port. Click Next.

    The installer prompts you to configure the report (CMS) database.

    Important! The Report Server is a CA common component that CA products can share. As such, the installer lets you configure the report database to database types and versions that other products support, but CA SiteMinder® does not. For a list of supported database types and versions, see the CA SiteMinder® 12.51 Platform Support Matrix.

18. Do one of the following steps:
    • (Recommended) If you are configuring MySQL, enter the password for the root user account and the report database administrator credentials.
    • If you are configuring Microsoft SQL Server:
      1. Select SQL Server (ODBC) and click Browse to open the SQL Server Logon screen.
      2. Select a DSN and enter administrator credentials.

         Note: If you are installing on a 64-bit version of Windows, select Consume DSN created under WOW64. The option lets you use a 32–bit DSN.

      3. Click OK.
    • If you are configuring Oracle, enter the required values for the service name and the administrator credentials.

      Note: Do not configure an Auditing Database. This component is not related to CA SiteMinder® audit–based reports. The Content Management Server Auditing Database is used to audit activities specific to the Report Server and is not used for CA SiteMinder®. A CA SiteMinder® audit database is required to run audit–based reports.

19. Click Next.

    The installer prompts you to select a web application server.

20. Complete the following steps:
    1. Select Install Tomcat application server and deploy to it.

       Note: CA SiteMinder® only supports the embedded version of Apache Tomcat.

    2. Clear the IIS Web Application Server option.
    3. Click Next.

       The installer prompts you for Apache Tomcat information.

21. Enter the Apache Tomcat ports and click Next.

    The installer prompts you to start the installation.

22. Click Next to start the installation.

    The installer prompts you when the installation is complete.

23. Clear the Launch SAP BusinessObjects Administration Console option and click Finish.

    The Report Server is installed.

More information:

Installation Media Names

UNIX

Follow these steps:

1. Be sure that you have reviewed the installation checklists.
2. Be sure that you have gathered the required information for the installer.
3. Be sure to start the installation using a root user account.
4. Exit all applications that are running.
5. Open a Bourne shell and navigate to the installation media.
6. Enter the following command:

   ./installation_media -i console
   

   installation_media

   Specifies the Report Server installation executable.

   The CA Business Intelligence installer starts and prompts you for a locale.

   Note: For a list of installation media names, see the Policy Server Release Notes.

7. Type the value for English and press Enter.

   The installer introduction appears.

8. Press Enter.

   The CA license agreement appears.

9. Complete the following steps:
   1. Press Enter to advance the license agreement.
   2. Type y to accept the license agreement.
   3. Press Enter.

   The installer prompts you for non–root user credentials.

10. Type the user name and group name and press Enter.

    The installer prompts you to specify the path to the CA Shared Components directory.

11. Leave the default value and press Enter.

    The installer prompts you to install CA sample templates.

12. Type N and press Enter.

    Note: CA sample templates are not related to the CA SiteMinder® reporting templates. The CA SiteMinder® Report Server Configuration wizard installs the required reporting templates. You run the wizard after installing the Report Server.

    The installer prompts you to save a response file for a silent installation.

13. Type Y and press Enter.

    An installation summary appears.

14. Review the summary and press Enter.

    The installer installs the components. The SAP BusinessObjects Enterprise installer prompts you to select an installation language.

15. Select English and press Enter.

    The SAP BusinessObjects Enterprise license agreement appears.

16. Press y to accept the license agreement.

    The installer prompts you enter the Report Server installation directory.

17. Press Tab to auto–complete the default setting and press Enter.

    The installer prompts you to select language packs. English is selected by default.

18. Leave the default and press Enter.

    The installer prompts you for an installation type.

19. Select User – Regular SAP BusinessObjects Enterprise installation and press Enter.

    The installer prompts you for an installation type.

20. Select New and press Enter.

    Note: Do not clear the Enable servers after installation option.

    The installer prompts you for the Content Management Server port and the password for the SAP BusinessObjects Enterprise administrator account.

21. Complete the following steps:
    1. Specify the port to which the Content Management Server must connect and listen for requests.
    2. Specify a password for the default SAP BusinessObjects Enterprise administrator.
    3. Press Enter.

    The installer prompts you to select the type of database that is to function as the report (CMS) database.

22. Complete one of the following steps:
    • (Recommended) To install the embedded version of MySQL, select Install MySQL and press Enter.
    • To configure an existing Oracle database, select Use an existing database server and press Enter.
    • (RHEL 6) To install SQLAnywhere, select Install SQLAnywhere and press Enter.

    Important! The Report Server is a CA common component that CA products can share. As such, the installer lets you configure the report database to database types and versions that other products support, but CA SiteMinder® does not. For a list of supported database types and versions, see the CA SiteMinder® 12.51 Platform Support Matrix.

    The installer prompts for additional report database information.

23. Complete one of the following steps:
    • (MySQL/SQLAnywhere) Enter the required values for the root user account and the report database administrator credentials.
    • (Oracle) Complete the steps:
      1. Select Oracle and press Enter.

         The installer prompts for database information.

      2. Type the service name and administrator credentials.
24. Press Enter.
    • If you are installing the embedded version of MySQL, the installer prompts you for Auditing Database information.
    • If you are configuring Oracle, the installer prompts you to install the Auditing Database.

      The Auditing Database is not related to CA SiteMinder® audit–based reports. The Content Management Server Auditing Database is used to audit activities specific to the Report Server and is not used for CA SiteMinder®. A CA SiteMinder® audit database is required to run audit–based reports.

25. Complete one of the steps:
    • (MySQL/SQLAnywhere) Accept the defaults and press Enter.
    • (Oracle) Complete the following steps:
      1. Select the Do not install Auditing Database option.
      2. Press Enter.

         The installer prompts you to reinitialize the database.

      3. Select Yes and press Enter.

    The installer prompts you for a Service Intelligence Agent node name and port.

26. Type a node name and port and press Enter.

    The installer prompts you to select a web application server.

27. Select the Install Tomcat deploy web applications option.

    Note: CA SiteMinder® only supports the embedded version of Apache Tomcat.

    The installer prompts you for Apache Tomcat ports.

28. Type the required Apache Tomcat port information and press Enter.

    The installer displays the path of the installation directory.

29. Press Enter to start the installation.

    The installer displays the installation progress and confirms when the installation is complete.

30. Press Enter to exit the installer.

Troubleshoot the Report Server Installation

Use the following files to troubleshoot the Report Server installation:

• CA_Business_Intelligence_InstallLog.log

  We recommend opening this log first to view reported errors.

• ca-install.log

  We recommend scrolling to the bottom of this file to view reported errors. Search for “BIEK_GetExitCode” to verify the returned value of the “BIEK_GetExitCode” function. If the returned value is not 0, then there is an installation error. Search for the following keywords to determine the cause of the error:

  • Error
  • Warning
  • CMS
  • InfoStore

The log files are located in a temporary location during the installation. The TEMP environment property on the system determines the temporary location. If the installation fails, you can locate the log file in this temporary location. After a successful installation, the log files are located at the top level of the Report Server installation directory.