Active Scanning errors in Service errorlog.txt

[gsvarney]

Hi,
I updated Lansweeper from 3.1 to 3.2 by copying all the new folders over the top of my installation. Then, as my service was lansweeper30.exe I renamed the lansweeper32.exe to lansweeper30.exe and also changed the config file to match. I added the needed active scanning line. Now, when the service starts, the log file quickly fills up with the following for many machines:

System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TsysLastscan_tblComputers". The conflict occurred in database "Lansweeper", table "dbo.tblComputers", column 'Computername'.
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 Lansweeper31.sweeperthread.UpdateLastScan(clsComputer mycomputer, String section, clsThreadinfo Threadinfo, SqlConnection& sqlcon, DateTime startdate)

Is something messed up in my database or did I miss something? Looks like the scanner is working, but no new computers inventoried.

Server is running Vista Business 32bit, network is Windows 2003 R2 SP2.

Thanks,
Geoff

[Hemoco]

>>> System.Net.HttpListenerException: Failed to listen on prefix 'http://*:9524/' because it conflicts with an existing registration on the machine.

this error is caused by another application already using port 9524 (you can use "netstat -a" to check this)

>>> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_tblsyslastscan'. Cannot insert duplicate key in object 'TsysLastscan'.
The statement has been terminated.

We have to investigate what's causing this.

>>> System.Runtime.InteropServices.COMException (0x8007203A): The server is not operational.
>>> System.Runtime.InteropServices.COMException (0x8007200F): The directory service is unavailable.

This is caused by one of your domaincontrollers that cannot be contacted at the time.

You have to wait until the clients report themselves to the domaincontrollers. (they do this at startup and sometimes later depending on the actions they are performing)

[tdewar1]

Since I started active scanning yesterday. I am getting a lot of errors in the log. Should any of these concern me? I have many less computers detected than I have in Active Directory, could any of this be why or have I just not waitred long enough?
Thanks
Tom



9/18/2008 3:50:34 PM : Stopping service

9/18/2008 3:53:35 PM : Database connection successful, starting up service

9/18/2008 3:53:35 PM : Active scanning enabled

