Hi All,
We have a datasource connection created in the Cognos portal which works fine. However if we use same connection in the FM we are getting below errors
QE-DEF-0285
QE-DEF-0325
RQP-DEF-0068
UDA-SQL-0031
UDA-SQL-0107
ORA-12170
I have checked the credentials which are correct and also I am able to connect database from sql developer from the machine where FM is installed. We are using Cognos 10.2.2
Thanks in advance.
Quote from: cognoslearner1 on 08 Dec 2017 05:20:28 AM
Hi All,
We have a datasource connection created in the Cognos portal which works fine. However if we use same connection in the FM we are getting below errors
QE-DEF-0285
QE-DEF-0325
RQP-DEF-0068
UDA-SQL-0031
UDA-SQL-0107
ORA-12170
I have checked the credentials which are correct and also I am able to connect database from sql developer from the machine where FM is installed. We are using Cognos 10.2.2
Thanks in advance.
Hi,
You didn't confirm how you are connecting from Cognos to Oracle. Are you using JDBC? Native Client? ODBC?
I can see UDA error codes in your post, so that tells me you are trying to connect via Compatible Query from FM to the data source. This will use either the Oracle native client libraries or ODBC - whichever you configured in the data source connection. However, these need to be installed and configured locally on the FM machine for FM to be able to connect (unlike Dynamic Query which uses the connectivity via the Cognos server). Are you sure you have the correct Oracle 32-bit client libraries or ODBC installed and configured on the FM machine?
Cheers!
MF.
Hi MFGF,
Thanks for your reply. We are using the native client. We have connections for oracle databases and Exadata oracle. Connections to only Exadata databases are not working and getting above mentioned errors. However connections for both the getting tested with success on Cognos portal.
Thanks,
Cognoslearner1