Phantom Users in ASA 11

[Former Member]

We have some customers that have been reporting "phantom users". When they look at connected users they see people that have not only closed the software app, but have also shut down their computer.

We are using SQLA version 11.01 We start the ddsrv11.exe with the following parameters... -x tcpip -ti 0 -tl 0

Could these parameters cause connections to remain open even when people have shut down their computer?

TIA, Mike

[jeff_albion]

Yes, I believe this is certainly a possibility. -ti 0 disables the Idle Timeout check (which normally engages after 240 minutes if we haven't heard from a client to automatically disconnect the client), and -tl 0 disables the Liveness check (which is the only mechanism available to the server to check the active client connectivity).

If you do not explicitly close the database connection (e.g. the network drops off, do not explicitly 'close' a connection in your program, etc.), then this could be the behaviour you're seeing.

You should be able to drop the connections using the DROP CONNECTION statement.

---

We have also had previous problems with "[Exchange]" workers, from intra-query parallelization queries and we left 'phantom' users connected that could not be dropped. This was fixed in a later patch (11.0.1.2786 and above).

[Former Member]

Thanks for the reply. We will change these values.