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.

UDA-SQL-0227

On adding some field in the report and ruuning it I got the following error: UDA-SQL-0227 Equivalence types are incompatible.

This error is caused by a difference in datatypes in Framework Manager in a join between to objects.

In my case I created a relation on an ID between a fact and dimension. In the fact the ID is of type “Character Length 16”.

In the dimension the ID is of type “Float64”

This is caused by the difference in datatypes in the database.

So I solved this by putting a TO_NUMBER on both ID’s