AnsweredAssumed Answered

Data extraction output is failing with group by error since 15.4 upgrade/ora 12c

Question asked by nchatterjee Employee on Apr 12, 2018
Latest reply on Apr 19, 2018 by nchatterjee

Hello Expertians,

Since we have upgraded to 15.4 (and Oracle 12c), we are seeing an weird behavior with CA Data extraction tool's output. We have been using it in 14.3 (with Oracle 11g) without issues and I am sure this is not a PWP/package error but more of an implementation error with the underlying SQL, but looking for some suggestions.

 

Long story short, one of the data extractions are failing since the upgrade with an error : [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00979: not a GROUP BY expression.

 

The SQL has correct group by expression: works still fine with 14.3/Ora 11g. Does anyone have the same error with data extracts since the migration to 15.4?

We are using SaaS.

 

Thanks in advance for your help/input!

 

 

DSomick : here you go !

Outcomes