Upgrade error

Posted by Community Admin on 04-Aug-2018 08:45

Upgrade error

Sitefinity - Bugs & Issues

All Replies

Posted by Community Admin on 04-May-2011 00:00

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

Posted by Community Admin on 04-May-2011 00:00

we have sql 2005 -> IT guys added dd_ddladmin to the user in the sql security and bug vanished

Posted by Community Admin on 04-May-2011 00:00

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.

This thread is closed