More in this section

Forums / Bugs & Issues / Upgrade error

Upgrade error

3 posts, 1 answered
  1. James
    James avatar
    33 posts
    Registered:
    03 Apr 2011
    04 May 2011
    Link to this post

    After upgrade I get this error on all pages. The error happened when I went to edit a page in the backend, before this it was working fine.

    Server Error in '/' Application.

    Cannot find the object "sf_draft_pages.idx_sf_draft_pages_content_id" because it does not exist or you do not have permissions.

    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: Telerik.OpenAccess.RT.sql.SQLException: Cannot find the object "sf_draft_pages.idx_sf_draft_pages_content_id" because it does not exist or you do not have permissions.

    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: Cannot find the object "sf_draft_pages.idx_sf_draft_pages_content_id" because it does not exist or you do not have permissions.]
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeUpdate(String sql) +420
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.execute(String sql) +9
       OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +459
    
    [OpenAccessException: SQL exception on 'DROP INDEX [idx_sf_draft_pages_content_id] ON [sf_draft_pages]' : Cannot find the object "sf_draft_pages.idx_sf_draft_pages_content_id" because it does not exist or you do not have permissions.]
       Telerik.OpenAccess.RT.ExceptionWrapper.Throw() +13
       OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.throwBuildException(String str, Exception e) +47
       OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +639
       OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.runScript(String script) +142
       OpenAccessRuntime.DataObjects.tools.ant.ExecuteScriptTask.execute() +359
    
    [OpenAccessException: Telerik.OpenAccess.OpenAccessException: SQL exception on 'DROP INDEX [idx_sf_draft_pages_content_id] ON [sf_draft_pages]' : Cannot find the object "sf_draft_pages.idx_sf_draft_pages_content_id" because it does not exist or you do not have permissions.]
       Telerik.OpenAccess.RT.ExceptionWrapper.Throw() +13
       OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.throwBuildException(String str, Exception e) +47
       OpenAccessRuntime.DataObjects.tools.ant.ExecuteScriptTask.execute() +712
       Telerik.OpenAccess.RT.OpenAccessSchemaAdapter.ExecuteDDLScript(String ddl) +546
       Telerik.OpenAccess.SchemaHandlerImpl.Telerik.OpenAccess.ISchemaHandler.ExecuteDDLScript(String ddl) +67
       Telerik.Sitefinity.Data.OA.OpenAccessConnection.UpdateMetadata(MetadataSource metadataSource, String moduleName, List`1 dynamicTypesToRegister, IOpenAccessUpgradableProvider upgradable) +2105
    
    [Exception: Unable to upgrade database schema metadataSource provided by 'Telerik.Sitefinity.Modules.Pages.Data.OpenAccessPageProvider': Telerik.OpenAccess.OpenAccessException: SQL exception on 'DROP INDEX [idx_sf_draft_pages_content_id] ON [sf_draft_pages]' : Cannot find the object "sf_draft_pages.idx_sf_draft_pages_content_id" because it does not exist or you do not have permissions.]
       DynamicModule.ns.Wrapped_OpenAccessPageProvider_6e323269963e472288d91d7ec9d14342.Initialize(String providerName, NameValueCollection config, Type managerType) +405
       Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager) +2211
       Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, ManagerBase`1 manager) +74
       Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +214
       Telerik.Sitefinity.Modules.Pages.PageManager..ctor() +93
       Telerik.Sitefinity.Modules.Pages.PageManager..cctor() +41
    
    [TypeInitializationException: The type initializer for 'Telerik.Sitefinity.Modules.Pages.PageManager' threw an exception.]
       Telerik.Sitefinity.Modules.Pages.PageManager.GetManager(String providerName) +0
       Telerik.Sitefinity.Web.SiteMapBase.Initialize(String name, NameValueCollection attributes) +760
       Telerik.Sitefinity.Web.SiteMapBase.GetSiteMapProvider(String rootName) +384
       Telerik.Sitefinity.Web.SitefinityRoute.GetRouteData(HttpContextBase httpContext) +95
       System.Web.Routing.RouteCollection.GetRouteData(HttpContextBase httpContext) +370
       System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context) +75
       System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +266
    


    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
  2. Udi
    Udi avatar
    11 posts
    Registered:
    11 Jan 2011
    04 May 2011
    Link to this post
    we have sql 2005 -> IT guys added dd_ddladmin to the user in the sql security and bug vanished
    Answered
  3. James
    James avatar
    33 posts
    Registered:
    03 Apr 2011
    04 May 2011
    Link to this post
    Thanks Udi.

    ddladmin didn't work, so I temporarily changed the sql user to sa and let it do the updates before setting it back and it worked...

    Why they don't mention that the db user needs elevated privileges to upgrade SF is beyond me.
3 posts, 1 answered