Important: Potential issues when upgrading to CMS6 R2
Shortly after the release of CMS6 R2 we received a problem report describing issues when you upgrade a site that uses the “fetch data” feature. It turns out that there is a bug in one of the database upgrade scripts that results in loosing the reference to the fetched data page.
In an upgraded site affected pages will show up as empty pages. You can also verify if you are affected or not by executing the following SQL-query:
select fkPageId from tblworkpage where tblworkpage.linktype in (1,4)
The above query returns a row for all pages that are configured to fetch data from another page or is a shortcut to another page. If this query returns any rows on your site (before or after upgrade) you need to take action.
You can do one of two things to recover from this.
- Download the SQL script below and save it in c:\Program Files x86\EPiServer\CMS\6.1.379.0\Upgrade\Database\sql (replace the old one) before performing the upgrade.
- If you only have a few instances of pages that fetch data in the site and you have completed the upgrade it might be easier to manually go through the affected pages and set the fetch data reference once again.
We apologize for any inconvenience this may have caused.