Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Timeouts for Queries...
Tue, May 9 2023 7:53 PMPermanent Link

Ian Branch

Avatar

Hi Team,
I run this code in my Apps.
{sql}
SELECT runsum(1), * FROM Configuration.ServerSessions
Group by ID
order by ID
{sql}
It is run in an EDBQuery.
Trouble is, with a lot of Users and therefore    Apps running, I am getting the following condition..
"Cannot execute Session Query table tqServerSessions, another user has the table open already.
90% of the time there is no issue but every now and then I get a spate of them.  All about the timing. Wink

How can I mitigate this?
Can I detect that it is already happening somewhere an stall the execution?

Regards & TIA,
Ian
Tue, May 9 2023 8:16 PMPermanent Link

Ian Branch

Avatar

Disregard.  Already answered.

Regards & TIA,
Ian
Image