Using Cognos 11.2.4

I have a report based off of a Data Module.

When I run the report i get this error:  XQE-DAT-0001 Data source adapter error: java.sql.SQLException: Internal error executing query. No data returned.

When I open the data module I see there is one table that is throwing an error below.  However, I can go into Oracle and pull data from the table just fine.  Also, the 'data source' connection in the Cognos admin console says successful connection.  Any idea?

XQE-DAT-0001 Data source adapter error: java.sql.SQLException: Error executing query. Total time 0.591 seconds.

QUERY [VIRTUAL] [ERROR] 
QUERY [JDBC WRAPPER] [ERROR] 
QUERY [JDBC ROUTE] [ERROR]  Received exception with message 'ORA-00942: table or view does not exist'

------------------------------
Jenifer Broughton
------------------------------

Hi Jenifer,

can it be that the user that is defined in the Cognos data source connection does not have select privileges on the table you would like to use? Can you assign to the database using that specific user and try pulling data from the table?

Another thing to check: is the data source connection sign-on accessible for "Everyone"?

------------------------------
Robert Dostal
Team Leader BI
GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
Ingelfingen
------------------------------

The error message you post appears to be the same style that Denodo would throw.

If so, you should review the Denodo mappings to the ORACLE source you are trying to query via it.

------------------------------
NIGEL CAMPBELL
------------------------------

Hi,

Did you try generate SQL in report to see query? Can be a schema name missing.

------------------------------
JEAM COELHO
Cognos Solution Architect

LinkedIn: https://www.linkedin.com/in/jeamcoelho/
------------------------------