Getting error "UDA-SQL-0432" in cognos FM while connecting to a datasource

[tushar gaurav]

Hi,
I am trying to connect cognos FM to a datasource and I am getting the following error in the process:
------------------------------------------------------
QE-DEF-0285 The logon failed.
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:
TEST

UDA-SQL-0432 Unable to locate the gateway "cogudaor".
------------------------------------------------------
This datasource is working fine from cognos connection and I am able to create data modules and reports based on this.
Can you please help me with this issue.
Could it be a FM configuration issue?

[bus_pass_man]

The query engine is complaining that you don't have the necessary connection set up for CQM (compatible query mode) mode, which is the older of the two.  The newer is DQM, dynamic query mode.

When you create the FM model, make sure the use dynamic query mode setting is on.  If you already have your model created, select the top most node of the project tree and view the properties for it. There will be a query mode property.  Set it to dynamic.  It will need to walk through the already imported objects and ping your data base to confirm the metadata, which can take some time.

[MFGF]

Hi,
I am trying to connect cognos FM to a datasource and I am getting the following error in the process:
------------------------------------------------------
QE-DEF-0285 The logon failed.
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:
TEST

UDA-SQL-0432 Unable to locate the gateway "cogudaor".
------------------------------------------------------
This datasource is working fine from cognos connection and I am able to create data modules and reports based on this.
Can you please help me with this issue.
Could it be a FM configuration issue?

Just to add to what bus_pass_man said, if you really do need to use Compatible Query in your model, you're going to need to have the Oracle 32-bit client libraries installed on your FM machine. Here's a post from a few years ago:

https://www.cognoise.com/index.php/topic,22144.msg67737.html#msg67737

Cheers!

MF.

[tushar gaurav]

Thanks bus_pass_man and MFGF for your response.
I am however creating the model using DQM only but I am still getting this error.
I have installed Cognos FM (V1.1.7) today i.e.09June2021 so there there no existing model.
Could it be a configuration issue or driver related issue?
Thanks again.

[MFGF]

Thanks bus_pass_man and MFGF for your response.
I am however creating the model using DQM only but I am still getting this error.
I have installed Cognos FM (V1.1.7) today i.e.09June2021 so there there no existing model.
Could it be a configuration issue or driver related issue?
Thanks again.

Hi,

Any error that has "UDA" in it is coming from the Universal Data Access layer - the interface the Compatible Query Engine uses. You wouldn't see this message unless you were using Compatible Query. Can you double-check this?

Cheers!

MF.