Error in Cognos 10.2.2 Report Studio Query Subject Validation

[Arghya]

Dear All,

We are facing difficulty in creating report in Cognos 10.2.2 based on SAP Hana 2.0 database.

The sequence of steps we have followed are mentioned below :
1. Placing the file ngdbc.jar in \webapps\p2pd\WEB-INF\lib location of Cognos 10.2.2. server.
2. Restarting the server.
3. Creation of one new JDBC data source connection using the credentials of SAP Hana database.
4. The data source is tested successfully.

However we are trying to create a query subject from 'SQL' component of Report Studio toolbox(from the left side pane) the validation is not getting successful with the error message :

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:
    SAP_HANA

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

Is there any change we need to implement in any Cognos parameters to make it work?

Thanks,
Arghya

[MFGF]

Dear All,

We are facing difficulty in creating report in Cognos 10.2.2 based on SAP Hana 2.0 database.

The sequence of steps we have followed are mentioned below :
1. Placing the file ngdbc.jar in \webapps\p2pd\WEB-INF\lib location of Cognos 10.2.2. server.
2. Restarting the server.
3. Creation of one new JDBC data source connection using the credentials of SAP Hana database.
4. The data source is tested successfully.

However we are trying to create a query subject from 'SQL' component of Report Studio toolbox(from the left side pane) the validation is not getting successful with the error message :

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:
    SAP_HANA

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

Is there any change we need to implement in any Cognos parameters to make it work?

Thanks,
Arghya

Hi,

Do you see the same problem when importing data into Framework Manager?

The error 'UDA-SQL-0432 Unable to locate the gateway "cogudajdbc"' makes me think your report is trying to use Compatible Query mode, which doesn't support JDBC - you'd need to use Dynamic Query Mode.

My guess is this. To create a report in Cognos 10, you first need to choose a package. I suspect you are choosing a package published in Compatible Query Mode. From then on, your report will use Compatible Query in all its query operations. I'm just guessing wildly here, though.

Do you have a package published in Dynamic Query Mode? If so, can you choose this one and try again?

MF.

[Arghya]

Thanks MF for the feedback.

Actually, the problem was resolved when the Cognos data source connection in 10.2.2 server was created with type='ODBC' instead of JDBC.

Regards,
Arghya