Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cygnex on 23 Apr 2009 11:48:43 AM

Title: QueryReuse: the generated sql is not supported locally
Post by: cygnex on 23 Apr 2009 11:48:43 AM
I receive this error when I run a list report with a chart.  If no records match user provided criteria, I receive the message above.  When I remove the chart from the report and return no records I do not receive this error.  Is there a way to just show a blank chart if there are no records to display, like the the list does?
Title: Re: QueryReuse: the generated sql is not supported locally
Post by: Arun.J on 24 Apr 2009 02:52:31 AM
Try the following settings in the Query Properties

use local cache : N0
Processing : limited Local
Rollup processing : Extended / Local

Arun.J
Title: Re: QueryReuse: the generated sql is not supported locally
Post by: cygnex on 26 Apr 2009 12:45:01 PM
Friend,

Thank you for your help.  I tried just the first choice "use local cache : N0" and that fixed the problem. Can't thank you enough.

Cheers...
Title: Re: QueryReuse: the generated sql is not supported locally
Post by: LisaSullivan on 20 Jul 2009 11:11:08 AM
Hello,
Thanks for this posting. This has been driving me crazy.  I also just added the use local cache to no and it worked.  I did it for each chart on the report.  Thanks so much. Lisa
Title: Re: QueryReuse: the generated sql is not supported locally
Post by: Jaeha on 09 Jun 2010 04:05:19 AM
Hey! This problem was driving me crazy too. Just setting 'use local cache' value to 'no' stopped the problem. Thanks a lot!
Title: Re: QueryReuse: the generated sql is not supported locally
Post by: Julien on 10 Jul 2012 10:00:57 AM
same issue, same solution
Was stuck with this ***** :o RQP-DEF-0526 error and got it solved thanks to "local cache" feature on my union qry

Thanks dudes !!!
Julien
Text only | Text with Images