cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
nriddick
Engaged Sweeper
I need help figuring out why my lansweeper isn't scanning new assets.
I am good on licenses.
If I put something in the import folder it doesn't get picked up.
I found the error log file and this is what Im seeing.
Any help would be appreciated! Im not sure how to fix that

SqlException Errors:
-> Number 547: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TsysLastscan_tblAssets". The conflict occurred in database "lansweeperdb", table "dbo.tblAssets", column 'AssetID'.
Following properties may have cause the implications:
- ( ) AssetID: Type: Int32, Value: "30395"
- ( ) CFGcode: Type: Int32, Value: "83"
- ( ) Lasttime: Type: DateTime, Value: "08/12/2020 09:57:58"
- ( ) Scantime: Type: Decimal, Value: "4.0001135"
This operation failed because another data entry uses this entry.

SqlException Errors:
-> Number 547: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tblErrors_tsysasseterrortypes". The conflict occurred in database "lansweeperdb", table "dbo.tsysasseterrortypes", column 'Errortype'.
Following properties may have cause the implications:
- ( ) Teller: Type: Int32, Value: "0"
- ( ) AssetId: Type: Int32, Value: "47169"
- ( ) Errortype: Type: AssetErrorType, Value: "WindowsClusterLogErrors"
- ( ) ErrorText: Type: String, Value: "Unable to scan Windows Cluster for target dc1hyperv1.mapcom.local with credential Global Windows."
- ( ) CFGname: Type: String, Value: ""
This operation failed because another data entry uses this entry.

Error Number:-2146893055,State:0,Class:20
2020-08-12 09:24:43,933 [Lookup AD async] ERROR System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The handle specified is invalid) ---> System.ComponentModel.Win32Exception (0x80004005): The handle specified is invalid
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Lansweeper.Service.DL.Infrastructure.DB.OpenConn(IDbConnection privopensqlcon)
ClientConnectionId:a7a2e0fa-b25c-46fd-9a0b-ae629d393cea
Error Number:-2146893055,State:0,Class:20
2020-08-12 09:24:44,043 [Lookup AD async] ERROR System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The handle specified is invalid) ---> System.ComponentModel.Win32Exception (0x80004005): The handle specified is invalid
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Lansweeper.Service.DL.Infrastructure.DB.OpenConn(IDbConnection privopensqlcon)
ClientConnectionId:a7a2e0fa-b25c-46fd-9a0b-ae629d393cea
Error Number:-2146893055,State:0,Class:20
2020-08-12 09:24:44,136 [Lookup AD async] ERROR System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The handle specified is invalid) ---> System.ComponentModel.Win32Exception (0x80004005): The handle specified is invalid
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Lansweeper.Service.DL.Infrastructure.DB.OpenConn(IDbConnection privopensqlcon)
ClientConnectionId:a7a2e0fa-b25c-46fd-9a0b-ae629d393cea
Error Number:-2146893055,State:0,Class:20
2020-08-12 09:24:44,652 [145] ERROR SELECT * FROM tsysupdate
System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The handle specified is invalid) ---> System.ComponentModel.Win32Exception (0x80004005): The handle specified is invalid
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Lansweeper.Service.DL.Infrastructure.DB.ExecuteDataset(IDbConnection sqlConn, DbTransaction transaction, String commandText, IDbDataParameter[] parameterValues)
ClientConnectionId:a7a2e0fa-b25c-46fd-9a0b-ae629d393cea
Error Number:-2146893055,State:0,Class:20
2020-08-12 09:24:44,652 [145] INFO Refresh config: Cannot load data from tsysupdate
2020-08-12 09:24:44,824 [145] ERROR System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The handle specified is invalid) ---> System.ComponentModel.Win32Exception (0x80004005): The handle specified is invalid
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Lansweeper.Service.DL.Infrastructure.DB.OpenConn(IDbConnection privopensqlcon)
ClientConnectionId:a7a2e0fa-b25c-46fd-9a0b-ae629d393cea
Error Number:-2146893055,State:0,Class:20
2020-08-12 09:27:02,032 [1] INFO Logging initialized
2020-08-12 09:27:02,438 [6] INFO Starting service
2020-08-12 09:27:13,064 [10] INFO 55251 vendor oid's loaded
2020-08-12 09:27:13,189 [12] INFO 27607 vendor mac's loaded
2020-08-12 09:27:43,580 [6] INFO Started lansweeperhq01 v8.0.130.21 by NT AUTHORITY\SYSTEM, port 9524, 8 Threads, 8 IP Threads, 1 Scanning Servers, time: UTC-4
2020-08-12 09:27:43,846 [6] INFO Operating System: Microsoft Windows Server 2012 R2 Standard (OS language: English (United States), OS version: 6.3.9600), Service Pack version: 0
2020-08-12 09:27:43,893 [6] INFO .NET Framework version: 4.7.3416.0
2020-08-12 09:27:43,924 [6] INFO Database: SQL Server 2014 (version: 12.0.2269.0) Express Edition (64-bit): localhost\SQLEXPRESS, 1324.58 MB used, time: UTC-4
2020-08-12 09:27:43,939 [6] INFO License: Ultimate version, 227565711, 3285 licensed assets
2020-08-12 09:27:44,018 [6] INFO Service started in 41.590s
2020-08-12 09:27:44,221 [Listen] INFO Using existing SSL certificate. ThumbPrint: CA0F400B9CB86315C1C2330BA4A2E9663D39BDEC
2020-08-12 09:34:23,940 [mapcom\DC1HYPERV3\1] INFO AssetName:DC1HYPERV3 AssetUnique:mapcom\DC1HYPERV3\1 AssetID:47171 IP:10.1.30.112 ScanMethod:ActiveScanning Description:CN=Computers,DC=mapcom,DC=local mapcom\DC1HYPERV3 Scan one computer - Uncaught error An error occurred while updating the entries. See the inner exception for details. Entity of type "AssetError" in state "Added" has caused a DbUpdateException.


SqlException Errors:
-> Number 547: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tblErrors_tsysasseterrortypes". The conflict occurred in database "lansweeperdb", table "dbo.tsysasseterrortypes", column 'Errortype'.
Following properties may have cause the implications:
- ( ) Teller: Type: Int32, Value: "0"
- ( ) AssetId: Type: Int32, Value: "47171"
- ( ) Errortype: Type: AssetErrorType, Value: "WindowsClusterLogErrors"
- ( ) ErrorText: Type: String, Value: "Unable to scan Windows Cluster for target dc1hyperv3.mapcom.local with credential Global Windows."
- ( ) CFGname: Type: String, Value: ""
This operation failed because another data entry uses this entry.
0 REPLIES 0