[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1841
  • Last Modified:

Error setting up - Cognos 8 Frame Work Manager - URGENT

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

0
rharivenkatesh
Asked:
rharivenkatesh
  • 3
  • 2
2 Solutions
 
welchb123Commented:
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.  
0
 
rharivenkateshAuthor 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
0
 
RWrigleyCommented:
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.

0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
rharivenkateshAuthor Commented:
Hello RWrigley,

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

Regards.
Hari.
0
 
RWrigleyCommented:
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.
0
 
rharivenkateshAuthor Commented:
It did not completely solve the issue.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now