Topic
2 replies Latest Post - ‏2013-02-19T13:52:45Z by clowicek
SystemAdmin
SystemAdmin
250 Posts
ACCEPTED ANSWER

Pinned topic UDA-SQL-0432 Unable to locate the gateway "cogudaor"

‏2013-02-05T17:43:05Z |
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?

Thanks.
Updated on 2013-02-19T13:52:45Z at 2013-02-19T13:52:45Z by clowicek
  • N Campbell
    N Campbell
    3 Posts
    ACCEPTED ANSWER

    Re: UDA-SQL-0432 Unable to locate the gateway "cogudaor"

    ‏2013-02-09T21:58:11Z  in response to SystemAdmin
    The 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.
  • clowicek
    clowicek
    2 Posts
    ACCEPTED ANSWER

    Re: UDA-SQL-0432 Unable to locate the gateway "cogudaor"

    ‏2013-02-19T13:52:45Z  in response to SystemAdmin
    Hi,
    first time.. install Oracle client 64bit and change environmental path to 64bit Oracle client...