Hi, we are using DNN version 4.8.02 and need to know if there exists any restriction or limit of the number of subscribers in one portal, becuase we have more than 200.000.- subscribers in our portal but experience a lot of issues of timeouts, for example: searching "last names" into the users tools we can't do that. Also trying to send massive emails from the admin menu.
Some one can help me to try to figureout this?
Here is the error message trying to find one lastname into the users tool:
ModuleId: 358
ModuleDefId: 15
FriendlyName: Administrar Usuarios
ModuleControlSource: Admin/Users/Users.ascx
AssemblyVersion: 04.08.02
PortalID: 0
PortalName: materna Argentina
UserID: 2
UserName: admin
ActiveTabID: 42
ActiveTabName: Cuentas de Usuario
RawURL: /Admin/UserAccounts/tabid/42/filter/vazquez/filterproperty/LastName/currentpage/1/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.materna.com.ar/Admin/UserAccounts/tabid/42/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; InfoPath.2; OfficeLiveConnector.1.3; OfficeLivePatch.0.0)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 0959fe1b-c349-4997-a025-829719278e0b
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.SqlConnection.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.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.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Security.Membership.Data.SqlDataProvider.GetUsersByProfileProperty(Int32 PortalID, String propertyName, String propertyValue, Int32 pageIndex, Int32 pageSize) at DotNetNuke.Security.Membership.AspNetMembershipProvider.GetUsersByProfileProperty(Int32 portalId, Boolean isHydrated, String propertyName, String propertyValue, Int32 pageIndex, Int32 pageSize, Int32& totalRecords) at DotNetNuke.Entities.Users.UserController.GetUsersByProfileProperty(Int32 portalId, Boolean isHydrated, String propertyName, String propertyValue, Int32 pageIndex, Int32 pageSize, Int32& totalRecords) at DotNetNuke.Modules.Admin.Users.UserAccounts.BindData(String SearchText, String SearchField) in E:\wwwroot\MaternaAR\Admin\Users\Users.ascx.vb:line 274 at DotNetNuke.Modules.Admin.Users.UserAccounts.Page_Load(Object sender, EventArgs e) in E:\wwwroot\MaternaAR\Admin\Users\Users.ascx.vb:line 586 --- End of inner exception stack trace ---
Source: