Duplicate session id in session_log table
We may see this error message in the stdlog
<<
boplgin 13424 SIGNIFICANT bplaccess.c 7521 Rejecting duplicate session ID 576895399 as it already exists in session_log
>>
Service Desk generate session id randomly. When the session_log table is very big, we have the duplicate error. The application nee to retry to connect and a new session id will be used.
This behavior impact the login performance.
Service Desk 12.9 and 14.1
Service Desk Manager 17.x
The archive/purge is needed to delete old rows not any more needed.
Reduce the rows in session_log table resolve the duplicate session_id and also positively impact on the performance for login process updating smaller session_log table.
Follow this tecdoc to archive and purge the session_log table
https://comm.support.ca.com/kb/archive-and-purge-sessionlog/kb000046910
Information stored in the session_log table
https://comm.support.ca.com/kb/archive-and-purge-sessionlog/kb000046910