COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: xlnt on 23 Dec 2009 09:52:36 AM

Title: ORA-32035: unreferenced query name defined in WITH clause
Post by: xlnt on 23 Dec 2009 09:52:36 AM
All our reports are failing with the above error.

Database used is Oracle 10G.

If I set the 'Use SQL With Clause' option to 'No', the reports start working fine.

Please can somebody help with this:

1. Why all reports are failing with this error (approx 30 reports)
2. Instead of changing the value of the above property to 'No' for each query in all these reports - can I change it at a global level?
Title: Re: ORA-32035: unreferenced query name defined in WITH clause
Post by: MFGF on 23 Dec 2009 10:44:42 AM
Hi,

It can be set in Framework Manager - Project -> Edit Governors if memory serves.

You would then need to re-publish your package(s).

MF.