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.

GRANT USE OF TABLESPACE TSN_USR_TCRDB TO USER tcruser
DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:
SQL0554N An authorization ID cannot grant a privilege or authority to itself.
SQLSTATE=42502
GRANT USE OF TABLESPACE TSN_REG_TCRDB TO USER tcruser
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0554N An authorization ID cannot grant a privilege or authority to itself.
SQLSTATE=42502
CONNECT RESET
DB20000I The SQL command completed successfully.
-------------------------------.

4. We check that the TCRDB database was created and it can be connected

Some weeks ago I created a blog with the steps to install TCR 3.1.0.1 with non-root user (https://ibm.biz/Bd4j94) .

Now I have been asked for creating a new blog to cover the installation TCR 3.1.2.1 since some "little" steps (screenshots) have been changed between versions and indicating the components needed and their part numbers. So, here we are with a new blog......

This Doc. cover the installation the TCR 3.1.2.1 with a non-root user in a RH 6.2. The package needed and used for this installation are:

We will have to run the integrateDASH script to integrate the Common Reporting interface with the Dashboard Application Services Hub console. After we run that script,
we’ll be able to log into Dashboard Application Services Hub and access the Common Reporting interface.

2.1 cd /home/tcr/IBM/JazzSM/reporting/integration/dash (since it was installed like non-root)

2.2 run the script :

integrateDASH.bat|sh WAS_admin_user_name WAS_admin_password

WAS_admin_user_name = Specify the user name for the WebSphere administrator to connect to the JazzSMprofile in our case tipadmin.

NOTE: it is a blog following the one "Installing TCR 3.1 with non-root user" (https://ibm.biz/Bd4j94) . Here, we are going to install the TCR 3.1 with non-root user , tcr, as we will see it is a part very easy but we have to take into account that it is not the only step to get a TCR 3.1.x working correctly. It is needed to install a WAS, JAzzSM, ContentStore, etc as it was showed in our previous blogs. That's why I suggest you to start reading the first blog: "Installing TCR 3.1 with non-root user" and keep reading one by one the following ones.

1. Untar the tcr image package:

ITCR_3.1.0.1_FOR_LINUX.tar in /home/tcr/software_ibm/tcr/

2. Run the ./Launchpad.sh located in the jazzSM package image (JAZZ_FOR_SM_1.1.0.1_FOR_LNX.zip) in our case: /home/tcr/software_ibm/jazz

3. Now , we click on “tools”:

4. We select “IBM Tivoli Common Reporting Installation program”

5. Click on “install Program”

6. Set “/home/tcr/software_ibm/tcr/TCRInstaller/install.sh” for the “... installation image:” and click on “Run”

7. OK + Next +Next

8. We set the path were JazzSM was installed:

9. Next + Next + Next

10. Set the user used to logon in JazzSM websphere profile in our case: tipadmin

11. We set the data to connect to our Content Store created previously:

12. click Install . If the installation finishes correctly then we got the message:

NOTE: it is a blog following the one "Installing TCR 3.1 with non-root user" (https://ibm.biz/Bd4j94) . The Reporting services is installed in this way because to install TCR 3.1 with non-root the Content store has to be created manually and the Report Services configuration fail because it is already created.

In this case we are going to run the Reporting services installation using the “installation manager

1. cd /home/tcr/IBM/InstallationManager/eclipse

#./IBMIM

And click on “install”:

2. We select to be installed the “reporting Services environment”:

NOTE: If you want you can select “IBM Dashboard Application Service Hub” to be installed /configured as well since it will be needed to integrate TCR with Dashboard GUI. In our
case , we will do it later to show you another installation option.

Now we are going to install the JazzSM and webphere with our non-root user “tcr”.

1. The first step is unzip the packages:

JAZZ_FOR_SM_1.1.0.1_FOR_LNX.zip in /home/tcr/software_ibm/jazz and
WAS_V8.5.0.1_FOR_JAZZSM_LINUX_ML.zip in /home/tcr/software_ibm/was/

by using the “tcr” user.

2. Now we run ./launchpab.sh script from /home/tcr/software_ibm/jazz

3. Select “custom” in the screen :

4. Click on Next and as it is our first installation we don’t select any existing JazzSM installation in this screen , click next:

5. Now, we set the location for our JazzSM and WebSphere package. The db2 location is empty since it was installed previously and the TCR is empty as well since it will be installed after installing the Reporting Services.

6. Next

7. We only select the WebSphere to be installed like it is showed in this screenshot:

8. Next + Next

9. How we are installing as non-root user, tcr, we change the default installation location from :
/opt/IBM/JazzSM
/opt/IBM/WebSphere/AppServer
To
/home/tcr/IBM/JazzSM
/home/tcr/IBM/WebSphere/AppServer

And click NEXT

10. We set the user “tipadmin” user although you can set another if you want.

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):

3. In the next screens we are going to set the path installation, create the “dasusr1” user, create a db2 instance and single partition instance.

4. Now we create the owner of the instance: db2inst1 default + Next

5. Now appears a summary and click on “finish” to start the installation

6. Once the installation has finished we can validate the installation running the command : ./db2val

7. The last step is license the DB2 running with “db2inst1” the command:

./db2licm –a Db2ese_o.lic
----------------------------------------------------------------------------------------
LIC1402I License added successfully.
LIC1426I This product is now licensed for use as outlined in your License Agreement.
USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE
AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/opt/ibm/db2/V10.1/license/
en_US.iso88591
------------------------------------------------------------------------------------------

NOTE: we can run the command " db2licm –l" to check it was correctly registered.

Normally we install TCR with root user but sometimes we are required to install TCR 3.1 without using non-root user and although it is not really complex, the procedure
is a little different to use the root user account. In this blog we are going to cover or at least to try to show a TCR installation with all necessary components required
using a non-root user, named "tcr", on RH 6 64bit machine. These are the points to discuss :

Another customer, however, has found that there's potentially another couple of points to consider when you're running the install. Firstly, you need to make sure that your DB user -

a) belongs to the db2iadm1 group, and

b) source in the db2profile in .bashrc.

This customer copied the db2profile sourcing from db2inst1 users .bashrc to the filesystem (read only), but in order to ensure full access to all files they also extracted the image to local disk and changed the x bit as per the example below -

cd /opt/dash/install/TCRCognos/ chmod -R +x *

With these two modifications the installer now runs successfully. I hope this little bit of information helps you if you run into any problems with your own installations!

Subscribe and follow us for all the latest information directly on your social feeds:

This is quick post to highlight a technote that some people may not be aware of.

When you try and upgrade TCR 2.1 to 2.1.1, this may fail at the "TCRCore_Upgrade" step of the install. You can confirm this by checking the Installation logs, the error message at the end of the installer will tell you which ones to look at and where they can be found.

This issue occurs when your 2.1 environment has multiple interim fixes installed. The 2.1.1 install scripts are only specifically looking for IF1 and IF2, so anything after that will cause the installer to fail. You need to amend an XML file in the 2.1.1 installer to tell it to look for the later Interim Fixes as well. Specific details and the steps on resolving this can be found in this technote -