Cognos 10 Framework Manager problem

[slj1989]

Our Cognos 10 environment is working well with one exception.  I have moved all the Cognos 8 framework manager projects to the Cognos 10 server, opened all of them, and saved them with no issues.  Today, I need to update a query subject within a project, and when I try to add a new item from the data source, I get several errors.  QE-DEF-0285, QE-DEF-0325, RQP-DEF-0068, UDA-SQL-0031 (all have to do with logon to the database failing) and UDA-SQL-0107 (general exception error) and ORA-06413 (connection not open).  The framework manager software and projects are installed/saved on the same machine as the cognos 10 install.  The  machine is a 64 bit windows 2008 r2 machine running oracle client 10.2.0. 

Any suggestions are greatly appreciated.  Thanks! 

RR

[tjohnson3050]

Did you test the Oracle configuration (tnsping the service name)?  I have been guilty in the past of installing the Oracle client but not moving over the configuration files (tnsnames.ora)...

[slj1989]

I compared the tnsnames files between Cognos 8 environment and Cognos 10.  The only thing I can't check right now is the Cognos 8 development environment.  It is currently down due to hardware issues.  Once it is back up, I will double check the tnsnames file there as well.  This was my first thought as well.  As of right now, the tnsnames files on cog 10 and cog 8 production are the same.  It will let me publish a package in cog 10, but it doesn't like it if I try to change anything within the project. 

Thank you for your reply.  :)

[tjohnson3050]

There are several things that can be different about connecting to Oracle between Cognos 8 and Cognos 10.

One common issue is that in changing from Cognos 8 to Cognos 10, the underlying server architecture also changes from 32 bit to 64 bit. 

http://www-01.ibm.com/support/docview.wss?uid=swg21370380

Also if you are going to try to use the new Dynamic Query Mode, you will need to become familiar with connecting to Oracle via JDBC.

http://www-01.ibm.com/support/docview.wss?uid=swg21573898

Other Oracle connection troubleshooting

http://www-01.ibm.com/support/docview.wss?uid=swg21341734