Cognos Analytics

Cognos Analytics

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

 View Only
Back to discussions
Expand all | Collapse all

XQE-PLN-0222 COLUMNS OF TYPE BLOB ARE NOT PERMITTED IN A GROUP BY OR ORDER BY CLAUSE'

  • 1.  XQE-PLN-0222 COLUMNS OF TYPE BLOB ARE NOT PERMITTED IN A GROUP BY OR ORDER BY CLAUSE'

    Posted Fri September 25, 2020 07:20 AM
    Using native SQL in CA 11.1.7 thru JDBC connection getting the below error 
    XQE-PLN-0222 Columns of type BLOB are not permitted in a GROUP BY or ORDER BY clause.

    I believe there was PMR earlier older version .
    let me know your inputs 

    Thanks 
    Chandra 



    ------------------------------
    Chandra Medarametla
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: XQE-PLN-0222 COLUMNS OF TYPE BLOB ARE NOT PERMITTED IN A GROUP BY OR ORDER BY CLAUSE'

    Posted Sat September 26, 2020 08:09 AM
    You may be encountering a known issue in 11.1.7 , please open a ticket with support.

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

    Original Message


Related Content