9/18/2008 3:53:40 PM : WAMN-AMES-RED
System.Runtime.InteropServices.COMException (0x80005000): Unknown error (0x80005000)
at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.PropertyValueCollection.PopulateList()
at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
at Lansweeper31.sweeperthread.LSADcompsearch(clsComputer mycomputer, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/18/2008 5:14:23 PM : Stopping service

9/18/2008 5:14:24 PM : Database connection successful, starting up service

9/18/2008 5:14:24 PM : Active scanning enabled

9/18/2008 5:14:25 PM
System.Net.HttpListenerException: Failed to listen on prefix 'http://*:9524/' because it conflicts with an existing registration on the machine.
at System.Net.HttpListener.AddAll()
at System.Net.HttpListener.Start()
at Lansweeper31.Listen.DoListen()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
-------------------------------------------------------------------------
9/18/2008 5:14:26 PM : WAMN-AMES-RED
System.Runtime.InteropServices.COMException (0x80005000): Unknown error (0x80005000)
at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.PropertyValueCollection.PopulateList()
at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
at Lansweeper31.sweeperthread.LSADcompsearch(clsComputer mycomputer, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/18/2008 5:15:27 PM : Stopping service

9/18/2008 5:15:31 PM : Database connection successful, starting up service

9/18/2008 5:15:31 PM : Active scanning enabled

9/18/2008 5:15:32 PM : WAMN-AMES-RED
System.Runtime.InteropServices.COMException (0x80005000): Unknown error (0x80005000)
at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.PropertyValueCollection.PopulateList()
at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
at Lansweeper31.sweeperthread.LSADcompsearch(clsComputer mycomputer, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/18/2008 5:23:30 PM : Stopping service

9/18/2008 5:24:30 PM : Database connection successful, starting up service

9/18/2008 5:24:30 PM : Active scanning enabled

9/18/2008 5:24:30 PM : SAMN-FS1
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_tblsyslastscan'. Cannot insert duplicate key in object '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 Lansweeper31.sweeperthread.UpdateLastScan(clsComputer mycomputer, String section, clsThreadinfo Threadinfo, SqlConnection& sqlcon, DateTime startdate)
-------------------------------------------------------------------------
9/18/2008 5:24:31 PM : WAMN-AMES-RED
System.Runtime.InteropServices.COMException (0x80005000): Unknown error (0x80005000)
at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.PropertyValueCollection.PopulateList()
at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
at Lansweeper31.sweeperthread.LSADcompsearch(clsComputer mycomputer, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/18/2008 5:27:42 PM : Stopping service

9/18/2008 5:28:30 PM : Database connection successful, starting up service

9/18/2008 5:28:30 PM : Active scanning enabled

9/18/2008 5:28:31 PM : WAMN-AMES-RED
System.Runtime.InteropServices.COMException (0x80005000): Unknown error (0x80005000)
at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.PropertyValueCollection.PopulateList()
at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
at Lansweeper31.sweeperthread.LSADcompsearch(clsComputer mycomputer, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/18/2008 5:29:55 PM : Stopping service

9/18/2008 5:29:57 PM : Database connection successful, starting up service

9/18/2008 5:29:57 PM : Active scanning enabled

9/18/2008 5:29:57 PM
System.Net.HttpListenerException: Failed to listen on prefix 'http://*:9524/' because it conflicts with an existing registration on the machine.
at System.Net.HttpListener.AddAll()
at System.Net.HttpListener.Start()
at Lansweeper31.Listen.DoListen()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
-------------------------------------------------------------------------
9/18/2008 5:29:58 PM : WAMN-AMES-RED
System.Runtime.InteropServices.COMException (0x80005000): Unknown error (0x80005000)
at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.PropertyValueCollection.PopulateList()
at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
at Lansweeper31.sweeperthread.LSADcompsearch(clsComputer mycomputer, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/18/2008 5:30:27 PM : Stopping service

9/18/2008 5:30:29 PM : WABX-FBH-2N11B
System.Threading.ThreadAbortException: Thread was being aborted.
at Lansweeper31.sweeperthread.LSFiles(clsComputer Mycomputer, String section, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/18/2008 5:30:29 PM : WABX-FBH-2N11B
System.Threading.ThreadAbortException: Thread was being aborted.
at Lansweeper31.sweeperthread.LSFiles(clsComputer Mycomputer, String section, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/18/2008 5:30:29 PM : WABX-SCH-2N24WD
System.Threading.ThreadAbortException: Thread was being aborted.
at Lansweeper31.sweeperthread.LSFiles(clsComputer Mycomputer, String section, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/18/2008 5:30:29 PM : WAMN-ADM-2006D
System.Threading.ThreadAbortException: Thread was being aborted.
at Lansweeper31.sweeperthread.LSFiles(clsComputer Mycomputer, String section, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/18/2008 5:30:32 PM : Database connection successful, starting up service

9/18/2008 5:30:32 PM : Active scanning enabled

9/18/2008 5:30:33 PM : WAMN-AMES-RED
System.Runtime.InteropServices.COMException (0x80005000): Unknown error (0x80005000)
at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.PropertyValueCollection.PopulateList()
at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
at Lansweeper31.sweeperthread.LSADcompsearch(clsComputer mycomputer, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/18/2008 6:30:39 PM : WAMN-AMES-Y-L
System.Runtime.InteropServices.COMException (0x80005000): Unknown error (0x80005000)
at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.PropertyValueCollection.PopulateList()
at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
at Lansweeper31.sweeperthread.LSADcompsearch(clsComputer mycomputer, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/18/2008 7:50:54 PM
System.Runtime.InteropServices.COMException (0x8007203A): The server is not operational.

at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.DirectorySearcher.FindAll(Boolean findMoreThanOne)
at System.DirectoryServices.DirectorySearcher.FindAll()
at Lansweeper31.starter.ActiveScan()
-------------------------------------------------------------------------
9/18/2008 7:50:55 PM
System.Runtime.InteropServices.COMException (0x8007203A): The server is not operational.

at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.DirectorySearcher.FindAll(Boolean findMoreThanOne)
at System.DirectoryServices.DirectorySearcher.FindAll()
at Lansweeper31.starter.ActiveScan()
-------------------------------------------------------------------------
9/19/2008 1:31:25 AM : WAMN-AMES-RED
System.Runtime.InteropServices.COMException (0x80005000): Unknown error (0x80005000)
at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.PropertyValueCollection.PopulateList()
at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
at Lansweeper31.sweeperthread.LSADcompsearch(clsComputer mycomputer, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/19/2008 6:52:37 AM
System.Runtime.InteropServices.COMException (0x8007203A): The server is not operational.

at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.DirectorySearcher.FindAll(Boolean findMoreThanOne)
at System.DirectoryServices.DirectorySearcher.FindAll()
at Lansweeper31.starter.ActiveScan()
-------------------------------------------------------------------------
9/19/2008 7:03:00 AM
System.Runtime.InteropServices.COMException (0x8007200F): The directory service is unavailable.

at System.DirectoryServices.SearchResultCollection.ResultsEnumerator.MoveNext()
at Lansweeper31.starter.ActiveScan()
-------------------------------------------------------------------------
9/19/2008 7:23:02 AM
System.Runtime.InteropServices.COMException (0x8007203A): The server is not operational.

at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.DirectorySearcher.FindAll(Boolean findMoreThanOne)
at System.DirectoryServices.DirectorySearcher.FindAll()
at Lansweeper31.starter.ActiveScan()
-------------------------------------------------------------------------
9/19/2008 7:33:04 AM
System.Runtime.InteropServices.COMException (0x8007203A): The server is not operational.

at System.DirectoryServices.SearchResultCollection.ResultsEnumerator.MoveNext()
at Lansweeper31.starter.ActiveScan()
-------------------------------------------------------------------------
9/19/2008 8:19:52 AM : WEBX-CLA-1N51WE
System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
at Lansweeper31.sweeperthread.GetWMI(String Querystr, String Table, clsComputer mycomputer, String section, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/19/2008 9:07:07 AM : WEBX-FAC-1N2BE
System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
at Lansweeper31.sweeperthread.GetWMI(String Querystr, String Table, clsComputer mycomputer, String section, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------
9/19/2008 9:43:26 AM : WAMN-AMES-RED
System.Runtime.InteropServices.COMException (0x80005000): Unknown error (0x80005000)
at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.PropertyValueCollection.PopulateList()
at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
at Lansweeper31.sweeperthread.LSADcompsearch(clsComputer mycomputer, clsThreadinfo Threadinfo, SqlConnection& sqlcon)
-------------------------------------------------------------------------

[rmorgan]

:d/ :d/ Problem solved. Thanks for the help... :d/ :d/

[Hemoco]

Could you check the NTFS file permissions on this folder and all files please.
C:\lansweeperpro\website\

Especially the web.config file

[rmorgan]

Ok, I feel stupid too. I did the upgrade step by step. Now I am unable to connect to the site. I am getting the following error... Help:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: An error occurred loading a configuration file: Access to the path 'C:\lansweeperpro\website\web.config' is denied.

Source Error:


[No relevant source lines]


Source File: C:\lansweeperpro\website\web.config Line: 0


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

[gsvarney]

Now I feel stupid! I *didn't* do the upgrade, just the new premium stuff. However, I don't know what I've done to it now as when running the upgrade from 3.1 to 3.2 (I also tried the 3.0 to 3.1) and it fails with this:
Cannot insert the value NULL into column 'Domain', table 'Lansweeper.dbo.tsysadmins'; column does not allow nulls. UPDATE fails

Maybe I should just start over and create a new database?

[Hemoco]

gsvarney wrote:
Now I feel stupid! I *didn't* do the upgrade, just the new premium stuff. However, I don't know what I've done to it now as when running the upgrade from 3.1 to 3.2 (I also tried the 3.0 to 3.1) and it fails with this:
Cannot insert the value NULL into column 'Domain', table 'Lansweeper.dbo.tsysadmins'; column does not allow nulls. UPDATE fails

Maybe I should just start over and create a new database?

Open table tsysadmins and delete all records where the Domain field isn't filled in correctly.

[gsvarney]

Lansweeper wrote:

gsvarney wrote:
Now I feel stupid! I *didn't* do the upgrade, just the new premium stuff. However, I don't know what I've done to it now as when running the upgrade from 3.1 to 3.2 (I also tried the 3.0 to 3.1) and it fails with this:
Cannot insert the value NULL into column 'Domain', table 'Lansweeper.dbo.tsysadmins'; column does not allow nulls. UPDATE fails

Maybe I should just start over and create a new database?

Open table tsysadmins and delete all records where the Domain field isn't filled in correctly.

Thanks! That did it, is now populating the database as I write.

[Hemoco]

For people with this issue.
When you upgraded from 3.1 to 3.2 did you ran the new sql script?

From the download page download the Lansweeper 3.2 upgrade.

There is a folder website (with files to copy)
And also a folder SQLscript 3.1 to 3.2 (with a sqlscript to run)

This sqlscript will solve these problems.