rharivenkatesh
asked on
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\configurat ion\schema s\content\ db2\dbInit Test_db2.s ql"."
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
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\configurat
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"."
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
Hello RWrigley,
We have already installed DB2 Client and setup and settings using configuration assistant. Anything more i need to do?
Regards.
Hari.
We have already installed DB2 Client and setup and settings using configuration assistant. Anything more i need to do?
Regards.
Hari.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It did not completely solve the issue.
ASKER
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