John, please help. It's urgent!

Hi John,

My portal currently experiences a very weird error and it greatly affects usablility.

That is, when I click "Update" in Host Settings or click "Install New Module" in Module Definition or click "Create Portal", the request never completes and always times out, although the actions are still carried out (Settings are updated, Module is installed, Portal is created).

While the request is being executed, the site can not be accessed from anywhere (confirmed through Alertra).

The portal's database is on an independent server. This problem seems to happen right after I upgrade to DNN 4.8.2

Could you please help me with this? I have full control over my IIS (6.0)

Regards,

Duc

Hi John, thanks for replying.

I finally decided to start a completely new installation (en.pijaja.com). However, as more portals are created, the errors above start to appear. Now I can still update Host Settings, but Installing Module will never complete, even with a light-weight module (50KB)

I assume that this is caused by threading limitation from my database, as it is placed on a remote server. But what I don't understand is that why this only happens after more sub-portals are created. How can it affect the module installation progress?

Regards,

Duc

P.S: in the error log, I get different messages, one of them is:

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: ccae1041-34c3-402f-8f71-f13ce6ea4332
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() at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.GetPortalsByName(String nameToMatch, Int32 pageIndex, Int32 pageSize) at DotNetNuke.Entities.Portals.PortalController.GetPortalsByName(String nameToMatch, Int32 pageIndex, Int32 pageSize, Int32& totalRecords) at DotNetNuke.Modules.Admin.Portals.Portals.BindData() at DotNetNuke.Modules.Admin.Portals.Portals.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

I think you are just having trouble with connectivity and/or performance of your database server.  It is most likely the DB server that is too busy to answer in time.

If it is related to adding more sub-portals then you may want to try turning off search indexing or other jobs that may be overloading the DB server.

Thanks John,

That's what I assume too.

But I have turned off the Site Log and all Scheduler tasks. Can anything else overlead the db server?

Regards,

Duc

Since my db is in a shared server, I can't perform a trace easily, so I'll try to replicate the environment in my localhost w/ MSSQL 2000.

Can you please explain the trace process more closely? I am totally inexperienced in this field.

Much appreciated,

Duc

Here is a good tutorial on Tracing with the SQL Profiler

I'm having the same problems after I upgraded to 4.8.2
I also thought the problem was causes by performance issues. So I tried a new machine, unfortunatily without success.

Right now I can't add new portals, so I'm having a serious issue. 
Does anyone find a solution for the problem or know where to look for a solution.
I checked support.dotnetnuke.com and send mail to some core members but without succes.

I assume more people have this problem, please help?????