I have a user who gets this error message each time he logs in. Does anyone know a way to kill his 'other' session?
Check TX_MACHINE_LOCATION and look up the account in question. If the session didn't close properly, the Last Login Dt will be more recent than Last Logout Dt. If you delete the value for Last Login Dt, that should let the user get back in.
Thanks Christan,
He has been able to log in once I increased his logins allowed to 2.
The last logout date is after the last login date.
Ed
If you increased his allowed logins, there should now be two records in TX_MACHINE_LOCATION. Might still be worth investigating the older record. Rather than delete one of the dates in the table, I usually just alter the values so the system thinks the user logged out.