Error when update the DB from 5.6 to 7.x

Open Support Ticket

Call Support:
Direct: (214) 420-1337
Toll Free: (877) 522-6334

Monday through Friday
8 a.m. to 6 p.m. Central (GMT-6)

Join our Community

Details

9 Replies
1 Subscriber
Posted2 months ago

Options

Error when update the DB from 5.6 to 7.x

This question is answered

Posted by Rex Sun

on Fri, Mar 15 2013 4:20 PM

Home page renders fine, but it will return error when click on "sign in" link: Data at the root level is invalid. Line 1, position 1.

[XmlException: Data at the root level is invalid. Line 1, position 1.]

System.Xml.XmlTextReaderImpl.Throw(String res, String arg) +195

System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() +5187106

System.Xml.XmlTextReaderImpl.ParseDocumentContent() +61

System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace) +172

System.Xml.XmlDocument.Load(XmlReader reader) +144

System.Xml.XmlDocument.Load(TextReader txtReader) +209

Telligent.Evolution.Data.ContentFragmentPageSqlDataProvider.PopulateConfiguredContentFragment(ConfiguredContentFragment ccf, IDataReader reader, String themeName, Guid themeTypeId, Int32 themeContextId) +639

Telligent.Evolution.Data.ContentFragmentPageSqlDataProvider.PopulateAndAddConfiguredContentFragment(IDataReader reader, IContentFragmentContainer container, String themeName) +409

Telligent.Evolution.Data.ContentFragmentPageSqlDataProvider.GetContentFragmentPageByPageName(Guid themeTypeID, Int32 themeContextID, String themeName, String pageName, Boolean isCustom) +1047

Telligent.Evolution.Components.ContentFragmentPageDataService.GetByPageName(Guid themeTypeID, Int32 themeContextID, String themeName, String pageName, Boolean isCustom) +267

Telligent.Evolution.Components.ContentFragmentPageService.Get(IThemeConfigurationContext context, String themeName, String pageName, Boolean isCustom) +248

Telligent.Evolution.Controls.ContentFragmentPageBase.GetContentFragmentContainer() +231

Telligent.Evolution.Controls.ContentFragmentContainerBase.get_ContentFragmentContainer() +40

Telligent.Evolution.Controls.ContentFragmentPageBase.OnInit(EventArgs e) +127

System.Web.UI.Control.InitRecursive(Control namingContainer) +133

System.Web.UI.Control.InitRecursive(Control namingContainer) +421

System.Web.UI.Control.InitRecursive(Control namingContainer) +421

System.Web.UI.Control.InitRecursive(Control namingContainer) +421

System.Web.UI.Control.InitRecursive(Control namingContainer) +421

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1970

[XmlException: Data at the root level is invalid. Line 1, position 1.]

System.Xml.XmlTextReaderImpl.Throw(String res, String arg) +195

System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() +5187106

System.Xml.XmlTextReaderImpl.ParseDocumentContent() +61

System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace) +172

System.Xml.XmlDocument.Load(XmlReader reader) +144

System.Xml.XmlDocument.Load(TextReader txtReader) +209

Telligent.Evolution.Data.ContentFragmentPageSqlDataProvider.PopulateConfiguredContentFragment(ConfiguredContentFragment ccf, IDataReader reader, String themeName, Guid themeTypeId, Int32 themeContextId) +639

Telligent.Evolution.Data.ContentFragmentPageSqlDataProvider.PopulateAndAddConfiguredContentFragment(IDataReader reader, IContentFragmentContainer container, String themeName) +409

Telligent.Evolution.Data.ContentFragmentPageSqlDataProvider.GetContentFragmentPageByPageName(Guid themeTypeID, Int32 themeContextID, String themeName, String pageName, Boolean isCustom) +1047

Telligent.Evolution.Components.ContentFragmentPageDataService.GetByPageName(Guid themeTypeID, Int32 themeContextID, String themeName, String pageName, Boolean isCustom) +267

Telligent.Evolution.Components.ContentFragmentPageService.Get(IThemeConfigurationContext context, String themeName, String pageName, Boolean isCustom) +248

