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

    Posted Fri August 23, 2019 04:27 AM
    We are experiencing intermittent report failure when event is running with below error message:

    XQE-DAT-0001 Data source adapter error: com.ibm.cognos.jdbc.adaptor.sqlexception.SQLCognosUnrecoverableConnectionException: [jcc][t4][2055][11259][3.67.27] The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated this particular request due to unexpected error conditions detected at the target system. ERRORCODE=-1224, SQLSTATE=55032

    On re running the reports are running.

    ------------------------------
    Prashant Mathur
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: XQE-DAT-0001 Data source adapter error

    Posted Tue August 27, 2019 10:22 AM

    Can I recommend that you upgrade from the old version of IBM JCC you are using.

    Note JCC includes the version 3.67.27

    Older versions were not certified by DB2 team with Java 8, may run into SSL errors etc.

    https://www-01.ibm.com/support/docview.wss?uid=swg21363866



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