IBM Business Analytics

 View Only
  • 1.  ERROR XQE-PLN-0222

    Posted Mon April 15, 2024 10:39 AM
      |   view attached

    Hi Dears,

    I am having an error while running the report. Please suggest to me how I can handle this.

    Attached is the screenshot of the error

    Thanks

    Regard,

    Anas Ghayas



    ------------------------------
    Anas Ghayas
    ------------------------------


  • 2.  RE: ERROR XQE-PLN-0222

    Posted Thu April 25, 2024 07:20 AM

    Your query includes at least one item (column reference or calculation) whose data type is considered to be of type BLOB.
    The query is attempting to GROUP (i.e. auto group and summarize) the data and detecting the BLOB type.
    BLOB data types cannot be used in various SQL operations including GROUPING etc.
    CA itself does not render BLOBS.

    I suggest you review removing the BLOB column from your query.



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