Telligent.Evolution.Controls.ContentFragmentPageBase.GetContentFragmentContainer() +231

Telligent.Evolution.Controls.ContentFragmentContainerBase.get_ContentFragmentContainer() +40

Telligent.Evolution.Controls.ContentFragmentPageBase.OnInit(EventArgs e) +127

System.Web.UI.Control.InitRecursive(Control namingContainer) +133

System.Web.UI.Control.InitRecursive(Control namingContainer) +421

System.Web.UI.Control.InitRecursive(Control namingContainer) +421

System.Web.UI.Control.InitRecursive(Control namingContainer) +421

System.Web.UI.Control.InitRecursive(Control namingContainer) +421

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1970

Verified Answer

Posted by Patrick Mason

on Mon, Mar 18 2013 6:46 PM

Verified Answer

Verified by Rex Sun

Correct, it would not be removed during the upgrade. You need to rollback and stand your 5.6 site up again and make the changes so they will not be present when you upgrade.

However, note you will no longer have LiveID support after your upgrade. If you still plan on using LiveID you will need to contact Professional Services in either case unless you will creating your own.

Patrick Mason
Development Lead- Extensibility
o: 214.420.1329
telligent.com

From: Rex Sun [mailto:bounce-RSun@communities.telligent.com]
Sent: Monday, March 18, 2013 1:34 PM
To: bugsandissues@communities.telligent.com
Subject: RE: [Bugs and Issues - Telligent Community] Error when update the DB from 5.6 to 7.x

2 things, Patrick.

1. Here are the detailed steps how I installed the 7.x Telligent Community site:

a. Copy over the downloaded official Telligent bits to Web server, set up IIS.

b. Migrate DB from 5.6 to 7.x using Telligent DB script.

c. Update the connection string to point to the DB in step b.

So, I think I didn't copy any dll and/or other files for any widget. But I guess the widget info was in the 5.6DB and was not removed during the migration.

2. Cause the login page is failing, I cannot use the control panel. So if you are mentioning to revert the widgets via control panel, please tall me any way/tool to hack into local cookies, so that I can access the control panel, please?

All Replies

Posted by Ben Tiedt

on Fri, Mar 15 2013 4:26 PM

Could you run the following query against your upgraded database? It will help diagnose what the problem is.

select f.Type, f.Configuration

from cs_ContentFragmentPages p

inner join cs_ConfiguredContentFragments f on p.Id = f.PageId

where p.PageName = 'common-login'

Posted by Rex Sun

on Mon, Mar 18 2013 3:56 PM

Sure, the query returns:

Type	Configuration
Telligent.LiveID.RPS.Controls.ContentFragments.Login, Telligent.LiveID.RPS	fragmentHeader=%24%7bresource%3aCore_Login_Name%7d
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	fragmentHeader=%24%7bresource%3aCore_Title_Title_Title%7d
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::b1db6b71c0be43b58925e469eb6315a4	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Login_Name}</value></property><property id="enableOpenId" dataType="Bool"><value>False</value></property><property id="mode" dataType="String"><value>login</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Title_Title_Title}</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::b1db6b71c0be43b58925e469eb6315a4	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Login_Name}</value></property><property id="mode" dataType="String"><value>login</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Title_Title_Title}</value></property></properties></dynamicConfiguration>
Telligent.LiveID.RPS.Controls.ContentFragments.Login, Telligent.LiveID.RPS	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>LiveID Login</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Title_Title_Title}</value></property></properties></dynamicConfiguration>
Telligent.LiveID.RPS.Controls.ContentFragments.Login, Telligent.LiveID.RPS	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>LiveID Login</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Title_Title_Title}</value></property></properties></dynamicConfiguration>

Posted by Patrick Mason

on Mon, Mar 18 2013 4:14 PM

This is because the LiveID module you are using is not compatible with 7.5. I recommend uninstalling it and reverting the pages back to default widgets prior to upgrading.

This module is also made available by our Professional Services organization, for assistance I would engage them which you can do by contacting support.

Patrick Mason
Development Lead- Extensibility
o: 214.420.1329
telligent.com

From: Rex Sun [mailto:bounce-RSun@communities.telligent.com]
Sent: Monday, March 18, 2013 10:56 AM
To: bugsandissues@communities.telligent.com
Subject: RE: [Bugs and Issues - Telligent Community] Error when update the DB from 5.6 to 7.x

Sure, the query returns:

Type	Configuration
Telligent.LiveID.RPS.Controls.ContentFragments.Login, Telligent.LiveID.RPS	fragmentHeader=%24%7bresource%3aCore_Login_Name%7d
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	fragmentHeader=%24%7bresource%3aCore_Title_Title_Title%7d
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::b1db6b71c0be43b58925e469eb6315a4	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Login_Name}</value></property><property id="enableOpenId" dataType="Bool"><value>False</value></property><property id="mode" dataType="String"><value>login</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Title_Title_Title}</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::b1db6b71c0be43b58925e469eb6315a4	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Login_Name}</value></property><property id="mode" dataType="String"><value>login</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Title_Title_Title}</value></property></properties></dynamicConfiguration>
Telligent.LiveID.RPS.Controls.ContentFragments.Login, Telligent.LiveID.RPS	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>LiveID Login</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Title_Title_Title}</value></property></properties></dynamicConfiguration>
Telligent.LiveID.RPS.Controls.ContentFragments.Login, Telligent.LiveID.RPS	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>LiveID Login</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Title_Title_Title}</value></property></properties></dynamicConfiguration>

Posted by Patrick Mason

on Mon, Mar 18 2013 4:40 PM

I meant 7.x J

Patrick Mason
Development Lead- Extensibility
o: 214.420.1329
telligent.com

From: Patrick Mason [mailto:bounce-pmason@communities.telligent.com]
Sent: Monday, March 18, 2013 11:15 AM
To: bugsandissues@communities.telligent.com
Subject: RE: [Bugs and Issues - Telligent Community] Error when update the DB from 5.6 to 7.x

This is because the LiveID module you are using is not compatible with 7.5. I recommend uninstalling it and reverting the pages back to default widgets prior to upgrading.

This module is also made available by our Professional Services organization, for assistance I would engage them which you can do by contacting support.

Patrick Mason
Development Lead- Extensibility
o: 214.420.1329
telligent.com

From: Rex Sun [mailto:bounce-RSun@communities.telligent.com]
Sent: Monday, March 18, 2013 10:56 AM
To: bugsandissues@communities.telligent.com
Subject: RE: [Bugs and Issues - Telligent Community] Error when update the DB from 5.6 to 7.x

Sure, the query returns:

Type	Configuration
Telligent.LiveID.RPS.Controls.ContentFragments.Login, Telligent.LiveID.RPS	fragmentHeader=%24%7bresource%3aCore_Login_Name%7d
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	fragmentHeader=%24%7bresource%3aCore_Title_Title_Title%7d
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::b1db6b71c0be43b58925e469eb6315a4	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Login_Name}</value></property><property id="enableOpenId" dataType="Bool"><value>False</value></property><property id="mode" dataType="String"><value>login</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Title_Title_Title}</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::b1db6b71c0be43b58925e469eb6315a4	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Login_Name}</value></property><property id="mode" dataType="String"><value>login</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Title_Title_Title}</value></property></properties></dynamicConfiguration>
Telligent.LiveID.RPS.Controls.ContentFragments.Login, Telligent.LiveID.RPS	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>LiveID Login</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Title_Title_Title}</value></property></properties></dynamicConfiguration>
Telligent.LiveID.RPS.Controls.ContentFragments.Login, Telligent.LiveID.RPS	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>LiveID Login</value></property></properties></dynamicConfiguration>
Telligent.Evolution.ScriptedContentFragments.ScriptedContentFragment, Telligent.Evolution.ScriptedContentFragments::af9000b6cc8c4f658c2046ffdc09c5db	<dynamicConfiguration><properties><property id="fragmentHeader" dataType="String"><value>${resource:Core_Title_Title_Title}</value></property></properties></dynamicConfiguration>

Posted by Rex Sun

on Mon, Mar 18 2013 4:56 PM

