Previous Topic: Run the Installation ProgramNext Topic: Copy the JDBC JAR Files


Post Installation for the Report Server

Starting and Stopping the Report Server

  1. To start the server, SSH to the Business Objects system:
    cd /opt/CA/SharedComponents/CommonReporting3/bobje/setup
    source env.sh
    cd ..
    ./startservers
    ./tomcatstartup.sh
    
  2. To stop the server, SSH to Business Objects system:
    cd /opt/CA/SharedComponents/CommonReporting3/bobje/setup
    source env.sh
    cd ..
    ./stopservers
    ./tomcatshutdown.sh
    

To Check the Installed Business Objects Server Version

  1. Log in to CMS Console.
  2. On the Home page, click Settings under the Manage section.
  3. Check the Product Version is 12.5.0.1265, which applies to CA Business Intelligence 3.3.

Upgrade Report Server to CA Business Intelligence (CABI) 3.3 SP2

The lowest version of CABI that supports Oracle 12c is CABI 3.3 SP2. This version has a patch installer that requires CABI 3.3 or CABI 3.3 SP1 as a prerequisite.

  1. Download and copy CABI 3.3 SP2 patch to /home/bobje directory.
  2. Extract the contents of this file using the following command:
    tar -xvf <CABI 3.3 SP2 Patch File>.tar
    
  3. Give full permissions to the installer directory.
  4. Set the CASHCOMP variable to /opt/CA/SharedComponents as follows:
    export CASHCOMP = /opt/CA/SharedComponents
    
  5. Ensure locale is set to en_US.utf8 else run the below commands:
    export LANG=en_US.utf8
    export LC_ALL=en_US.utf8
    
  6. Upgrade CABI 3.3 to CABI 3.3 SP2 using the below command:
    ./biekpatch -l "/opt/CA/SharedComponents/CommonReporting3/sp7installlog.log"
    
  7. Verify the upgrade of Business Objects.
    1. Log in to the CMS Console.
    2. On the Home page, click Settings under the Manage section.
    3. Check the Product Version is 12.7.0.1983.

Customize the mergeconnections script

  1. Update Registry Entries as follows:

    For reports, such as JDBC/XML, set the registry key to use the Crystal Enterprise/Report Application Server

    For the Identity Management Server to change data sources for reports in the Report Server, run the mergeConnection script.

  2. Check for Windows control characters in the mergeconnections script.

    If you downloaded the software using FTP in binary mode, these characters do not appear in this script. If you used another download method, use the dos2unix command to remove these characters.

  3. Copy the mergeconnections_3.0.cf script from the system with the Identity Management Admin toolkit to the Report Server. On the system with the toolkit, the default location for this script is as follows:
    /opt/CA/IdentityManager/IAM_Suite/Identity_Manager/tools/ReportServerTools
    
  4. On the Report Server system, place the script in this location:
    installation-directory/bobje/enterprise120/generic
    
  5. Source in the environment variables for BusinessObjects Enterprise, as follows:
    source installation-directory/bobje/setup/env.sh
    
  6. Run the following script:
    ./configpatch.sh mergeconnections_3.0.cf
    
  7. Select 1 as the option when prompted.

    Note: Set the environment variable as follows before you run the script:

    export _POSIX2_VERSION=199209
    
  8. Restart crystal processing servers as follows:
  9. Log in as the non-root user you used to install the Report Server.
  10. Issue these commands:
    cd /opt/CA/SharedComponents/CommonReporting3/bobje
    ./stopservers
    source setup/env.sh
    ./startservers