Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  error with memory

    Posted 01/18/22 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 01/18/22 11:40 PM

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



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