Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

“Logged On Users” view/REP_SESSION always contain only one raw.

Highlighted
Kazarin Alexand
Occasional Visitor

“Logged On Users” view/REP_SESSION always contain only one raw.

Hi all. I have such problem. There is only one raw in Audit “Logged On Users” view. However in the system can work several users at one moment. The REP_SESSION table contains the same one raw – first logged on account. After another account logged, in the logserver.txt error appears: “JDBC error 2601: [MyServerHostName]Cannot insert duplicate key row in object 'REP_SESSIONS' with unique index 'SES_SERVER_IPADDRESS_IX'., SQL state: 23000 for query: INSERT INTO rep_sessions”. How can I fix this?

HP OVSD4.5 SP18 MSSQL2000
http://linkedin.com/in/alexanderkazarin
1 REPLY
Kazarin Alexand
Occasional Visitor

Re: “Logged On Users” view/REP_SESSION always contain only one raw.

How I can understand, the primary error is that the system think SES_SERVER_IPADDRESS_IX field is unique for raw and cannt insert another raw. Is it normal?
http://linkedin.com/in/alexanderkazarin
//Add this to "OnDomLoad" event