"Query opening was canceled during data fetching"
Posted: Wed 06 Feb 2019 23:07
Can anyone shed light on how I can accurately identify what activity within my application could be causing the error message "Query opening was canceled during data fetching" to appear.
I am using Change Notification in my Delphi application and from time to time this message appears. I have the source code version of SDAC but that always traces back to an alternate thread and when I breakpoint the OnChange event of the MSChangeNotification component it does not correspond to any code in the event.
The issue appears to be connected with the timing between commit statements and I suspect it has a lot to do with the number of entries that need to be processed in the notification queue but as I am inexperienced in these matters I would like to understand the process better.
Also, is there a way I can initiate the processing of messages that may be in the notification queue rather than waiting for the notification queue thread to apply them?
Any help you can provide would be greatly appreciated.
Bryn
I am using Change Notification in my Delphi application and from time to time this message appears. I have the source code version of SDAC but that always traces back to an alternate thread and when I breakpoint the OnChange event of the MSChangeNotification component it does not correspond to any code in the event.
The issue appears to be connected with the timing between commit statements and I suspect it has a lot to do with the number of entries that need to be processed in the notification queue but as I am inexperienced in these matters I would like to understand the process better.
Also, is there a way I can initiate the processing of messages that may be in the notification queue rather than waiting for the notification queue thread to apply them?
Any help you can provide would be greatly appreciated.
Bryn