We have a working report studio report in Cognos10.2.2 where the data source is a cube and a separate SQL query to Netezza. One query is the using the cube and another query is using a SQL object. There are no joins between the two queries. The report is used to reconcile data. I am surprised this report works as I thought you could only use one data source.
The same report does not work in Cognos11.1.7 The SQL object errors with the following error. If a framework package is used as the data source instead of the cube data source, the SQL query works. But then we can't query the cube data source.
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:
PROD_Insurer_NZ
UDA-SQL-0432 Unable to locate the gateway "cogudajdbc".
RSV-SRV-0042 Trace back:
etc
I've tested all the JDBC connections and they all work (No ODBC connections). The logon issue makes me think that it's trying to use an ODBC connection, but why wouldn't it use the JDBC connections in Cognos11?
Google says it's a driver issue but everything migrated works without issue. Only this report fails.
Any ideas?
------------------------------
Trevor Fyfe
------------------------------