QE-DEF-0285 Logon failure.
QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
testDataSourceConnection
UDA-SQL-0432 Unable to locate the gateway "cogudaor".
I encountered this error while testing a brand new Datasource connection to an Oracle Database.
In my attempt to find the cause I first tried to reach the oracle database from Cognos Server using ping command. Then, reviewed TNSNAMES.ORA file. Also, used SQL Developer and could successfully connect to the oracle database.
Something was wrong at the Cognos End. And I was sure cogudaor is the culprit. "cogudaor" is Windows gateway for establishing connections to an Oracle data source. On UNIX the gateway is listed as "libcogudaor".
I thought maybe the gateway file has gone corrupt and I have to reinstall Cognos again. After some more research, I found that the query engine for Cognos (version 10.1.1 64 bit server) is still a 32-bit application. This means that you need 32-bit Oracle driver in order to make a connection to the database. By the way, Cognos 10 has introduced a new 64-bit query engine called Dynamic Query Mode but this has not yet been extended to cover relational databases.
I was using a 64-bit oracle client, I uninstalled it and quickly installed a 32-bit oracle client. Unfortunately I was still facing the same error. Continued some more research (there are actually so many reasons for this error).
Finally, Adding ORACLE_HOME in the environment variables solved my problem. Phew !! As it turns out Cognos was unable to locate the oracle directory.
As I said, there are many things that can cause this error. If you have questions or suggestions, do comment.
Environment Specifications:
Stand-Alone Cognos installation
OS : Windows 2008 server R2
Cognos Server : 10.1.1 64-bit
Web server : IIS 7
Database : Oracle 11g 64 bit
QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
testDataSourceConnection
UDA-SQL-0432 Unable to locate the gateway "cogudaor".
I encountered this error while testing a brand new Datasource connection to an Oracle Database.
In my attempt to find the cause I first tried to reach the oracle database from Cognos Server using ping command. Then, reviewed TNSNAMES.ORA file. Also, used SQL Developer and could successfully connect to the oracle database.
Something was wrong at the Cognos End. And I was sure cogudaor is the culprit. "cogudaor" is Windows gateway for establishing connections to an Oracle data source. On UNIX the gateway is listed as "libcogudaor".
I thought maybe the gateway file has gone corrupt and I have to reinstall Cognos again. After some more research, I found that the query engine for Cognos (version 10.1.1 64 bit server) is still a 32-bit application. This means that you need 32-bit Oracle driver in order to make a connection to the database. By the way, Cognos 10 has introduced a new 64-bit query engine called Dynamic Query Mode but this has not yet been extended to cover relational databases.
I was using a 64-bit oracle client, I uninstalled it and quickly installed a 32-bit oracle client. Unfortunately I was still facing the same error. Continued some more research (there are actually so many reasons for this error).
Finally, Adding ORACLE_HOME in the environment variables solved my problem. Phew !! As it turns out Cognos was unable to locate the oracle directory.
As I said, there are many things that can cause this error. If you have questions or suggestions, do comment.
Environment Specifications:
Stand-Alone Cognos installation
OS : Windows 2008 server R2
Cognos Server : 10.1.1 64-bit
Web server : IIS 7
Database : Oracle 11g 64 bit
Nice one! It was the 32-bit client that got me. I was able to install it alongside my existing 64-bit install of Oracle and that seemed to fix things. I didn't need to add the ORACLE_HOME environment variable, as Cognos seemed to pick up the 32-bit client from the PATH variable.
ReplyDeleteHi, i'm a newbie. I install Oracle Database 11gR2 64 bit (server) on my laptop.
ReplyDeleteNow i want to install IBM Cognos BI Server 10.2.2 64bit on my laptop, so do i have to install Oracle 11gR2 client 32 bit??
Thankyou so much.