UDA-SQL-0432

Unable to locate the gateway “libcogudaor”

Case:

When creating a new datasource in Cognos Administration, error UDA-SQL-0432 occurred on testing the new connection.

For windows evironments the error is:

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”.

For a UNIX environment the error is:

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 “libcogudaor”.

Solution:

A solution can be found on the IBM website:

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

Bottom line is that the cognos installation is 32 bit and is not working with a 64 bit oracle client.

A 32 bit oracle client should be installed next to the 64 bit client. You should point cognos to the 32 bit client. Other oracle items should find the 64 bit client installation.

Leave a Reply

Your email address will not be published. Required fields are marked *