Troubleshooting
Problem
Analytics->Cannot Object Store Database
Symptom
To solve the original problem of IWR Reports not starting. User checked the
EventLogs and found that the dispatcher service was not running.
When
attempting to start the IWR dispatcher.
The user faces the following
error.
Event Type: Error
Event Source: IWR:IWIRSDISP
Event Category:
None
Event ID: 0
Date: 8/22/2002
Time: 1:23:44 PM
User:
N/A
Computer: GASLCOG99
Description:
GASLCOG99, 436(c24), 2002/08/22
13:23:44.806; Error: 0, Generic; Process
ID: 436; Thread: 3108; Host:
GASLCOG99; Text: Cannot open Object Store
Database.; BackTrace Info: 1.
File Name:
S:\Imp60\IWR\Dispatchers\Common\Dispatcher.cpp; Line#:113;
Desc.:Cannot open
Object Store Database.; 2. File
Name:
S:\Imp60\IWR\Dispatchers\Common\Dispatcher.cpp;
Line#:122;
Desc.:Dispatcher::initialize; 3. File
Name:
S:\Imp60\IWR\Dispatchers\IWIRSDisp\IWIRSDisp.cpp; Line#:177; Desc.:;
"
PART: Cognos 4.0 SP3 Platform
COMPONENT: IWR Reports
OS:
Solaris - 2.8
DATABASE: Oracle - 9.2.0.1
WEB SERVER: WebLogic - 6.1
SP2
WEB BROWSER: Internet Explorer - 5.5 sp2
Cause
Resolving The Problem
IWR Data Store needs to be recreated.
Here is a document that can been
followed to recreate the IWR data store. I will continue to research on
performing this task via terminal services.
1. Stop all Impromptu Web
Reports services.
Impromptu Web Service Manager
Impromptu Web
Com Service
Cognos Communication Service
2. Delete the data store
(.db) files. (recommends copying the .db files and moving them to another
drive and/or directory)
iwr.db
iwrig.db
iwrjob.db
iwrmsg.db
iwrsm.db
The default location is \Program
Files\Cognos\cer1\Database.
3. Delete any published report sets.
Before recreating the data store, delete all published report sets.
4. Run IWCreateDB to recreate the data store
Use the IWCreateDB
command to recreate the data store.
a) Open a command prompt window and
navigate to the bin folder. The default location is \Program
Files\Cognos\cer1\bin.
b) Type IWCreateDB
Optionally, the following
parameters can also be used:
For example, IWCreateDB -all -p8111
-nIWRNamespace
Note: Do not use spaces between the parameters and
their values.
c) Close the command prompt window.
-p <port
number> Use this if the default port 8020 was not specified when IWR was
installed.
-n <namespace> Use this if the Default namespace was not
specified when IWR was installed.
5. Register all report and request
dispatchers.
After the data store is recreated, register the report and
request dispatchers on each computer in the server group.
a) Open a
command prompt window, and navigate to the \Program Files\Cognos\cer1\bin
folder.
b) Type iwiwrdisp -register and press Enter to register report
dispatcher.
c) Type iwirsdisp -register and press Enter to register request
dispatcher.
d) Close the command prompt window.
6. Restart the
Impromptu Web Report services.
Impromptu Web Service Manager
Impromptu Web Com Service
Cognos Communication
Service
NOTE: Please also refer to Appendix A in the
Installation and Configuration Guide for Windows.
Historical Number
PRI48930
Product Synonym
[<p><b>]Fact[</b><p>]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21546927