Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  XQE-DAT-0001 Data source adapter error: java.sql.SQLException: Internal error executing query.

    Posted Fri July 12, 2024 11:27 AM

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


  • 2.  RE: XQE-DAT-0001 Data source adapter error: java.sql.SQLException: Internal error executing query.

    Posted Mon July 15, 2024 03:39 AM

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

    Original Message


  • 3.  RE: XQE-DAT-0001 Data source adapter error: java.sql.SQLException: Internal error executing query.

    Posted Mon July 15, 2024 10:17 AM

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

    Original Message


  • 4.  RE: XQE-DAT-0001 Data source adapter error: java.sql.SQLException: Internal error executing query.

    Posted Tue July 16, 2024 01:51 PM

    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/
    ------------------------------

    Original Message


Related Content