Topic
  • 3 replies
  • Latest Post - ‏2014-02-09T20:29:13Z by MattNa
MattNa
MattNa
124 Posts

Pinned topic Datasource CQM failing

‏2014-01-24T13:51:54Z |

In Cognos Connection I can test a data source to Oracle database, I get error on the CQM (compatible query mode Native Client)
connection, but the DQM (dynamic query mode JDBC ) works fine.

Here is the error I am geting

 

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:

    testDataSourceConnection



UDA-SQL-0432 Unable to locate the gateway "cogudaor".

BME-EX-0144 Trace back:

BmtPlayTransaction.cpp(788): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction

BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction

QFSSession.cpp(1153): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()

QFSSession.cpp(1151): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()

QFSSession.cpp(2034): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()

Source/QE_RsApi.cpp(2070): QFException: CCL_RETHROW: QE

Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE

I have checked other environments all are the same and this is only one that is reporting an error.

  • Carlos.Hernandez
    Carlos.Hernandez
    79 Posts

    Re: Datasource CQM failing

    ‏2014-01-24T18:53:32Z  

    Here are some things to look at:

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

    http://www-01.ibm.com/support/docview.wss?uid=swg21614942

     

  • YUA1_Chetan_Parmar
    YUA1_Chetan_Parmar
    2 Posts

    Re: Datasource CQM failing

    ‏2014-02-08T16:46:03Z  

    Also, make sure you selecting the correct driver for the database you are connecting to...

  • MattNa
    MattNa
    124 Posts

    Re: Datasource CQM failing

    ‏2014-02-09T20:29:13Z  

    Hi Carlos

     

    I will look at these.  All environments are working with exact same set-up