Can't initialize the metric store

[gustavoramiro]

Hi, when I tried to "initialize" the metric store process from metric studio.

This is the error that appear:

CMM-APP-3254 The initialization of the metrics store failed. DIS-ERR-3115 Task execution failed.
MDS-RUN-3207 Failed to install because database version is not supported.

I have Oracle 9i and that version is compatible with cognos 8.

Can somebody help me?

gustavo

ps, the database is generated from the cognos process that is called "cmm_database_db.cmd" and this process run correctly

[ducthcogtechie]

Metrics uses oraoledb.dll which is not installed with the light oracle client.
Then make sure you have the correct rights set for the schema user, as metrics is very picky on this (roles are NOT enough)

GRANT CREATE ANY PROCEDURE TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE ANY SEQUENCE TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE ANY TABLE TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE ANY TRIGGER TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE ANY TYPE TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE ANY VIEW TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE SESSION TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE TABLE TO "cmmuser"
GRANT CREATE TRIGGER TO "cmmuser"
GRANT CREATE VIEW TO "cmmuser"
GRANT "CONNECT" TO "cmmuser";
GRANT "RESOURCE" TO "cmmuser";
GRANT UNLIMITED TABLESPACE TO "cmmuser"
GRANT EXECUTE ON  "SYS"."DBMS_LOCK" TO "cmmuser"
GRANT EXECUTE ON  "SYS"."DBMS_UTILITY" TO "cmmuser"

Then to load the samples make sure the sqlldr.exe is present on the Cogos 8 server.
(for simplicity sake, always install the administrator option of the Oracle client on the C8 server)

[JoeBoxer]

Metrics uses oraoledb.dll which is not installed with the light oracle client.
Then make sure you have the correct rights set for the schema user, as metrics is very picky on this (roles are NOT enough)

GRANT CREATE ANY PROCEDURE TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE ANY SEQUENCE TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE ANY TABLE TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE ANY TRIGGER TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE ANY TYPE TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE ANY VIEW TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE SESSION TO "cmmuser" WITH ADMIN OPTION
GRANT CREATE TABLE TO "cmmuser"
GRANT CREATE TRIGGER TO "cmmuser"
GRANT CREATE VIEW TO "cmmuser"
GRANT "CONNECT" TO "cmmuser";
GRANT "RESOURCE" TO "cmmuser";
GRANT UNLIMITED TABLESPACE TO "cmmuser"
GRANT EXECUTE ON  "SYS"."DBMS_LOCK" TO "cmmuser"
GRANT EXECUTE ON  "SYS"."DBMS_UTILITY" TO "cmmuser"

Then to load the samples make sure the sqlldr.exe is present on the Cogos 8 server.
(for simplicity sake, always install the administrator option of the Oracle client on the C8 server)

Excellent stuff DutchCogTechie ...
Additionally, not all version of Oracle 9i is supported.  Minimum support for Cognos 8.1 MR2 is Oracle 9.2.0.7 Enterprise Edition.  Check with the software environment page if you are using a different version of Cognos Metrics Studio.