Forum Discussion
Swoop
12 years agoFrequent Contributor
Anik, I have come across this issue and opened a ticket with SmartBear support. The problem lies in that the user's UserId value never makes it to the actual SQL, which is why you see "...WHERE UserID = AND..." when it should look something like "...WHERE UserID = 20132 AND..."
I've recorded the problem so they can see exactly what I'm trying to describe in the ticket.
I've recorded the problem so they can see exactly what I'm trying to describe in the ticket.
Thanks Kurtis for the follow-up. The problem is that when we click on the link to kick someone out, no matter who, we obtain an error message "An error occurred while processing your request and has been logged with the System Administrator. If you continue receiving this error message, please contact Support".
In the Report-Administrative-Error Logs, I get this error details :
[0][0][0]Invalid SQL:
UPDATE PersonLogins SET DateLogout = GETDATE(), LoggedOutBy = 'Cadieux, Anik ' WHERE UserId = AND DeptId = 8162 AND DateLogout Is NULL
UPDATE Persons SET IsLoggedOn = 'N' WHERE UserId = AND IsLoggedOn = 'Y'
If you have any clue, thanks for letting me know !
Related Content
- 2 years ago
- 11 years ago
Recent Discussions
- 24 days ago