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
Quote from: Arghya on 15 Jan 2020 06:49:24 AM
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.
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