Receiving a "Failed to project" error running a query in MetaMatrix

Solution Verified - Updated -

Issue

  • The following query gives a "Failed to project" error. I'm sure I'm doing something wrong but I can't figure out what it is: 
    • SELECT  COUNT(*), SUM(claim_amount), customer_id, YEAR(adjudication_date)AS adjudication_year, MONTH(adjudication_date) AS adjudication_month
      FROM Common.Audited_Claim
      WHERE error_type IS NULL
      GROUP BY customer_id, YEAR(adjudication_date), MONTH(adjudication_date)
      
  • Receive "Failed to project" error when executing virtual procedure, but running the same SELECT statement outside of the procedure succeeds
  • Executing SELECT statement with function in GROUP BY results in "Failed attempting to project" error:
    Failed attempting to project <column> from {...}
    

Environment

  • MetaMatrix Enterprise Server 5.5.2

  • MetaMatrix Enterprise Server 5.5.3

  • SQL statement includes function in GROUP BY

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In