Minor problems after ugrade to 3.5.1

[petr22]

Hello, we upgraded our Lansweeper service to beta 3.5.1. Everything run OK (all files overwriten, database update script) except service error log is filled with thse messages every few minutes (first one appeared when service was started)

Column 'Netbiosname' does not belong to table mytable.
at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.get_Item(String columnName)
at LansweeperService.mdlActivescanning.GetDomainsToScan(Hashtable& DomainsToScan)

Netbios name is correctly filled in the configuration together with DNS domain name


And in window when we display user propertied it show this (for all users) instead of list of computer where this user is logged:

Digital dashboard Software reports Hardware reports Server reports General reports License compliance OS license compliance

System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.Web30searchuserlogon'.
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.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable)
at DreamweaverCtrls.DataSet.DoInit()


Is there any fix for this, please ? There were no error messages when Lansweeper was updated.

[Hemoco]

Your license was always valid till 18 march, but it will run 14 days longer as a safety if you have problems extending your subscription.
Previous version showed enddate+14 (which made the safety useless)

[petr22]

You are right, it was our fault - there were two SQL databases on the server (lansweeper32 and lansweeperdb) and update script was executed on the wrong one. Problem is solved, thanks for the support.

There is only one strange thing left - everytime lansweeper service 3.5.1 is stopped and started, licence expiration date is changed - it was 1.3.2010, then 1.4.2010 and now 18.3.2010.

[Hemoco]

Could you post your lansweeperservice.exe.config file please.
(and the information you used to connect to the database with lsupgrade.exe)

[petr22]

There is only one database on the server - lansweeper32 (under Microsoft SQL 2005 Express)

This database was created again by Lansweeper installer after update from 3.x to 3.5 failed (maybe this this the problem)

[Hemoco]

Are you sure that you are connected to the correct database?

[petr22]

Yes, sql script finished without any error, when I run it second time I get this message:

Column names in each table must be unique. Column name 'Netbiosname' in table 'tsysActiveScanDomains' is specified more than once
Command completed successfully
Command completed successfully
Command completed successfully
Command completed successfully
Command completed successfully
There is already an object named 'Web30LastLogon2' in the database
There is already an object named 'Web30searchuserlogon' in the database

[Hemoco]

Did you ran the sql script?