Cognos Analytics

 View Only

  • 1.  Cognos 11.1.7 UDA-SQL-0023 error connection to database has been terminated due to an unrecoverable

    Posted Fri January 08, 2021 02:05 PM
    ​Hello,

    First time posting here. Recently we upgraded to cognos 11.1.7. Initially things seemed fine. But this week, we are seeing this error when running reports on and off. When we retry running, the reports run fine - some times have to try 2-3 times/wait a bit and try.

    UDA-SQL-0023 The connection to the "(database name)" database has been terminated due to an unrecoverable error.ORA-03114: not connected to ORACLE<br/>

    I am not sure if this is upgrade related. Could some one please help out? 

    Thanks,
    Mike

    ------------------------------
    Mike A
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos 11.1.7 UDA-SQL-0023 error connection to database has been terminated due to an unrecoverable

    Posted Wed January 13, 2021 07:35 AM
    Edited by System Fri January 20, 2023 04:49 PM
    I don't use Oracle, so I can't be much help I'm afraid. A quick search on that error code yielded these, which might be helpful:
    https://support.oracle.com/knowledge/Enterprise%20Management/1983860_1.html
    https://dba.stackexchange.com/questions/238413/oracle-losing-connection-ora-03114-after-some-time-not-using-the-software
    http://www.orafaq.com/forum/t/170146/

    ------------------------------
    Chris Turner
    ------------------------------

    Original Message


  • 3.  RE: Cognos 11.1.7 UDA-SQL-0023 error connection to database has been terminated due to an unrecoverable

    Posted Wed January 13, 2021 11:33 AM
    Thanks for the information. The issue in our case was with our oracle database and not cognos. I think some time out setting change fixed the issue (DBA handles that).

    ------------------------------
    Mike A
    ------------------------------

    Original Message


  • 4.  RE: Cognos 11.1.7 UDA-SQL-0023 error connection to database has been terminated due to an unrecoverable

    Posted Fri January 15, 2021 08:38 AM

    Usual things to eliminate would be:

    1. Did a SQL statement fail such that ORACLE also killed the session server side
    2. Is the database closing idle connections in a shorter time period than when CA would release an idle pooled connection.
    3. They you may drift into the topic of networking causing the sockets to be closed etc


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

    Original Message