If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos 8.4 Metric Store Initialization Error

Started by LDJB81, 21 Apr 2010 03:57:33 AM

Previous topic - Next topic

LDJB81

Hi, I have recently installed Cognos 8.4 in our training environment and am having problems initializing a metrics package. I have created a data source connection to Metric Store database in SQL Server 2008 which works fine when I test the connection. However, when I try to initialize a new package I get the following error message:

CMM-APP-3254 The initialization of the metrics store failed. DIS-ERR-3115 The task failed.
DIS-RUN-3140 Step 'Install the metric data store' execution failed in package 'null'.

I have checked the logs and it appears the package fails when checking for the bulk loader tool. The BCP.exe is installed in the SQL Server Binn directory on the same server and directory is a PATH in the environment variables. I have contacted our external support team and they have come back and told me SQL Server 2008 is not supported for the Metric Store, is this correct?? If not, can anybody help?

Here is the log for the Metrics Store install:

Starting database pre-install checks at Mon Apr 19 15:09:53 BST 2010

Checking database version compatibility...PASSED
Checking for presence of dbowner role...PASSED

WARNING: It appears that your database contains one or more objects already in the schema provided.
Checking database to see if schema is free of other objects...WARNING
Checking for presence of bulk loader tool...FAILED
Checking database collation settings...PASSED
Creating installed objects table......

Finished database pre-install checks at Mon Apr 19 15:09:53 BST 2010

Thanks
Lloyd

smiley

"Checking for presence of bulk loader tool...FAILED"

Install sql 2008 client tools on appserver.