Cognos-based TCR report: dispatcher unable to service the request

Technote (troubleshooting)


Problem(Abstract)

The following message is displayed when running a Cognos-based TCR report:

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

Symptom

The report fails to run and it appears as if TCR cannot contact the Cognos report database.


Cause

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

Diagnosing the problem

The cogserver.log file records the following message:

CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-CFG-5036 Content Manager failed to connect to the content store. The connection string is:


"jdbc:derby://localhost:1527/cm". DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040, SQLERRMC: Failed to start database 'cm', see the next exception for details.::SQLSTATE: 40XD2Container Container(0, 977) cannot be opened; it either has been dropped or does not exist. Cause:
DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040, SQLERRMC: Failed to start database 'cm', see the next exception for details.::SQLSTATE: 40XD2Container Container(0, 977) cannot be opened; it either has been dropped or does not exist. Runtime Exception stack trace: java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040, SQLERRMC: Failed to start database 'cm', see the next exception for details.::SQLSTATE: 40XD2Container Container(0, 977) cannot be opened; it either has been dropped or does not exist.

The derby.log file records the following messages:

ERROR XSLA7: Cannot redo operation null in the log.
ERROR 40XD2: Container Container(0, 977) cannot be opened; it either has been dropped or does not exist


Resolving the problem

1) Stop the TCR server.


2) Open a command line and set the JAVA_HOME variable:

WINDOWS
set JAVA_HOME=C:\IBM\tivoli\tip\java

*NIX
export JAVA_HOME=/opt/IBM/tivoli/tip/java

3) Start the derby database:

WINDOWS
TIPHOME\products\tcr\Cognos\c8\bin\derby.bat start 1527

*NIX
TIPHOME/products/tcr/Cognos/c8/bin/derby.sh start 1527

4) Start the ij database command line utility:

WINDOWS
TIPHOME\products\tcr\Cognos\c8\derby10.1.2.1\bin\ij.bat

*NIX
TIPHOME/products/tcr/Cognos/c8/derby10.1.2.1/bin/ij.sh

5) From the ij command line prompt, re-initialize the cm database:

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

WINDOWS
ij> run 'C:\IBM\tivoli\tip\products\tcr\Cognos\c8\contentstore\init_contentstore.sql';

*NIX
ij> run '/opt/IBM/tivoli/tip/products/tcr/Cognos/c8/contentstore/init_contentstore.sql';
ij> disconnect;
ij> quit;

6) Restart the TCR server via startTCRserver.bat/.sh

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Common Reporting

Software version:

1.3.0, 2.1

Operating system(s):

AIX, HP-UX, Linux, Linux zSeries, Solaris, Windows

Reference #:

1501451

Modified date:

2013-04-25

Translate my page

Machine Translation

Content navigation