CS 2007: All Forums broken - "Whitespace is not allowed..." (System.Data.SqlClient.SqlException) error

Reply

MarkBa Posted: Wed, May 30 2007 7:12 AM

rated by 0 users

Ok, I posted about this in Setup and this forum (http://communityserver.org/forums/t/488141.aspx) a few weeks back...  I got no responses... 

So in an effort to save my old forum posts, I moved them from the damaged forum to a newly created forum.  This seemed to spread whatever was wrong (a damaged message perhaps) into the new forum.  Now, not only can I not access the forums thread list, but any page that links to it (ex. home page shows most recent posts) also will not display.  I had to find the direct URL to Control Panel (Control Panel dashboard also will not load), Disable Applications and turn off forums before I could get the pages to load again.  But with the forums application disabled, I no longer can use direct URL's to get to the old messages or troubleshoot the forum problem.

I get various errors between the event logs, CS logs and the actual browser error, but they all seem to be linked to this 'whitespace' error. I am hoping someone here can help.  I would really like to recover these forums.  Worst case, I need some low level directions on manually removing forums and data so I can start over clean...

Here are the errors I have collected when trying to use forums or a page linked to it.

CS logged event

EntryID  2787 Category  Application Date  05-27-2007
EventID  201 Type  Information Machine  BLUEBOY1
SettingsID  -1  

Message
CS.Web Stopped CS.Web Stopped

_shutDownMessage=HostingEnvironment caused shutdown

_shutDownStack= at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at System.Web.HttpRuntime.ShutdownAppDomain()
at System.Web.Hosting.HostingEnvironment.ShutdownThisAppDomainOnce()
at System.Web.Hosting.HostingEnvironment.InitiateShutdownWorkItemCallback(Object state)
at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)

------------------------------------------------------------------------------------------------------------- 

Windows Application Log

(This one is for threadlist.aspx, but I get the same for controlpanel/default.aspx, home.aspx, tagelist.aspx & groupmanager.aspx when forums are enabled)

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  5/29/2007
Time:  8:56:10 AM
User:  N/A
Computer: BLUEBOY1
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 5/29/2007 8:56:10 AM
Event time (UTC): 5/29/2007 12:56:10 PM
Event ID: 99c833da9a694cc7bf678cebe51ebf56
Event sequence: 66
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1645538494/Root-3-128249014934369496
    Trust level: Full
    Application Virtual Path: /
    Application Path: C:\Inetpub\wwwroot3-HomeWatch\
    Machine name: BLUEBOY1
 
Process information:
    Process ID: 4752
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: SqlException
    Exception message: The error description is 'Whitespace is not allowed at this location.'.
 
Request information:
    Request URL: http://www.mcclintockwoods.com/themes/default/forums/threadlist.aspx?ForumID=4
    Request path: /themes/default/forums/threadlist.aspx
    User host address: 208.29.145.8
    User: mark
    Is authenticated: True
    Authentication Type: Forms
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 5
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    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.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo)
   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 CommunityServer.ASPNet20MemberRole.SqlData.GetRoles(IList`1 userNames)
   at CommunityServer.ASPNet20MemberRole.CSRoles.GetRoles(IList`1 userNames)
   at CommunityServer.Components.Roles.AddUserRolesToCache(IList`1 userNames)
   at CommunityServer.Users.AddUsersToCache(IList`1 userIds)
   at CommunityServer.Data.ForumsSqlDataProvider.GetThreads(ForumThreadQuery query)
   at CommunityServer.Discussions.Components.Threads.GetThreads(ForumThreadQuery query)
   at CommunityServer.Discussions.Controls.ThreadList.get_DataSource()
   at System.Web.UI.WebControls.Repeater.ConnectToDataSourceView()
   at System.Web.UI.WebControls.Repeater.OnLoad(EventArgs e)
   at CommunityServer.Controls.PreTemplatedWrappedRepeaterBase.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

-------------------------------------------------------------------------------------------------------------

ASP error in Brwoser

Server Error in '/' Application.
--------------------------------------------------------------------------------

The error description is 'Whitespace is not allowed at this location.'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The error description is 'Whitespace is not allowed at this location.'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

Stack Trace:

