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.
How can I mitigate this?
Can I detect that it is already happening somewhere an stall the execution?