Active Query Builder support area

AQB lose state/session after locking windows for a while

Avatar
  • updated
  • Completed

Hello,

I'm using version 2.10.6 of the AQB ASP.NET Edition.
I am using Windows 7 and Chrome ver. "48.0.2564.103 m".
We use the AQB by having in it an iframe, because we want to use it with Angular.
I experience that all the data in AQB dissapear when I do the following:
  • Start with an empty Design Pane
  • Add a table from the Database Schema Tree to the Design Pane and
  • Lock Windows for 20-30 min,
  • Unlock Windows again
  • Drag a new table on to the Design Pane
If I do this the data dissapear from the Database Schema Tree, Design Pane and the SQL Pane.
It seems as if it has lost all sense of its "state" or "session", and I wanted to hear if your guys might have an idea as to why this happends?
The worker thread on the IIS does not get recycled in this timespan(I log all recycle events), and the sessionState timeout is set to 60 minutes.
Avatar
Andrey Zavyalov, PM

Hi,

We successfully reproduced this (or similar) problem on our demo web site. We will investigate it and let you know about results shortly.

Avatar
Chris H.

Hello Sergey,

Great that it was reproducible(depending on how you look at it :-) ).

Is there any progress as to the reason it does this?

Best regards, Chris

Avatar
Andrey Zavyalov, PM

Hello,

We are internally testing the solution for this problem. Hopefully the fixed version will be released this week.

Avatar
Andrey Zavyalov, PM

Hello, Chris.

The fixed build is available for downloading. Please confirm if the problem is fixed on your side.

Avatar
Andrey Zavyalov, PM

Hello, Chris.


The bug is fixed in the latest version. You can download the fixed build now.

Avatar
Chris H.

Hello again,

The problem seems to have been fixed according to our initial testing :)

But the version of our product haven't gone through all the deployment phases with complete testing yet, so I might come back over the next week or two again, if it turns out the problem wasn't completely fixed.

But fingers crossed!

Chris H.

Avatar
Chris H.

Bad news, the bug still exists in some shape or form. This is what we did to reproduce it(on the same environment as descriped above):

  1. Paste in some SQL into the SQL pane to have a starting point.
  2. Wait 45 minutes( 9 action pings) - During this time the pc was locked for about 25 min in one stretch.
  3. Drag and drop a table from Schema Tree pane to Design pane. Everything went well with this. Moved table on design pane as well, and received another 2 action pings.
  4. Wait 35 minutes(7 action pings), while being logged in the whole time.
  5. Drag and drop another table, but this time I receive an error which says: "Error. An error occurred while processing your request.", after which the AQB component "disappear", and the only thing left is the error message.
  6. After refreshing the page, the only thing appearing is still just the error message.


Interested to hear if it is reproducible on your end :)

Avatar
Andrey Zavyalov

Hello,

It looks like an unhandled exception or some oher unexpected problem has occurred on the server side.

Possibly the reason of this problem was a session expiration, but there might be a different problem. As far as you said that the whole component had disappeared, it might be a problem of container element in which Active Query Builder resides in your project (an update panel or something like that).

We'd be glad to try to reproduce this problem if we have a test project in which it can be reproduced. For now we can only guess what happened...