Report deployment error - ORA-00979: not a GROUP BY expression

[captain karisma]

Hi guys,

Wonder if anyone can give any hints. On 8.1 with oracle 10g.

In dev, i have an environment with a report which works fine. I deploy the report package to prod. Same version, same OS, same oracle driver versions.

But on prod, when i run the report i get an ORA-00979: not a GROUP BY expression  error.
If i edit the report and remove a substring expression, i can get the report to run.

But for future development and deployment , i need to find out why cognos is interpreting the SQL differently.
I remember in impromptu there used to be corresponding oracle files you can configure, is there something similar in cognos 8, as there must be something inherently different between the 2 environments

Thanks