Double entry

[dkrnetadmin]

Something weird......

We noticed in the web console 2 entries for 1 server. I launched the GUI and see the 2 entries but i can only select one.

Weird.....

[Hemoco]

Leo appears only once in the computer table, so some other data must be duplicate, can you see which one?

[dkrnetadmin]

more duplicate entries today. one xp workstation shows up 9 times.

[dkrnetadmin]

Here is both.

let me know if you prefer a table other than tblComputers

[Hemoco]

Yes, or a screenshot where you see the data double.

[dkrnetadmin]

table extract? does that mean copying data from sql table?

[Hemoco]

Could you post a screenshot or table extract please. (if possible)

[dkrnetadmin]

These entries appeared in errorlog.txt regarding this server:

10/23/2008 1:32:11 PM : LEO
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_tblsyslastscan'. Cannot insert duplicate key in object 'dbo.TsysLastscan'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Lansweeperservice.sweeperthread.UpdateLastScan(clsComputer mycomputer, String section, clsThreadinfo Threadinfo, SqlConnection& sqlcon, DateTime startdate)
-------------------------------------------------------------------------
10/23/2008 1:32:15 PM : LEO
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_tblsyslastscan'. Cannot insert duplicate key in object 'dbo.TsysLastscan'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Lansweeperservice.sweeperthread.UpdateLastScan(clsComputer mycomputer, String section, clsThreadinfo Threadinfo, SqlConnection& sqlcon, DateTime startdate)