If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

'MDO-ERR-0002 Not able to correctly prepare the decomposed query'

Started by DayTripper3, 04 Feb 2010 10:29:30 AM

Previous topic - Next topic

DayTripper3

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?

MFGF

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.
Meep!

DayTripper3

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'