I have a report that has a sub report within it. It had been running correctly since it was placed on our reports server running verison 11.0.0.2205. I installed the SP for release 1 recently and since then, the report with a sub report would take over 7 hours to run on the schedule. If I try to run it on demand I get the following error:
Error
A request was cancelled. The necessary security privileges could not be verified. This indicates a problem with the security server.
It connects to 2 different ODBC data sources to pull in information in this reports.
Has anybody received a problem like this and if so, how have you resolved it?