Hi,
I'm relatively new to Telerik reporting but having a strange problem with some reports I have created.
I created a report based on an object data source that I am returning from a WCF RIA service and the report worked well. I then started to make some amendments to it, and one amendment was to include another object data source that returns a list from the same WCF RIA service to use as parameter lookup values.
Now when I run the report I get a strange message as follows:
An error has occurred while processing Report 'StatisticsReport': An error occurred while invoking data retrieval method. ------------- InnerException ------------- Exception has been thrown by the target of an invocation. ------------- InnerException ------------- An error occurred while executing the command definition. See the inner exception for details. ------------- InnerException ------------- There is already an open DataReader associated with this Command which must be closed first.
The first odd thing is that I also added another report which does exactly the same thing (2 object data sources, 1 for the report data source and another for the parameter lookup) and it works fine. The report data source object is different, but the lookup one is the same.
The second odd thing is that both reports run fine when I run it locally (VS 2013 with SQL Express 2012) but I'm getting the issue when I publish the site to Azure. The original report was definitely working on Azure the first time I published it, but now it doesn't and the second report works fine both locally and on Azure.
Any ideas?
Thanks,
Richard
I'm relatively new to Telerik reporting but having a strange problem with some reports I have created.
I created a report based on an object data source that I am returning from a WCF RIA service and the report worked well. I then started to make some amendments to it, and one amendment was to include another object data source that returns a list from the same WCF RIA service to use as parameter lookup values.
Now when I run the report I get a strange message as follows:
An error has occurred while processing Report 'StatisticsReport': An error occurred while invoking data retrieval method. ------------- InnerException ------------- Exception has been thrown by the target of an invocation. ------------- InnerException ------------- An error occurred while executing the command definition. See the inner exception for details. ------------- InnerException ------------- There is already an open DataReader associated with this Command which must be closed first.
The first odd thing is that I also added another report which does exactly the same thing (2 object data sources, 1 for the report data source and another for the parameter lookup) and it works fine. The report data source object is different, but the lookup one is the same.
The second odd thing is that both reports run fine when I run it locally (VS 2013 with SQL Express 2012) but I'm getting the issue when I publish the site to Azure. The original report was definitely working on Azure the first time I published it, but now it doesn't and the second report works fine both locally and on Azure.
Any ideas?
Thanks,
Richard
1 Answer, 1 is accepted
0
Hello Richard,
The error bubbled in the report comes actually from the underlying data retrieval method. Check if the method can return multiple result sets for the different calls, and if resources for the data retrieval are properly released after being used.
If you need further, please open a support ticket and send us a runnable demo project where the problem is isolated and reproducible.
Regards,
Stef
Telerik
The error bubbled in the report comes actually from the underlying data retrieval method. Check if the method can return multiple result sets for the different calls, and if resources for the data retrieval are properly released after being used.
If you need further, please open a support ticket and send us a runnable demo project where the problem is isolated and reproducible.
Regards,
Stef
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.