More in this section
Forums / Deployment / Page deployment scripts with controls

Page deployment scripts with controls

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
2 posts, 0 answered
  1. bemara57
    bemara57 avatar
    135 posts
    27 Mar 2008
    10 Jan 2011
    Link to this post
    I am trying to migrate all created pages and controls that are on one server to another. I attempted to generate SQL scripts for all data on the source DB to the target DB, but every time I click on any of the public pages (either from admin or frontend), I get the below error.

    Is there a list of tables that I should generate SQL scripts for (including the controls that reside on them). Both source and destination Sitefinity websites have the same code base if this helps (so controls will have same type/paths).

    Server Error in '/UltimateSuite' Application.

    Object reference not set to an instance of an object.

    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.NullReferenceException: Object reference not set to an instance of an object.

    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: 

    [NullReferenceException: Object reference not set to an instance of an object.]
       Telerik.Cms.Data.PageContentBase.get_Controls() +195
       Telerik.Cms.Data.PageBase.get_Controls() +17
       Telerik.Cms.Web.PreviewPage.CreateChildControls() +680
       System.Web.UI.Control.EnsureChildControls() +87
       System.Web.UI.Control.PreRenderRecursiveInternal() +44
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842

    Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4955
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    12 Sep 2017
    10 Jan 2011
    Link to this post
    Hi bemara57,

    This is some null reference exception because of a missing record for a control.

    1. You can use database backup
    2. Schema comparison tool - there is a built-in option in Visual Studio for this.

    There are more than 10 tables involved in the page "content".

    • dbo.sf_CmsControlProperty
    • dbo.sf_CmsCtrlLinks
    • dbo.sf_CmsHeaderControl
    • dbo.sf_CmsPageContent
    • dbo.sf_CmsPageProps
    • dbo.sf_CmsPageTemplate
    • dbo.sf_CmsWebControl
    • dbo.sf_PageBase
    • dbo.sf_PageContentBase
    • dbo.sf_PagesOutputCache
    • dbo.sf_Pers_Variables
    • dbo.sf_Personalization
    • dbo.sf_SecPerms
    • dbo.sf_SecVariables
    • dbo.sf_StagedCtrlLinks
    • dbo.sf_StagedPageContent
    • dbo.sf_VersVariables
    • dbo.sf_VrsTxtData
    • dbo.sf_WebControlBase

    Best wishes,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
2 posts, 0 answered