IBM COGNOS 'sqlPrepareWithOptions' staus='-69' Error --- explaining the issue right!!!

I was working on a report where we needed some SQL based query subject that had to be joined in with metadata based query subject. Usually, I write the SQL queries on an editor; check it once and then put it on the report studio but this was one of those cases where I am trying to finish up things.

In the query I wrote, I had used   'max (case …..) 'Function; basic syntax on SQL query is that when we use an aggregate function we need to have a 'group by' function at the end. There is nothing new in this, the only thing that surprised me was that COGNOS error -69 details, explained the issue perfectly. I was so impressed, don't know why but made me happy. J