MichaelRyom Posted June 2, 2018 Share Posted June 2, 2018 Hi I'm trying to delete a folder with nested objects - password lists. But it times out with the following error msg in error console. Is there anything the can be done to change the time-out timer? Passwordstate and mssql express is installed on the same server. 02/06/2018 19:53:18 General Error Error Code = Thread was being aborted., StackTrace = at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at Passwordstate.Common.AddDebugInfoData(String Category, String DebugInformation, String EventType) at Passwordstate.PasswordList.DeletePasswordList(Int32 intPasswordListID, String strPasswordList) at Passwordstate.PasswordList.DeleteFolderAndAllNestedItems(Int32 PasswordListID) Error 02/06/2018 19:53:18 General Error Error Code = Query timeout expired, StackTrace = at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Passwordstate.PasswordList.DeletePasswordList(Int32 intPasswordListID, String strPasswordList) Error Link to comment Share on other sites More sharing options...
support Posted June 2, 2018 Share Posted June 2, 2018 Hi Michael, This issue is a timeout with your SQL Server, and in the .NET Framework the default is set to 30 seconds for database connections. We're going to make a change in the next release as we've had a few customers run into this issue recently, as we've developed a more efficient script which should hopefully help with this. For now, if you can contact us via our support page on our web site (https://www.clickstudios.com.au/support.aspx) I can provide the SQL script to you now so you can run this manually in SQL Server Management Studio. Regards Click Studios MichaelRyom 1 Link to comment Share on other sites More sharing options...
support Posted June 3, 2018 Share Posted June 3, 2018 Hello Everyone. As mentioned, we are making changes in the next build for this, and we've been doing some testing on performance here. With this new script for mass deletion, we've been able to delete a parent folder which has 500 nested Folders, 2500 Password Lists and 12500 password records, in just under 3 minutes. These times will obviously vary depending on the age of these records, and volume of related records in various tables, but at least this is an indication of performance. Regards Click Studios Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now