We have Cognos 10.2 installed on a 64bit Windows 2008R2 box. Oracle 32bit 10g client is installed. We can access a remote Oracle database using SQL developer on the same box. However, trying to run a report in Cognos has the error:
"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: Trillium PROD UDA-SQL-0432 Unable to locate the gateway "cogudaor". "
The content store was migrated from 8.1 to 10.2.
How do we solve this?
This topic has been locked.
2 replies Latest Post - 2013-02-19T13:52:45Z by clowicek
Pinned topic UDA-SQL-0432 Unable to locate the gateway "cogudaor"
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-19T13:52:45Z at 2013-02-19T13:52:45Z by clowicek
N Campbell 2700018X303 PostsACCEPTED ANSWER
Re: UDA-SQL-0432 Unable to locate the gateway "cogudaor"2013-02-09T21:58:11Z in response to SystemAdminThe error implies that the ORACLE 32-bit client libraries could not be loaded.
If SQL Developer uses a JDBC type-4 driver so comparing it to an OCI connection would not be applicable.
Review what your PATH environment is set to, that the ORACLE 32-bit client library folder is on the path, exists and can be accessed etc.