I have created an Invoiced Sales report for the SD module based on a multiprovider. This Multiprovider is made up of DSOs containing Billing Item and Pricing Conditions respectively.
The Problem (which is evident only in Production) arises when the User makes Selections for a large span of months. The report eventually times out when viewd in the Portal. When we run the report using RSRT or RSRT2 we get messages
Query 0: Runtime error Time limit exceeded with parallel processing via RFC
Error reading data: Navigation is possible.
There are other reports based on the same Multi prov, however they are not giving the same problem. I have created a copy of this problem report and executed the same in production, but the problem persists.
Please let me know if someone has encountered similar problems