Exception: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader - StackTrace: at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in umbraco\datalayer\SqlHelper.cs:line 249 at DigibizAdvancedMediaPicker.DAMP_ApplicationBase.UpdateDAMP(Media media, Boolean deleteMediaItem) - InnerException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. - InnerStackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) in datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:line 93 at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in umbraco\datalayer\SqlHelper.cs:line 243
Looks like DAMP is trying to fetch the nodes which should be updated (after a media item is saved), but that gives a timeout exception. How many nodes does your Umbraco install have and could there be another reason for the timeout?
Hmm that's probably the problem. I never tried to use DAMP on such a large site. If you use DAMP with full xml it might be better to only store the id. If you use the full xml and you update the media item the xml on the node also needs to be updated. That's what the UpdateDAMP method does and it looks like it can't handle searching so many nodes (it only updates the ones which have that media item).
Hmm quickest solution might be to download the source and simply comment the UpdateDAMP method. If you only store the id you don't need that method anyway.
awesome - thank you! working great now (no errors yet)... it seems like this was also affecting our sorting, which appears to be very fast now... is that possible? thank you so much for the help!
Jeroen - I'm getting the following error when I try to use the create functionality now:
Exception: Object reference not set to an instance of an object. - StackTrace: at DigibizAdvancedMediaPicker.CreateMediaItem.get_mediaid() at DigibizAdvancedMediaPicker.CreateMediaItem.BtnCreate_Click(Object sender, EventArgs e)
What version of the source did you download? In the latest change set some new functionality has been added which I haven't tested yet. Might be better to stay with changeset 62425cfc1854 (Feb 6 5:28 PM) or lower for now.
I download the version listed in the link you provided... I actually missed a couple other errors. below are the there that are being thrown currently.
Administrator
-1
18/07/2012 09:08:48
Error
Exception: Object reference not set to an instance of an object. - StackTrace: at DigibizAdvancedMediaPicker.CreateMediaItem.get_mediaid() at DigibizAdvancedMediaPicker.CreateMediaItem.BtnCreate_Click(Object sender, EventArgs e)
Administrator
-1
18/07/2012 09:08:48
Error
Exception: Object reference not set to an instance of an object. - StackTrace: at DigibizAdvancedMediaPicker.CreateMediaItem.SetAdditionalProperties()
Administrator
-1
18/07/2012 09:08:48
Error
Exception: Object reference not set to an instance of an object. - StackTrace: at DigibizAdvancedMediaPicker.CreateMediaItem.OnInit(EventArgs e)
The link I provided has a list of different change sets. You probably downloaded the latest version, but it seems that is not stable enough yet. That's why it's better to download an earlier version.
getting a ton of error messages in umbraco log
please advise... we're running 4.7.2
Exception: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader - StackTrace: at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in umbraco\datalayer\SqlHelper.cs:line 249 at DigibizAdvancedMediaPicker.DAMP_ApplicationBase.UpdateDAMP(Media media, Boolean deleteMediaItem) - InnerException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. - InnerStackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) in datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:line 93 at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in umbraco\datalayer\SqlHelper.cs:line 243
Looks like DAMP is trying to fetch the nodes which should be updated (after a media item is saved), but that gives a timeout exception. How many nodes does your Umbraco install have and could there be another reason for the timeout?
Jeroen
close to 30,000
Hmm that's probably the problem. I never tried to use DAMP on such a large site. If you use DAMP with full xml it might be better to only store the id. If you use the full xml and you update the media item the xml on the node also needs to be updated. That's what the UpdateDAMP method does and it looks like it can't handle searching so many nodes (it only updates the ones which have that media item).
Jeroen
were not storing full xml, only the id. do we have any options at this point? thx!
Hmm quickest solution might be to download the source and simply comment the UpdateDAMP method. If you only store the id you don't need that method anyway.
Jeroen
awesome - thank you! working great now (no errors yet)... it seems like this was also affecting our sorting, which appears to be very fast now... is that possible? thank you so much for the help!
Jeroen - I'm getting the following error when I try to use the create functionality now:
Exception: Object reference not set to an instance of an object. - StackTrace: at DigibizAdvancedMediaPicker.CreateMediaItem.get_mediaid() at DigibizAdvancedMediaPicker.CreateMediaItem.BtnCreate_Click(Object sender, EventArgs e)
What version of the source did you download? In the latest change set some new functionality has been added which I haven't tested yet. Might be better to stay with changeset 62425cfc1854 (Feb 6 5:28 PM) or lower for now.
Jeroen
I download the version listed in the link you provided... I actually missed a couple other errors. below are the there that are being thrown currently.
09:08:48
09:08:48
09:08:48
The link I provided has a list of different change sets. You probably downloaded the latest version, but it seems that is not stable enough yet. That's why it's better to download an earlier version.
Jeroen
downoading the suggested changeset now. will keep you posted on this one. thx!
worked great! thank you Jeroen!
is working on a reply...