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