Unknown Error

[bowened]

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!

[david.stachon]

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.

[bowened]

Thank you! Works like a charm

[luka80]

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?

[Kanchana]

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

[mahi_lvs]

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

[vdimarco]

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?