2014/04/07 05:57:32 [201] INFO Discovery.DataCollection.ScanManager - Total IPs scanned = 52 2014/04/07 05:57:32 [201] INFO Discovery.DataCollection.ScanManager - Deep scan conducted on 0 IP(s) 2014/04/07 05:57:32 [201] INFO Discovery.DataCollection.ScanManager - Time taken 22 sec. 2014/04/07 05:57:32 [201] INFO Discovery.Topology.DeviceIdentificationAndMerge - Scan added 0 Device(s) 2014/04/07 05:57:32 [201] INFO Discovery.DataCollection.ScanManager - Scanning device statuses for all devices 2014/04/07 05:57:33 [201] INFO Discovery.DataCollection.ScanManager - Scanning device statuses for all devices done 2014/04/07 05:57:33 [201] INFO ExpertSystem.ActionManagers.ActionNwkScan - Scanning completely done - time taken: 23 secs. 2014/04/07 05:57:33 [201] ERROR OM.ExpertSystem.Device - Error updating DeviceID = 29 DataAccess.Sql.SqlHelperException: [Sql= UPDATE Device SET Status = @status , MAC = @mac , DNSName = @dnsName , SnmpName = @snmpName , SnmpHash = @snmpHash , BiosOSHash = @biosOSHash , WmiEnabled = @wmiEnabled , SnmpEnabled = @snmpEnabled , SshEnabled = @sshEnabled , OSType = @osType , Description = @description , TimeLastUpdate = @timeLastUpdate , TimeLastUp = @timeLastUp , MachineName = @machineName , AMTEnabled = @amtEnabled , StaticIP = @staticIP , IsManaged = @isManaged , NetbiosName =@netbiosName , IPAddresses =@ipAddresses , IsRespondingToArp = @isRespondingToArp WHERE DeviceID = @deviceID Sql] [Arguments: @status=up; @mac=C8:60:00:C8:61:88; @dnsName=; @snmpName=; @snmpHash=0; @biosOSHash=-1; @wmiEnabled=True; @snmpEnabled=False; @sshEnabled=False; @osType=16; @description=; @timeLastUpdate=4/7/2014 9:57:33 AM; @timeLastUp=4/7/2014 9:57:33 AM; @machineName=PC-05; @amtEnabled=False; @staticIP=False; @isManaged=True; @deviceID=29; @netbiosName=PC-05; @ipAddresses=10.66.1.12; @isRespondingToArp=True; Arguments] [INNER_EXCEPTION: The UPDATE statement conflicted with the FOREIGN KEY constraint "OSType_Device_FK1". The conflict occurred in database "Data", table "dbo.OSType", column 'ID'. The statement has been terminated. INNER_EXCEPTION] ---> System.Data.SqlClient.SqlException: The UPDATE statement conflicted with the FOREIGN KEY constraint "OSType_Device_FK1". The conflict occurred in database "Data", table "dbo.OSType", column 'ID'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command) at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command) at DataAccess.Sql.SqlHelperGeneric.ExecuteNonQuery(String commandText, DbParameter[] parameterValues, Int32 timeoutInSeconds) in c:\Builds\41\Sources\Common\DataAccess.Sql\SqlHelperGeneric.cs:line 486 at DataAccess.Sql.SqlHelperGeneric.ExecuteQueryList(ParameterizedQueryList queryList) in c:\Builds\41\Sources\Common\DataAccess.Sql\SqlHelperGeneric.cs:line 422 --- End of inner exception stack trace --- at DataAccess.Sql.SqlHelperGeneric.ExecuteQueryList(ParameterizedQueryList queryList) in c:\Builds\41\Sources\Common\DataAccess.Sql\SqlHelperGeneric.cs:line 417 at DataAccess.Sql.SqlHelperGeneric.ExecuteQueryListInTransaction(ParameterizedQueryList queryList, TransactionScopeOption scope, IsolationLevel isolation) in c:\Builds\41\Sources\Common\DataAccess.Sql\SqlHelperGeneric.cs:line 450 at OM.ExpertSystem.DataProviders.ExpertSystemDataProvider.UpdateDevice(Int32 deviceID, String pingStatus, String mac, List`1 dnsName, String snmpName, Int32 snmpHash, Int32 biosOSHash, Boolean wmiEnabled, Boolean snmpEnabled, Boolean sshEnabled, OSType osType, String description, DateTime timeLastUpdate, Nullable`1 timeLastUp, String machineName, Boolean amtEnabled, Boolean staticIP, Boolean isManaged, String netbiosName, String ipAddresses, List`1 networkAdapterList, List`1 amtInterfaceDescriptorList, Boolean isRespondingToArp) in c:\Builds\41\Sources\OMSolution.root\OMSolution\OM.ExpertSystem\DataProviders\ExpertSystemDataProvider.cs:line 2810 at OM.ExpertSystem.Device.Save() in c:\Builds\41\Sources\OMSolution.root\OMSolution\OM.ExpertSystem\Device.cs:line 744 at OM.ExpertSystem.Device.Update(DiscoveryEngine discoveryEngine, Device Device) in c:\Builds\41\Sources\OMSolution.root\OMSolution\OM.ExpertSystem\Device.cs:line 734 2014/04/07 05:58:26 [39] INFO PowerManagement.OM.PowerEvents.PowerEventStateMachine - CreatePowerStatistics : generated 2 power statistic records for device 03-PC 2014/04/07 06:02:33 [185] INFO ExpertSystem.ActionManagers.ActionNwkScan - Starting a Discovery scan of 52 IP addresses... 2014/04/07 06:02:33 [185] INFO Discovery.DataCollection.ScanManager - Full Scanning all endpoints because scanindex = 3084 2014/04/07 06:02:33 [185] INFO NetworkTools.Icmp.DefaultIcmpProvider - Address uint172097834, Subnet uint 4294967040 2014/04/07 06:02:36 [224] INFO Discovery.Protocols.Ssh.SshScan - Successfully SSHed into 10.66.1.11 2014/04/07 06:02:36 [157] INFO Discovery.Protocols.Ssh.SshScan - Successfully SSHed into 10.66.1.8 2014/04/07 08:00:30 [103] INFO Log - DeviceID: 4 Log Entry ID: dc125303-4e76-407f-b5e7-ef6962e55c95 Time of Entry: 4/7/2014 8:00:30 AM Error Code: E10205 Application: System Details: 2014/04/07 08:02:32 [185] INFO ExpertSystem.ActionManagers.ActionNwkScan - Starting a Discovery scan of 52 IP addresses... 2014/04/07 08:02:32 [185] INFO NetworkTools.Icmp.DefaultIcmpProvider - Address uint172097834, Subnet uint 4294967040 2014/04/07 08:02:33 [96] INFO Discovery.Protocols.Ssh.SshScan - Successfully SSHed into 10.66.1.14 2014/04/07 08:02:33 [40] INFO Discovery.Protocols.Ssh.SshScan - Successfully SSHed into 10.66.1.10 2014/04/07 08:02:33 [33] INFO Discovery.Protocols.Ssh.SshScan - Successfully SSHed into 10.66.1.8 2014/04/07 08:02:33 [105] INFO Discovery.Protocols.Ssh.SshScan - Successfully SSHed into 10.66.1.37 2014/04/07 08:02:34 [122] INFO Discovery.Protocols.Ssh.SshScan - Successfully SSHed into 10.66.1.2 2014/04/07 08:02:34 [107] INFO Discovery.Protocols.Ssh.SshScan - Successfully SSHed into 10.66.1.4 2014/04/07 08:02:37 [185] INFO Discovery.Protocols.Icmp.IcmpScanner - Backround scanner needs to scan 26 ips 2014/04/07 08:02:37 [185] INFO Discovery.Protocols.Icmp.IcmpScanner - Legacy scanner needs to scan 5 IP(s) 2014/04/07 08:02:38 [65] INFO Discovery.Protocols.Ssh.SshScan - Successfully SSHed into 10.66.1.22 2014/04/07 08:02:39 [231] INFO Discovery.Protocols.Ssh.SshScan - Successfully SSHed into 10.66.1.11 2014/04/07 08:02:53 [216] INFO Discovery.Protocols.Ssh.SshScan - Successfully SSHed into 10.66.1.1 2014/04/07 08:02:53 [82] INFO Discovery.Protocols.Ssh.SshScan - Successfully SSHed into 10.66.1.49 2014/04/07 08:02:53 [32] INFO Discovery.Protocols.Ssh.SshScan - Successfully SSHed into 10.66.1.48 2014/04/07 08:02:54 [185] INFO Discovery.DataCollection.ScanManager - Total IPs scanned = 52 2014/04/07 08:02:54 [185] INFO Discovery.DataCollection.ScanManager - Deep scan conducted on 0 IP(s) 2014/04/07 08:02:54 [185] INFO Discovery.DataCollection.ScanManager - Time taken 22 sec. 2014/04/07 08:02:54 [185] INFO Discovery.Topology.DeviceIdentificationAndMerge - Scan added 0 Device(s) 2014/04/07 08:02:54 [185] INFO Discovery.DataCollection.ScanManager - Scanning device statuses for all devices 2014/04/07 08:02:55 [185] INFO Discovery.DataCollection.ScanManager - Scanning device statuses for all devices done 2014/04/07 08:02:55 [185] INFO ExpertSystem.ActionManagers.ActionNwkScan - Scanning completely done - time taken: 23 secs. 2014/04/07 08:02:55 [185] ERROR OM.ExpertSystem.Device - Error updating DeviceID = 29 DataAccess.Sql.SqlHelperException: [Sql= UPDATE Device SET Status = @status , MAC = @mac , DNSName = @dnsName , SnmpName = @snmpName , SnmpHash = @snmpHash , BiosOSHash = @biosOSHash , WmiEnabled = @wmiEnabled , SnmpEnabled = @snmpEnabled , SshEnabled = @sshEnabled , OSType = @osType , Description = @description , TimeLastUpdate = @timeLastUpdate , TimeLastUp = @timeLastUp , MachineName = @machineName , AMTEnabled = @amtEnabled , StaticIP = @staticIP , IsManaged = @isManaged , NetbiosName =@netbiosName , IPAddresses =@ipAddresses , IsRespondingToArp = @isRespondingToArp WHERE DeviceID = @deviceID Sql] [Arguments: @status=up; @mac=C8:60:00:C8:61:88; @dnsName=; @snmpName=; @snmpHash=0; @biosOSHash=-1; @wmiEnabled=True; @snmpEnabled=False; @sshEnabled=False; @osType=16; @description=; @timeLastUpdate=4/7/2014 12:02:55 PM; @timeLastUp=4/7/2014 12:02:55 PM; @machineName=PC-05; @amtEnabled=False; @staticIP=False; @isManaged=True; @deviceID=29; @netbiosName=PC-05; @ipAddresses=10.66.1.12; @isRespondingToArp=True; Arguments] [INNER_EXCEPTION: The UPDATE statement conflicted with the FOREIGN KEY constraint "OSType_Device_FK1". The conflict occurred in database "Data", table "dbo.OSType", column 'ID'. The statement has been terminated. INNER_EXCEPTION] ---> System.Data.SqlClient.SqlException: The UPDATE statement conflicted with the FOREIGN KEY constraint "OSType_Device_FK1". The conflict occurred in database "Data", table "dbo.OSType", column 'ID'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command) at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command) at DataAccess.Sql.SqlHelperGeneric.ExecuteNonQuery(String commandText, DbParameter[] parameterValues, Int32 timeoutInSeconds) in c:\Builds\41\Sources\Common\DataAccess.Sql\SqlHelperGeneric.cs:line 486 at DataAccess.Sql.SqlHelperGeneric.ExecuteQueryList(ParameterizedQueryList queryList) in c:\Builds\41\Sources\Common\DataAccess.Sql\SqlHelperGeneric.cs:line 422 --- End of inner exception stack trace --- at DataAccess.Sql.SqlHelperGeneric.ExecuteQueryList(ParameterizedQueryList queryList) in c:\Builds\41\Sources\Common\DataAccess.Sql\SqlHelperGeneric.cs:line 417 at DataAccess.Sql.SqlHelperGeneric.ExecuteQueryListInTransaction(ParameterizedQueryList queryList, TransactionScopeOption scope, IsolationLevel isolation) in c:\Builds\41\Sources\Common\DataAccess.Sql\SqlHelperGeneric.cs:line 450 at OM.ExpertSystem.DataProviders.ExpertSystemDataProvider.UpdateDevice(Int32 deviceID, String pingStatus, String mac, List`1 dnsName, String snmpName, Int32 snmpHash, Int32 biosOSHash, Boolean wmiEnabled, Boolean snmpEnabled, Boolean sshEnabled, OSType osType, String description, DateTime timeLastUpdate, Nullable`1 timeLastUp, String machineName, Boolean amtEnabled, Boolean staticIP, Boolean isManaged, String netbiosName, String ipAddresses, List`1 networkAdapterList, List`1 amtInterfaceDescriptorList, Boolean isRespondingToArp) in c:\Builds\41\Sources\OMSolution.root\OMSolution\OM.ExpertSystem\DataProviders\ExpertSystemDataProvider.cs:line 2810 at OM.ExpertSystem.Device.Save() in c:\Builds\41\Sources\OMSolution.root\OMSolution\OM.ExpertSystem\Device.cs:line 744 at OM.ExpertSystem.Device.Update(DiscoveryEngine discoveryEngine, Device Device) in c:\Builds\41\Sources\OMSolution.root\OMSolution\OM.ExpertSystem\Device.cs:line 734 2014/04/07 08:05:58 [185] INFO PowerManagement.OM.PowerEvents.PowerEventStateMachine - CreatePowerStatistics : generated 2 power statistic records for device SRV-WSUS