[.NET TP Worker] ERROR
SELECT tblA.AssetName, tblA.AssetID, tblACus.DNSName, tsysAssetTypes.AssetTypeIcon10 AS icon, tblA.Ipaddress AS [IP Address], tblA.Ipaddress, tblA.Assettype, tsysAssetTypes.AssetTypename AS Type, tblA.Domain, tblA.Description,tblACus.Manufacturer, tblACus.Model, tblACus.Location, tsysIPLocations.IPLocation,tblACus.State AS Thestate, tblA.Lastseen AS [Last successful scan] FROM tblAssets AS tblA
LEFT OUTER JOIN tsysIPLocations ON tblA.LocationID = tsysIPLocations.LocationID
INNER JOIN tblAssetCustom AS tblACus ON tblA.AssetID = tblACus.AssetID
INNER JOIN tsysAssetTypes ON tblA.Assettype = tsysAssetTypes.AssetType
WHERE tblA.Scanserver = @Scanserver AND (((tblA.Assettype != @Parameter0 OR tblA.Assettype IS NULL)) AND ((tblA.Assettype != @Parameter1 OR tblA.Assettype IS NULL)) AND ((tblACus.State = @Parameter2))) ORDER BY tblA.AssetName
System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 230) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
That mught be the reasen tha open Lansweeper take about 55 seconds? Then we can work ok, but after a few seconds freezes for another 50 seconds or so...
Alson
Thanks
