Jump to content

UniDbGrid freezing session, masked screen


monheim

Recommended Posts

Hi everyone.

Dear friends, I use Database MS SQL Server and ADOConnection/ADOQuery in my project. According manual and recomendations I create ADOConnection on MainModule (so one connection for each session) and use it in frames and forms and also in main form. Main form contains two UniDbGrids and after session started all works fine. But after I click some records, positioning on Grids my session freezes... Or became work very slow and freezes...  Freezes only current session, after refreshing all works but repeat the same behavior after performing same actions.

I found some errors in Connection log I think raise such behavior...

Failed Sequence Recovery: SeqId: 206, Event: select
Sequence Error Timeout : TDiff:10015, Event: select, Expected: 205, Received: 208

Searching the forum I found similar messages from others but couldn't found decision for me. I verified database connection and queries, it's works properly. I suppose the reason is in UniDbGrid. It displays data from ADOQuery (ADOQuery - DataSource - UniDbGrid). I think may be it provokes hanging database connection. It fetching records and connection is already open dusing session. In RAD Studio event log I see many threads created during this hanging. Screen is masked in this time.  

Tested on Trial 1.0.0.1384 RC and ask to test on Complete Professional 1.0.0.1384 RC, result is the same...

Great Thanks You for attention!

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...