Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  error with memory

    Posted Tue January 18, 2022 11:41 AM
    I am getting following error after running report:

    XQE-DAT-0001 Data source adapter error: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [4]: cannot allocate enough memory: search table error: [9] Memory allocation failed;exception 1000002: Allocation failed ; $size$=3045523072; $name$=Results; $type$=pool; $inuse_count$=388; $allocated_size$=204815988464; $alignment$=8; $failure_type$=STATEMENT_MEMORY_LIMIT; $failure_flag$= ,Exception in executor plan17559501

    ------------------------------
    Priyanka Joshi
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: error with memory

    Posted Tue January 18, 2022 11:40 PM

    You should discuss with SAP or your Hana Admin, re Hana server failing the statement it is being sent.



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

    Original Message