We help IT Professionals succeed at work.

Error setting up - Cognos 8 Frame Work Manager - URGENT

rharivenkatesh
on
Medium Priority
1,890 Views
Last Modified: 2012-05-06
Hello Gurus,

 I'm new to Cognos. I installed Cognos 8 in my system. I was trying to configure Cognos Framework Manager with the guidelines available. I have been trying to do this for quite a while now.

When i create a new DB2 database under Logging within "Environment", i'm able to do it successfully. When i test it, the connection is successful.

But when i try to do the same under "Content Manager" in 'Data Access", i'm facing a problem.

When i installed Cognos 8, i had a Content Store under Content Manager which was pointing to an SQL Server by default.

I deleted this Content Store and tried creating a new DB2 database. When i "TEST" it, it shows  the following error messgae

"[Validate Content Manager database connection]
1. [ ERROR ] The database connection failed.
2. [ ERROR ] Content Manager is unable to initialize the content store by using the initialization file "C:\Program Files\cognos\c8\configuration\schemas\content\db2\dbInitTest_db2.sql"."

Can anyone please help me in resolving this error.

Does anyone have a step by step process for setting up Frame Work Manager for Cognos 8.1

"[Validate Content Manager database connection]
1. [ ERROR ] The database connection failed.
2. [ ERROR ] Content Manager is unable to initialize the content store by using the initialization file "C:\Program Files\cognos\c8\configuration\schemas\content\db2\dbInitTest_db2.sql"."

Open in new window

Comment
Watch Question

I think you are talking about two issues.   First using Frameowrk Manager. I believe your problem is the connection.   When using framework manager you are actually logging into the database as yourself even if the connection is created using service credentials.

Second when creating a new content store the user issuing the script must be database owener to run the script.  

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Hi,

Thanks for the reply.

Could you please help me out with Step of actions to be performed, If i have to configure cognos 8 Framework Manager for DB2 database and use it to create new reports.

Regards,
Viji.R

Commented:
Framework Manager is a standalone metadata modeling tool that you use to import and enhance the metadata from your reporting database.  Because it is a standalone application, it needs to create a connection to the reporting database from the comptuer that you installed it on.  This is different then when you're using Cognos 8 itself, becuase then all the connections to the database are made from the cognos 8 server.  This is why the connection tests successfully in the datasource wizard, but doesn't work in the metadata import.

To fix this, you need to have the DB2 client software installed on the Framework Manager comptuer.  Then you need to configure the DB2 client software so that it can connect to the reporting database using the same information that you specified in the Cognos 8 datasource properties.

Author

Commented:
Hello RWrigley,

We have already installed DB2 Client and setup and settings using configuration assistant. Anything more i need to do?

Regards.
Hari.
Commented:
Assuming that you're able to connect to the database on the FM machine using the same alias, username and password that is configured in the Datasource property on the cognos server, the most common problem I've seen has to do with the correct setting of the "path" variable.  Because Cognos isn't a DB2 application, it needs to know where to find the DB2 client files.  It does this based on the environment variables.

Author

Commented:
It did not completely solve the issue.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.