Upgrade error
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
we have sql 2005 -> IT guys added dd_ddladmin to the user in the sql security and bug vanished
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.