SQL Timeout expired and software listed not currently on any computers

[ifm]

Hi!

I just wanted to say that this problem now has returned, I previously got a fix from you, but is didn't fix the problem permanently.

Also, When I search for ex Java I get a list of installed versions, but some of them are not installed on any computer at the moment.
it would be great if this could be fixed or a setting where I could purge software not currently installed.


Running Lansweeper 4.1.0.127

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.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()

[ifm]

OK, now I got the SQL error again.

I will not run your fix before I hear frm you in case you want to try something else this time.

[Hemoco]

ifm wrote:
OK, now I got the SQL error again.

I will not run your fix before I hear frm you in case you want to try something else this time.

Please contact us by e-mail for this problem.

[ifm]

Are inactive computers the same as the result from the report:
"Computer: Not seen in the last 30 days"

Can I change the software search to not include inactive computers?
I want to be able to scan for old versions to that I can install updates.

[Hemoco]

Are inactive computers the same as the result from the report:
"Computer: Not seen in the last 30 days"

No, you can find them by clicking "non active computers" in the left menu.

Can I change the software search to not include inactive computers?
I want to be able to scan for old versions to that I can install updates.

Added to the wish list

[Hemoco]

Opera 9.6.0 is most likely installed on one of the non-active computers (which are filtered our in the result)

[Hemoco]

Hi,

Where exactly do you get this error?

it would be great if this could be fixed or a setting where I could purge software not currently installed

Software is removed from the list if it's not installed (and the computer is rescanned)

[ifm]

Lansweeper wrote:

Where exactly do you get this error?

I was about to check what software was installed on a client when the error occurred. ( I run your fix right before I got the reply and now there are no errors again.
Maybe it is related to my other problem with software listed that is not installed?

Example:

Results for search "opera" - 9 items found
	opera 10.10 
Opera Software ASA 
	opera 10.53 
Opera Software ASA 
	opera 10.54 
Opera Software ASA 
	opera 10.60 
Opera Software ASA 
	opera 10.63 
Opera Software ASA 
	opera 11.00 
Opera Software ASA 
	opera 11.01 
Opera Software ASA 
	opera 9.60 
Opera Software ASA 
	opera 9.64 
Opera Software ASA

After clickng Opera 9.6.0 i get this result:

Software report for Opera 9.60 - 0 items found