COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: bowened on 27 Jan 2009 12:03:51 PM

Title: Unknown Error
Post by: bowened on 27 Jan 2009 12:03:51 PM
Hello all...I'm trying to validate a report and I get this error that I can't track down:

RSV-VAL-0010 Failed to load the report specification. CCL_ASSERT_NAMED(m_bAllRowsOptimization == FALSE, "The master dataset cannot be re-used for a second iterator if AllRows optimization was applied when the query was executed.");

Can anyone help?

Thanks!
Title: Re: Unknown Error
Post by: david.stachon on 08 Feb 2009 04:13:58 PM
Yes! ...I can help. I just came across the same issue while doing an upgrade from 1.1 to 8.3.

For some reason, during the upgrade an invalid master detail relationship is being created between (in my case) the list and the page...and, it was between the same query.

to fix, simply select the "Page" object and set the "Query" to default. (for some reason on my upgrade, the same query as the list was being applied to the page).

...this will then remove the master detail relationship and you should be good to go.
Title: Re: Unknown Error
Post by: bowened on 09 Feb 2009 10:23:58 AM
Thank you! Works like a charm
Title: Re: Unknown Error
Post by: luka80 on 22 Jul 2009 06:15:05 AM
Hi david, i have the Error

RSV-VAL-0010 Failed to load the report specification. CCL_ASSERT_NAMED(m_bAllRowsOptimization == FALSE, "The master dataset cannot be re-used for a second iterator if AllRows optimization was applied when the query was executed.");

I try your solution, the "Page" Query is Default and i don't understand what is the problem. When i lunch report it work but when i try to validate i have that error.

Another idea?
Title: Re: Unknown Error
Post by: Kanchana on 18 Jun 2012 10:19:19 AM
Hi

Did you figure out how to fix the issue? I have the same problem and the baove solution wont work.. any suggestion will be appreciated
Thank you
Title: Re: Unknown Error
Post by: mahi_lvs on 08 Mar 2013 12:09:50 AM
Thanks david.stachon,

Your solution got worked for me.:)

I got the same issue while Upgrading from 101.1 to 10.2
During upgrade an invalid master detail relationship has being created between a list and another list (nested list) it was between the same query.

To Fix this I removed the Masterdetail relationship link.
and It validated fine.

Thank you.
Mahesh
Title: Re: Unknown Error
Post by: vdimarco on 01 Oct 2013 06:44:36 PM
Same issue here! Upgrade from 10.1 to 10.2.1 resulted in a troubled active report. Most of the difficulties surrounding this mysterious, newly appearing master-detail relationship seem to be the root cause in one particular chart and query.

Any ideas?