Learn More





Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Error generating any ListsError generating any Lists
New Post
6/10/2015 9:23 AM

I am having a continual issue with the generation of any lists in DNN.  I am running 7.3.4 in Azure with the Turbo SQL Scripts installed.  I am unable to view events or to perform any maintenance on my users.  the following is the error response for attempting to generate the Event Listing:

rror: Log Viewer is currently unavailable. 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. ---> System.ComponentModel.Win32Exception: The wait operation timed out --- End of inner exception stack trace --- at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at PetaPoco.Database.Execute(String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, Int32 timeout, String sql, Object[] args) at DotNetNuke.Data.DataProvider.PurgeLog() at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.PurgeLogBuffer() at DotNetNuke.Services.Log.EventLog.LogController.PurgeLogBuffer() at DotNetNuke.Modules.Admin.LogViewer.LogViewer. (EventArgs e) --- End of inner exception stack trace ---

New Post
6/10/2015 8:33 PM
timeout is usually a Performance issue of the database. I Need to check against a test install of 7.3.4, unfortunately due to other Tasks won't be able to do it before the Weekend. What is the size of your database and Transaction log? Did you apply Turbo Scripts to the Db while it was running in Azure?

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group   European Network of DotNetNuke Professionals

Speed up your DNN Websites with TurboDNN
New Post
6/11/2015 9:03 AM


 Thanks for the reply.  I do not know the size of the database log as Azure does not report this to me.  Yes, I applies Turbo scripts after the database was installed on Azure.  Also, I have been forced to change my Pricing Tier on Azure frm Shared to Basic as Every time I attempt to generate a list on DNN I start to exceed memory constraints.  Last time I used over 434MB of memory credits with 5 minutes of attempting to generate lists.

New Post
6/30/2015 12:36 PM
I am unable to generate any entry into the Forum.  Is there an issue?

New Post
6/30/2015 12:39 PM
I was working with the membership information on my website as members are experiencing issues. I am running DNN 7.3.4 on Azure SQL Server 2014. I was running down an issue with roles and authorization. I executed the following SQL statement:

SELECT        TOP (200) dbo.Users.UserID, dbo.UserPortals.Authorised, dbo.Users.Username, dbo.Users.FirstName, dbo.Users.LastName, dbo.Users.IsSuperUser, dbo.Users.AffiliateId, dbo.Users.Email,
                         dbo.Users.DisplayName, dbo.Users.UpdatePassword, dbo.Users.LastIPAddress, dbo.Users.IsDeleted, dbo.Users.CreatedByUserID, dbo.Users.CreatedOnDate,
                         dbo.Users.LastModifiedByUserID, dbo.Users.LastModifiedOnDate, dbo.Users.PasswordResetToken, dbo.Users.PasswordResetExpiration, dbo.Users.LowerEmail,
                         dbo.UserRoles.UserRoleID,  dbo.UserRoles.RoleID
FROM            dbo.Users INNER JOIN
                         dbo.UserRoles ON dbo.Users.UserID = dbo.UserRoles.UserID INNER JOIN
                         dbo.UserPortals ON dbo.Users.UserID = dbo.UserPortals.UserId
WHERE        (dbo.UserPortals.Authorised = 'False')
ORDER BY LowerEmail

I received a VERY surprising result that indicates a data type issue, that may be the underlying issue on the database.

The email column is reported as an "Unsupported Data Type", as are the UserName, FirstName and LastName. As shown below:

The email column is defined as an nvarchar(256) column; yet the results from Azure indicate that the data type is unsupported.

How can this be corrected within the database? Is there a remedy? I have a fully populated database with over 1150 members.

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Error generating any ListsError generating any Lists

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
Try Evoq
For Free
Start Free Trial
a Demo
See Evoq Live
Need More Information?