I frequently experience timeouts when changing permissions and check the unify on all children checkbox. See stacktrace from eventviewer below.
I looked through a thread here: http://bring2mind.net/Sup...id/3538/Default.aspx but none of the suggestions helped. Then I found something regarding a setting set when connecting to the database: SqlCmd.CommandTimeout. (link: http://web3.dotnetnuke.co...e/posts/Default.aspx ). Per my understanding it can only be set in the code, and the default is 30 sec. Is there anyway to change this in my application or making this a config setting?
ModuleId: 528
ModuleDefId: 149
FriendlyName: Bring2mind\DMX
ModuleControlSource: DesktopModules/Bring2mind/DMX/Dispatch.ascx
AssemblyVersion: 5.2.3
PortalID: 0
PortalName: Flag
UserID: 704
UserName: Lars.Heskje
ActiveTabID: 232
ActiveTabName: Document Management
RawURL: /Flag/Default.aspx?tabid=232&Command=Core_Edit&EntryId=4
AbsoluteURL: /Flag/Default.aspx
AbsoluteURLReferrer: http://localhost/Flag/Def...e_Edit&EntryId=4
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.10) Gecko/20100914 Firefox/3.6.10
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 8fc687b7-4fd5-4f09-86b2-0bd5846bed06
InnerException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlInternalConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> 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.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at Bring2mind.DNN.Modules.DMX.Data.SqlDataProvider.UnifyPermissions(Int32 PortalId, Int32 EntryId, Int32 UserId) at Bring2mind.DNN.Modules.DMX.Security.Permissions.EntryPermissionController.UnifyPermissions(EntryInfo Entry, Int32 UserId) at Bring2mind.DNN.Modules.DMX.Controls.EditEntry.ᜀ() at Bring2mind.DNN.Modules.DMX.Controls.EditEntry.DmxEditWizard_FinishButtonClick(Object sender, WizardNavigationEventArgs e) --- End of inner exception stack trace ---