November Happy Hour will be moved to Thursday December 5th.

smithsson68@gmail.com
Apr 11, 2012
  10707
(8 votes)

Problems with XForms when upgrading to CMS 6 R2

It seems that many people have had problems when upgrading an EPiServer CMS site to 6 R2 with the last part of the upgrade script.

What this tries to do is read all the XForm definitions from the database, perform a html decode on the form name, and then save the definition back to the database. Why this has to be done is not relevant to this post.

What is relevant is that it often doesn’t work for various reasons. This part of the script is run in a separate transaction after the main upgrade transaction has completed. The reason for this is that it has to run in a separate application domain in the context of the website.

If your site doesn’t use XForms or if you know that there aren’t any forms that have names that required html encoding then you can just ignore this error. As mentioned above, the main upgrade has been committed and your site should be ready to go.

If however you do need to run this part of the script and it keeps failing then there is a simple workaround.

Here you will find an ASPX file which contains the same code as the script executes. Place it in your site, execute it (i.e. browse to it’s Url) and it will do the business. When it’s finished it will tell you how many XForms it’s upgraded. If for some reason it should fail or get interrupted, it is safe to run again as it will only upgrade those XForms that need it.

When all is done you can just remove the ASPX from the site.

Voilà

Apr 11, 2012

Comments

Apr 11, 2012 04:02 PM

Great stuff Paul, now we can upgrade databases without having to use EPiServer Deployment Centre - if you know where the SQL upgrade scripts are of course ;)

Dec 9, 2013 12:23 PM

Hello Paul,

The link you provided for your script does not work. Can you please update the link?

Thank you!

Jun 13, 2014 11:38 AM

Please update the link

Jun 17, 2014 02:50 PM

Hi
Could you please update the link?

thanks!

//Pawel

Nitin Walawalkar
Nitin Walawalkar Jul 11, 2014 01:46 PM

I am unable to download the aspx page from the link

Please login to comment.
Latest blogs
Optimizely SaaS CMS + Coveo Search Page

Short on time but need a listing feature with filters, pagination, and sorting? Create a fully functional Coveo-powered search page driven by data...

Damian Smutek | Nov 21, 2024 | Syndicated blog

Optimizely SaaS CMS DAM Picker (Interim)

Simplify your Optimizely SaaS CMS workflow with the Interim DAM Picker Chrome extension. Seamlessly integrate your DAM system, streamlining asset...

Andy Blyth | Nov 21, 2024 | Syndicated blog

Optimizely CMS Roadmap

Explore Optimizely CMS's latest roadmap, packed with developer-focused updates. From SaaS speed to Visual Builder enhancements, developer tooling...

Andy Blyth | Nov 21, 2024 | Syndicated blog

Set Default Culture in Optimizely CMS 12

Take control over culture-specific operations like date and time formatting.

Tomas Hensrud Gulla | Nov 15, 2024 | Syndicated blog

I'm running Optimizely CMS on .NET 9!

It works 🎉

Tomas Hensrud Gulla | Nov 12, 2024 | Syndicated blog

Recraft's image generation with AI-Assistant for Optimizely

Recraft V3 model is outperforming all other models in the image generation space and we are happy to share: Recraft's new model is now available fo...

Luc Gosso (MVP) | Nov 8, 2024 | Syndicated blog