Manual configuration required to install Reporting Services as non root user

When you install Jazz for Service Management as non root user, the installation fails at Reporting Services.

Symptoms

When you install Jazz for Service Management as non root user, the Installation fails at Reporting Services. You might receive the following error:
Error during "post-install configure" phase:
Failed in configuring Reporting Services Database.
/home/non_root_user_home/opt/IBM/JazzSM/install/fsconfig.xml:227: 
The following error occurred while executing this line:
/home/non_root_user_home/opt/IBM/JazzSM/install/reporting_services/reporting_services_config.xml:17: 
The following error occurred while executing this line:
/home/non_root_user_home/opt/IBM/JazzSM/install/reporting_services/reporting_services_config.xml:23: 
The following error occurred while executing this line:
/home/non_root_user_home/opt/IBM/JazzSM/install/reporting_services/tcr_db_config.xml:54: 
The following error occurred while executing this line:
/home/non_root_user_home/opt/IBM/JazzSM/install/reporting_services/tcr_db_config.xml:66: 
The following error occurred while executing this line:
/home/non_root_user_home/opt/IBM/JazzSM/install/reporting_services/tcr_db_config.xml:123: 
The following error occurred while executing this line:
/home/non_root_user_home/opt/IBM/JazzSM/install/reporting_services/tcr_db_config.xml:142: 
Failed in configuring Reporting Services Database.

Resolving the problem

To resolve this issue, do these steps manually:
  • Go to REPORTING_HOME from user_home_directory and run the following command as non-root user:
    ./TCR_generate_content_store_db2_definition.sh database_name user_name
    Where
    database_name
    The name of the database to create for the Cognos Content Store. The database name can have up to 8 characters. To avoid potential problems, do not use special characters such as @, #, and $ in the database name. The default database name that is used in a simple installation is tcrdb.
    user_name

    The user name to connect to the Content Store, that is, the database owner.

    The user name can be:
    • The common administrator user name that is created during the simple installation.
    • The database administrator that is created during DB2 setup.
    • The user name that is associated with the user account that was created on the database server for the Content Store.
    For example:
    ./TCR_generate_content_store_db2_definition.sh tcrdb db2inst1
    This command generates the tcr_create_db2_cs.sql script.
  • Run the tcr_create_db2_cs.sql script by using the following command as db2 instance user:
    db2 -vtf <user_home_dorectory>/<REPORTING_HOME>/tcr_create_db2_cs.sql
    You receive the following message:
    The CREATE DATABASE command completed successfully.

After completing these tasks, proceed with the installation.