Tivoli admin center reporting error

Once you configured Tivoli reporting and monitoring and integrated with TSM AC, you may get the following error sometimes when you tried to access reporting function in AC:

Problem:

DPR-ERR-2109 The dispatcher cannot service the request at this time. The dispatcher is still initializing. Contact your administrator if this problem persists.

Cause

The derby database is no longer valid and needs to be initialized.

To fix it: 

1. Stop Tivoli Portal server

2. # export JAVA_HOME=/opt/IBM/tivoli/tipv2/java

3. # /opt/IBM/tivoli/tipv2Components/TCRComponent/cognos/bin/derby.sh start 1527

4. # /opt/IBM/tivoli/tipv2Components/TCRComponent/cognos/derby10.1.2.1/bin/ij.sh

5. ij> connect 'jdbc:derby://localhost:1527/cm;create=true;user=cognos;password=cognos';

6. ij> run '/opt/IBM/tivoli/tipv2Components/TCRComponent/cognos/contentstore/init_contentstore.sql';

7. ij> disconnect;

8. ij> quit;
9. Start Tivoli Portal server