Rank: Freeware Member
Groups: Member
Joined: 7/25/2008
Posts: 10
Location: Germany
|
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
|
Rank: Administration
Groups: Administration
Joined: 2/10/2005
Posts: 1,560
Location: Hamme Belgium
|
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"
|
Rank: Freeware Member
Groups: Member
Joined: 7/25/2008
Posts: 10
Location: Germany
|
will check it on monday with the sql admins
thanks a lot and nice weekend to belgium
|
Rank: Freeware Member
Groups: Member
Joined: 7/25/2008
Posts: 10
Location: Germany
|
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.
|
Rank: Premium user
Groups: Member
, Premium Users
Joined: 8/7/2008
Posts: 42
Location: UK
|
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 ?
|
Rank: Premium user
Groups: Member
, Premium Users
Joined: 8/7/2008
Posts: 42
Location: UK
|
http://ukgwebapps1dev1a/lansweeper32/STATE.aspx
gives me the error... is there a way yo remove this from the default page
|
Rank: Administration
Groups: Administration
Joined: 2/10/2005
Posts: 1,560
Location: Hamme Belgium
|
So you get this error after only 300 clients.
Which database are you using?
What is your server hardware configuration?
|
Rank: Premium user
Groups: Member
, Premium Users
Joined: 8/7/2008
Posts: 42
Location: UK
|
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.
|
