I ran an import from 8.3 to 8.4.1 and when I upgraded all reports and ran this one list/chart report, I got the error MDO-ERR-0002 Not able to correctly prepare the decomposed query 'Query 3 List/Chart'.
Query 3 is a join query..could this be the issue? I removed the list/chart query and the report validates just fine..of course.
Any ideas?
If you re-create the join query in Report Studio 8.4.1, do you still get an error? It's possible the error may have been the result of poorly formed XML from the upgrade.
MF.
Figured out what the problem was..I ended up redoing the query and noticed that a data item 'Total' which was calculated in 8.3, blew up in 8.4.1. Didn't matter if I deployed it from 8.3 or opened xml into new report..same error until I changed the Aggregation properties to Total and 'Calculated' or 'Automatic'