Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  After upgrade from 11.2.4 to 12.1.1 Transformer failing on large query - other cubes okay - see defect DT443193

    Posted Thu April 23, 2026 11:20 AM

    We recently upgraded to 12.1.1 IF1 (from 11.2.4).  We use Transformer in Cognos and build several cubes.  One of the cubes has a large query, and it is failing consistently since the upgrade.  I found reference to a defect DT443193 ( https://www.ibm.com/mysupport/s/defect/aCIgJ0000002IAX/dt443193?language=en_US).  The article states that this defect is fixed in 12.1.1 but for us it was working until we upgraded to 12.1.1.

    Are there other sites experiencing this same problem, and if so, have you resolved it and would you share those solutions please?  We have an open case with IBM but it is going on two weeks now that one of our cubes is failing to refresh.  Others are working fine.

    I appreciate any insights you may offer.



    ------------------------------
    Penny Flower
    ------------------------------


  • 2.  RE: After upgrade from 11.2.4 to 12.1.1 Transformer failing on large query - other cubes okay - see defect DT443193

    Posted Fri April 24, 2026 02:13 PM

    Hi Penny, 

    Can you share the error message that you are receiving once it fails? 



    ------------------------------
    John Cusack
    Analytica iQ
    ------------------------------



  • 3.  RE: After upgrade from 11.2.4 to 12.1.1 Transformer failing on large query - other cubes okay - see defect DT443193

    Posted Tue April 28, 2026 10:04 AM

    The Transformer log shows:  XQE-CON-0007 XQE error encountered: NO_NODES_TO_FORWARD_TO

    There are a few more details after that line, requestId, sessionId, and the server name.  The server name is the server running the content manager and the dispatcher.  We have always run Transformer on a different server.



    ------------------------------
    Penny Flower
    ------------------------------

    Original Message


  • 4.  RE: After upgrade from 11.2.4 to 12.1.1 Transformer failing on large query - other cubes okay - see defect DT443193

    Posted 24 days ago

    Hi,

    In our environment, this message "NO_NODES_TO_FORWARD_TO" occurs in two situations: dispatcher is not responding (may fall) or queue time limit has reached. 

    I told IBM that message is not clear.


    Anyway, your cube is fetching data using CQM or DQM?

    I have large cubes with large query results that fetches data using CQM. 
    When using CQM, data is fetched by Transformer engine and processed locally. When using DQM, query is fetched using Query Service of dispatcher configured in Cognos Configuration of Transformer install and is worst in terms of performance. 
    Maybe you're using DQM and your dispatcher is falling when retrieving results from database and sending to Transformer.



    ------------------------------
    Jeam Coelho
    Cognos Solution Architect

    IBM Champion

    LinkedIn: https://www.linkedin.com/in/jeamcoelho/
    ------------------------------

    Original Message


Related Content