Bug Report T289507
Visible to All Users

DashboardSqlDataSource - All queries are cancelled if an exception is raised during any query execution

created 9 years ago (modified 9 years ago)

Hi,

I have a dashboard with a DashboardSqlDataSource

My DashboardSqlDataSource is named: "Indicadores" and have three sqls: ***"My Cube A"***, "My Cube B" and ***"My Cube C"***.
Opening the dashboard, the designer load all fields of the all sqls…

But, when I force a exception in "My Cube A" the other slqs are not loaded.

Its possible load the others sqls even when a sql launch exception?

Thanks !
Alysson Guimarães - Sisloc Softwares LTDA.

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

    We have significantly updated the data processing engine in the Dashboard Suite version 15.1. Now all queries are loaded at once from different threads. If exception is raised during any query loading, we stop loading at all and show exception immediately, since it allows to avoid delay. Would you please clarify why approach used in the previous version with full data loading were better for you task, and we will consider this functionality implementation in the current suite version.

    SS SS
    SISLOC Softwares 9 years ago

      The system allow the user create and edit any sql to use in your dashboard. The sqls are stored in a table of my database. The application is multi-user, various users at the same time.
      Now I have two sqls in my table, when user create a dashboard, he can select any sql of the DashboardSqlDataSource.
      My Sql A (select * from tableA)
      My Sql B (select * from tableB)
      So, I have two dashboards: Dashboard A - Created by User A and Dashboard B - Created by User B
      In Dashboard A, User A selected My Sql A.
      In Dashboard B, User B selected My Sql B.
      The users finished the edition and closed the dashboards (A and B)
      User A return the edition of Dashboard A and change the My Sql A and this change causes errors
      Example of change:
      MySql A (select * tableA)
      When User B open the Dashboard B, the Dasboard B not work more because My Sql B not load even though no errors, but because My Sql A caused exception.

      DevExpress Support Team 9 years ago

        Thank you for the clarification. It will require some time to research the task in greater detail. I have passed this issue to our developers for further research. We will update the thread once we have any results.

        Answers approved by DevExpress Support

        created 9 years ago (modified 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.