If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Frame work manager datasource connection not working

Started by cognoslearner1, 08 Dec 2017 05:20:28 AM

Previous topic - Next topic

cognoslearner1

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.

MFGF

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.
Meep!

cognoslearner1

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