duplicate session id in session_log

Document ID : KB000006848
Last Modified Date : 03/08/2018
Show Technical Document Details
Issue:

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

>>

 

Environment:
Service Desk 12.9 and 14.1Windows 2008R2 and windows 2012
Cause:

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.

Resolution:

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

Additional Information: