Missing element

[guenterm]

Hello,
from today in the lansweeper webconsole I miss the Domain overview in the digital dashboard.
I think it's a typical "too many fingers at the keyboard error", but how can i get back this element
All other elements are marked in reports-digitaldashboard are visible
Greetings

[d_i_saunders]

300 was when we notices it..
Aplications server.A0122 SQL server2005.A0115. Webserver.a0116

Fixed mine by looking for "SELECT * FROM dbo.web30totaldomain" &"SELECT * FROM dbo.web30lastscan" just typed them back in..

Saved state.aspx
Hit F5 and it all came back.

Maybe the permission were wrong on state.aspx

really dont know.

[Hemoco]

So you get this error after only 300 clients.
Which database are you using?
What is your server hardware configuration?

[d_i_saunders]

http://ukgwebapps1dev1a/lansweeper32/STATE.aspx

gives me the error... is there a way yo remove this from the default page

[d_i_saunders]

Hi,

Im, now getting the same... Was ok untill we pass 300 clients.. not its like this all the time... Is there a way to extend the time out ?

[guenterm]

hello,
don't ask me why, but there are all elements in the dashboard.
Leaving friday with missing element, starting monday with all elements.
It is a myth. I will ask for some ghostbusters, not more admins in our company.
Thanks a lot for supporting.

[guenterm]

will check it on monday with the sql admins
thanks a lot and nice weekend to belgium

[Hemoco]

The query to get the required information times out.
This is odd because it normally takes only some milliseconds.

This means that the problem must be your sql server.
Do you see any errors in the eventlog of your server?

The queries that take a long time to finish are

"SELECT * FROM dbo.web30totaldomain"
"SELECT * FROM dbo.web30lastscan"

[guenterm]

first question > I did
second one > I did now (finding 2 entries I changed)

now state aspx give the result

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.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()

Could you give me one idea what you expect. Because all other things are running perfect. For example, I changed the description field of 20 Servers, run lsclient and all informations appear in the lansweeper webcionsole

[Hemoco]

Did you change the debug=true in the web.config?
If you did, please open state.aspx with notepad and change all debug=false to debug=true