Thanks a lot for the looking into this and the reply, Patrick.

But how to "uninstalling it and reverting the pages back to default widgets prior to upgrading", please? What we did is to update the DB via a upgrading script. And we didn't install any widgets yet. I guess the widgets might not have been converted/reverted by the DB script yet? So actually we are referencing to the 5.6 widgets in the themes? Correct me if I am wrong please.

Posted by Patrick Mason

on Mon, Mar 18 2013 6:26 PM

I assume you had it installed prior correct? Which means the login page and create user page were potentially edited. This means the definition is stored in the database. You should revert them using the revert option on each page before doing any work.

As for uninstall you need to remove the dlls, files and overrides it may use. I do not have a comprehensive list, that will need to come from our services team

Patrick Mason
Development Lead- Extensibility
o: 214.420.1329
telligent.com

From: Rex Sun [mailto:bounce-RSun@communities.telligent.com]
Sent: Monday, March 18, 2013 11:56 AM
To: bugsandissues@communities.telligent.com
Subject: RE: [Bugs and Issues - Telligent Community] Error when update the DB from 5.6 to 7.x

Thanks a lot for the looking into this and the reply, Patrick.

But how to "uninstalling it and reverting the pages back to default widgets prior to upgrading", please? What we did is to update the DB via a upgrading script. And we didn't install any widgets yet. I guess the widgets might not have been converted/reverted by the DB script yet? So actually we are referencing to the 5.6 widgets in the themes? Correct me if I am wrong please.

Posted by Rex Sun

on Mon, Mar 18 2013 6:34 PM

2 things, Patrick.

1. Here are the detailed steps how I installed the 7.x Telligent Community site:

a. Copy over the downloaded official Telligent bits to Web server, set up IIS.

b. Migrate DB from 5.6 to 7.x using Telligent DB script.

c. Update the connection string to point to the DB in step b.

So, I think I didn't copy any dll and/or other files for any widget. But I guess the widget info was in the 5.6DB and was not removed during the migration.

2. Cause the login page is failing, I cannot use the control panel. So if you are mentioning to revert the widgets via control panel, please tall me any way/tool to hack into local cookies, so that I can access the control panel, please?

Posted by Patrick Mason

on Mon, Mar 18 2013 6:46 PM

Verified Answer

Verified by Rex Sun

Correct, it would not be removed during the upgrade. You need to rollback and stand your 5.6 site up again and make the changes so they will not be present when you upgrade.

However, note you will no longer have LiveID support after your upgrade. If you still plan on using LiveID you will need to contact Professional Services in either case unless you will creating your own.

Patrick Mason
Development Lead- Extensibility
o: 214.420.1329
telligent.com

From: Rex Sun [mailto:bounce-RSun@communities.telligent.com]
Sent: Monday, March 18, 2013 1:34 PM
To: bugsandissues@communities.telligent.com
Subject: RE: [Bugs and Issues - Telligent Community] Error when update the DB from 5.6 to 7.x

2 things, Patrick.

1. Here are the detailed steps how I installed the 7.x Telligent Community site:

a. Copy over the downloaded official Telligent bits to Web server, set up IIS.

b. Migrate DB from 5.6 to 7.x using Telligent DB script.

c. Update the connection string to point to the DB in step b.

So, I think I didn't copy any dll and/or other files for any widget. But I guess the widget info was in the 5.6DB and was not removed during the migration.

2. Cause the login page is failing, I cannot use the control panel. So if you are mentioning to revert the widgets via control panel, please tall me any way/tool to hack into local cookies, so that I can access the control panel, please?

Posted by Ben Tiedt

on Tue, Mar 19 2013 7:57 PM

Suggested Answer

I'm not sure how the Live ID widget was saved with invalid configuration data, but it can be corrected by running the following SQL Script:

update cs_ConfiguredContentFragments

set Configuration = null

where [Type] = 'Telligent.LiveID.RPS.Controls.ContentFragments.Login, Telligent.LiveID.RPS'

and convert(nvarchar(max), Configuration) = 'fragmentHeader=%24%7bresource%3aCore_Login_Name%7d'