Analytics Software

I was getting the below error while running a workbook.

OracleBI Discoverer Viewer was unable to find the necessary data for displaying the results of this event. Please correct any errors and try again.
- Session closed

I have found some solutions for this but none is applicable to us.

Viewer is integrated in Oracle Applications as one of the menu functions and is launched from there. And while running one of the workbooks i was getting this error. I have exported the workbook from one instance to another, it works fine in one but not in the later. Both of these instance are using Discoverer 10.1.2.2

Strangely this works fine in discoverer desktop.

There are some calculation in the workbook which involve both aggregate and non-aggregate values, and there are totals which use these calculations. When i remove the totals of non-aggregate columns the workbook runs fine. So i am not sure what is causing the problem as it works fine in other instance.

I spent a lot of time analyzing this with no luck, any suggestions will be greatly appreciated.

Thank you.