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

TNS error when I create new project in Framework Manager

Started by hawaii_desperado, 20 Jul 2011 05:26:01 PM

Previous topic - Next topic

hawaii_desperado

I am working on a new cognos install.  I finally have the server up and running and I have created and tested the datasource connection to our oracle 11g database just fine from the web interface.  RHEL three tier setup, gateway 32bit, app 64bit, cm64bit.

I have installed Framework Manager along with oracle instant client on my PC.  Cognos confiuration saves fine.

When I create a new project, login, select language, then select my data source I get the following error.

QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
KCDEV31

UDA-SQL-0031 Unable to access the "KCDEV31" database.
UDA-SQL-0107 A general exception has occurred during the operation "attach".
ORA-12170: TNS:Connect timeout occurred

I have oracle configured with TNS_ADMIN set to the location of my tnsnames.ora file.

Any ideas on how to fix this?

hawaii_desperado

We found our issue it was a problem with the oracle client install on the 64bit machine.   We moved our install to a 32bit machine to make things simple and it installed the first time without issue.  Install Java, Install oracle 11g client, add env variables for both, install Framework Manager and it worked fine.