[SqlException (0x80131904): The error description is 'Whitespace is not allowed at this location.'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857242
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734854
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
   System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) +807499
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1537
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
   System.Data.SqlClient.SqlDataReader.get_MetaData() +62
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +62
   CommunityServer.ASPNet20MemberRole.SqlData.GetRoles(IList`1 userNames) +308
   CommunityServer.ASPNet20MemberRole.CSRoles.GetRoles(IList`1 userNames) +7
   CommunityServer.Components.Roles.AddUserRolesToCache(IList`1 userNames) +91
   CommunityServer.Users.AddUsersToCache(IList`1 userIds) +171
   CommunityServer.Data.ForumsSqlDataProvider.GetForums() +407
   CommunityServer.Discussions.Components.Forums.GetForumsTable(Boolean ignorePermissions, Boolean cacheable, Boolean flush, Boolean ignoreLanguageFilter) +404
   CommunityServer.Discussions.Components.Forums.GetForums(Boolean ignorePermissions, Boolean cacheable, Boolean toplevelForumsOnly, Boolean flush) +84
   CommunityServer.Discussions.Components.ForumApplication.Sections() +16
   CommunityServer.Data.SqlCommonDataProvider.GetSectionXML(ApplicationType applicationType) +292
   CommunityServer.Data.SqlCommonDataProvider.GetTags(ApplicationType applicationType) +10
   CommunityServer.Components.Tags.GetTags(ApplicationType applicationType, Boolean cacheable) +228
   CommunityServer.Components.Tags.GetTags(ApplicationType applicationType) +10
   CommunityServer.Controls.TagCloud.get_DataSource() +316
   CommunityServer.Controls.WrappedContentBase.AddLeaderControls() +40
   CommunityServer.Controls.WrappedContentBase.CreateControlHierarchy() +94
   CommunityServer.Controls.WrappedContentBase.CreateChildControls() +29
   System.Web.UI.Control.EnsureChildControls() +87
   System.Web.UI.Control.FindControl(String id, Int32 pathOffset) +21
   System.Web.UI.Control.FindControl(String id) +9
   Telligent.Glow.WebControlUtils.?(Control , String , Dictionary`2 ) +79
   Telligent.Glow.WebControlUtils.?(Control , String , Dictionary`2 ) +242
   Telligent.Glow.WebControlUtils.?(Control , String , Dictionary`2 ) +242
   Telligent.Glow.WebControlUtils.?(Control , String , Dictionary`2 ) +242
   Telligent.Glow.WebControlUtils.?(Control , String , Dictionary`2 ) +242
   Telligent.Glow.WebControlUtils.?(Control , String , Dictionary`2 ) +242
   Telligent.Glow.WebControlUtils.FindControl(Control container, String id) +137
   CommunityServer.Controls.SearchForm.AttachChildControls() +168
   CommunityServer.Controls.WrappedFormBase.CreateChildControls() +49
   System.Web.UI.Control.EnsureChildControls() +87
   CommunityServer.Controls.WrappedFormBase.DataBind() +12
   CommunityServer.Controls.SearchForm.DataBind() +31
   CommunityServer.Controls.SearchForm.OnLoad(EventArgs e) +32
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

 

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

 -------------------------------------------------------------------------------------------------------------

Any assistance with this would be GREATLY appreciated.  Perhaps there is a way to edit this whitespace directly in the SQL databse using some editor?  Or is there a way to export the messages and then delete the forums without using the CS pages to administer them?  Again, any help welcomed!

Mark

Reply

MarkBa replied on Thu, May 31 2007 3:29 PM

rated by 0 users

Can someone at least tell me if any of this data points to where the "whitespace" is?  I have examined the cs.Posts table and all the messages look fine.  I was expecting to find some corruption or something that just didn't look right, but everything looks fine.  Interesting that downloads, pictures and blogs are all found here too. 

I am of the opinion that the problem is in cs.Sections, which lists all the forums and there latest messages, etc.  Since any pages linked to forums has problems once I enabled the forums application.  However, cs.Sections table looks fine too.  Is there somewhere else I should be looking?

My website is for a non-profit neighborhood watch program and we really need our forums to work.  I am very close to scraping Community Server and going with Sharepoint if I cannot resolve this problem.  I don't want to, Sharepoint (even v3) doesn't have the membership system I want (basically adminless).  But at least it works and I can get support for it.  I realize I am only running the free version of Community Server but I was expecting at least 1 reply to my posts....  so far nothing....  Not good...

Mark

Reply

Rick Reszler replied on Tue, Jun 5 2007 8:36 PM

rated by 0 users

Mark,

I replied to the other thread as well I just found this very same issue on my own site and we are looking into this.

Do you noticed when you are not logged in that the error goes away and the forums start working? 

Reply

Rick Reszler replied on Tue, Jun 5 2007 8:46 PM

rated by 0 users

Mark,

Can you check to see if any of your users have an "&" in there user name?

I found that I had one user with a "&" because I was testing another bug and now that I removed the "&" from the user name now my forums are working when I am logged in. 

Reply

MarkBa replied on Wed, Jun 6 2007 7:29 AM

rated by 0 users

I can confirm that with the forums application enabled, non signed in users can load the homepage.  However, I still cannot access forums (either via the top level link or direct URL to a message) even when not signed in.

Checked my user membership via the CS control panel as well as SQL mgr, and I found 3 users who had &'s in their name.  When I was moving messages from the earlier (non-working) foum, it advanced the last posts field.  When the last post was set to a user that had an & in their name, we have the problem.  I changed the users to "and" instead of "&" and now everything seems to be working.

THANK YOU!! 

However, I imagine this represents a significfant bug since user names have to be changed (and users informed) for the forums to function correctly.  Thanks again and I look forward to any updates on this. 

Mark Barringer - www.McClintockWoods.com

Reply

Rick Reszler replied on Wed, Jun 6 2007 9:36 AM

rated by 0 users

Mark,

A fix has been checked in for this and will be part of SP2 for CS 2007.

I am not sure when SP2 will be released but it won't be long.