Bug Report T298444
Visible to All Users

Data Access Library - An unhandled error occurs when reloading data if the data loading procedure was cancelled at runtime

created 9 years ago

Hi,

I have a problem that if you click cancel on the data loading dialog that appears after you select your parameters on the dashboard viewer and then try to refresh the dashboard again the datareader is not being terminated and the error appears like below:

Connection name: Test
Error message:
There is already an open DataReader associated with this Command which must be closed first.

The connection will eventually finish processing the data from the datasource and then you can run it again, but the idea of cancelling it is not working.

I have also noticed that the Report Designer also has this behaviour, but not the Report Viewer which you can press stop on the data loading at the bottom and it actually stops the datareader.

Also the data loading dialog on the Dashboard Viewer can go behind the form with Viewer on it, is there any way to prevent this or not show this dialog and handle the loading progress yourself?

Thanks
Craig

Show previous comments (12)
DevExpress Support Team 9 years ago

    Just a follow-up. We have also made a similar test using the next major version of DevExpress assemblies that are currently in the production state (v15.2) and found that it is not affected by this problem. Please let us know if you prefer to have this problem fixed in the current version (v15.1) and we will check for a suitable solution.

    CS CS
    Craig Smith 12 9 years ago

      Hi Alex,
      That is good that you have reproduced the problem. Will the next major release be a long time away? if not more than a week or so i'll wait otherwise I would like to get a release done by then. As the original post said I could see the same problem in the report designer and the dashboard viewer, is this fix to the library going to fix all the controls affected?

      Dmitry Tokmachev (DevExpress) 9 years ago

        Hello Craig,

        The next major release is scheduled for approximately late November or the beginning of December, so we're not going to ship a new version in the next few weeks. I've forwarded this thread to our R&D team to fix this issue in version v15.1.
        Please watch for our updates in this thread.
        Thanks,
        Dmitry

        Answers approved by DevExpress Support

        created 9 years ago

        We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.

        Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.