Making your life easier: Installing TCR 3.1 with Non-Root Creating Configuring Content Store

by Fran Martinez

C. CREATING AND CONFIGURATION THE CONTENT STORE

NOTE: it is a blog following the one "Installing TCR 3.1 with non-root user" (https://ibm.biz/Bd4ear)  although you can use it to create and configure the Content Store manually in case you need it.

The content store is the database used by reporting services and where is store our TCR configuration: Schedule, plan.... and it is needed for  running our reports correctly.
Installing with root user this step can be avoided since it is installed and configured during Reporting Services installation but when we install JazzSM as non root user, the installation for Reporting Services may fails with 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.

-------------------------------------------------------------------------------------------------------------------------------------------

To resolve this issue we are going to have to  create and configure  the ContentStore  manually.

NOTE: the user account “non-root” that we are going to use for the installation will be “tcr”.
            Default path for root user = /opt/IBM/JazzSM/
            Default path for non-root = /home/name_user_no_root/IBM/JazzSM . So, in our case                               /home/tcr/IBM/JazzSM

NOTE: All package image will be downloaded in /home/tcr/software_ibm/

FOLLOW  THESE STEPS:

1. Go to REPORTING_HOME from user_home_directory and run the following command as non-root user:


                 ./TCR_generate_content_store_db2_definition.sh <db_name> <user_name>

WHERE:

         DB_name = The name of the database to create for the Cognos Content Store. The database                               name can have up to 8 characters


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

 


In our case , we run from /home/tcr/software_ibm/tcr/TCRInstaller/ContentStoreDatabase with “tcr” user the script:


                            #./TCR_generate_content_store_db2_definition.sh tcrdb db2inst1


This command generates the tcr_create_db2_cs.sql script in:


                              /home/tcr/software_ibm/tcr/TCRInstaller/ContentStoreDatabase


2. Now we run the tcr_create_db2_cs.sql script by using the following command as db2 instance user (db2inst1):


         “db2 -vtf <user_home_dorectory>/<REPORTING_HOME>/tcr_create_db2_cs.sql”

 

         db2 –vtf /home/tcr/software_ibm/tcr/TCRInstaller/ContentStoreDatabase/tcr_create_db2_cs.sql


3. If it is executed correctly then we will receive the following message:


                   "The CREATE DATABASE command completed successfully."


And we will be able to connect to the “TCRDB” database with db2inst1 using the command:


                  db2 connect to tcrdb user db2inst1 using <password>

 

NOTE: NEXT STEP IN "Installing JazzSM 1.1.0.1 and Webphere 8.5.0.1"

 

Recent Stories
TCR 2.x Connection Fail - Reports Do Not Run

Track Data Power as Part of Your Middleware Integration Stack

Making Your Life Easier: Installing Dashboard Application Services 3.1.2.1