Ran into an issue that I can't riddle out. Was applying licensing via the sitefinity manager, mistakenly clicked upgrade (I didn't mean to, My site was running 4.1) then applied the new license file.

Also at this time, I had to switch the user account that talked to the SF db, but I believe his permissions are set properly.

Server Error in '/' Application.

The index 'idx_sf_taxa_taxonomy_id' is dependent on column 'taxonomy_id'.
ALTER TABLE ALTER COLUMN taxonomy_id failed because one or more objects access this column.

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: The index 'idx_sf_taxa_taxonomy_id' is dependent on column 'taxonomy_id'.
ALTER TABLE ALTER COLUMN taxonomy_id failed because one or more objects access this column.

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: The index 'idx_sf_taxa_taxonomy_id' is dependent on column 'taxonomy_id'.
ALTER TABLE ALTER COLUMN taxonomy_id failed because one or more objects access this column.]
   Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeUpdate(String sql) +207
   Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.execute(String sql) +5
   OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +300

[OpenAccessException: SQL exception on 'ALTER TABLE [sf_taxa] ALTER COLUMN [taxonomy_id] UNIQUEIDENTIFIER NOT NULL' : The index 'idx_sf_taxa_taxonomy_id' is dependent on column 'taxonomy_id'.
ALTER TABLE ALTER COLUMN taxonomy_id failed because one or more objects access this column.]
   Telerik.OpenAccess.RT.ExceptionWrapper.Throw() +7
   OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.throwBuildException(String str, Exception e) +36
   OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +355
   OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.runScript(String script) +111
   OpenAccessRuntime.DataObjects.tools.ant.ExecuteScriptTask.execute() +288

[OpenAccessException: Telerik.OpenAccess.OpenAccessException: SQL exception on 'ALTER TABLE [sf_taxa] ALTER COLUMN [taxonomy_id] UNIQUEIDENTIFIER NOT NULL' : The index 'idx_sf_taxa_taxonomy_id' is dependent on column 'taxonomy_id'.
ALTER TABLE ALTER COLUMN taxonomy_id failed because one or more objects access this column.]
   DynamicModule.ns.Wrapped_OpenAccessPageProvider_c1b0f4ca9ae94a8d822b33dd65b59f95.Initialize(String providerName, NameValueCollection config, Type managerType) +195
   Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager) +1477
   Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, ManagerBase`1 manager) +63
   Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +161
   Telerik.Sitefinity.Data.ManagerBase`1..ctor(String providerName, String transactionName) +131
   Telerik.Sitefinity.Modules.Pages.PageManager..ctor() +35
   Telerik.Sitefinity.Modules.Pages.PageManager..cctor() +35

[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) +583
   Telerik.Sitefinity.Web.SiteMapBase.GetSiteMapProvider(String rootName) +248
   Telerik.Sitefinity.Web.SitefinityRoute.GetRouteData(HttpContextBase httpContext) +68
   System.Web.Routing.RouteCollection.GetRouteData(HttpContextBase httpContext) +285
   System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context) +60
   System.Web.Routing.UrlRoutingModule.OnApplicationPostResolveRequestCache(Object sender, EventArgs e) +86
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +148
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

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

Tabled this- started over, never mind.

This thread is closed

Upgrade Issue 4.1 in alter tables

All Replies

Ran into an issue that I can't riddle out. Was applying licensing via the sitefinity manager, mistakenly clicked upgrade (I didn't mean to, My site was running 4.1) then applied the new license file.

Server Error in '/' Application.

The index 'idx_sf_taxa_taxonomy_id' is dependent on column 'taxonomy_id'. ALTER TABLE ALTER COLUMN taxonomy_id failed because one or more objects access this column.

The index 'idx_sf_taxa_taxonomy_id' is dependent on column 'taxonomy_id'.
ALTER TABLE ALTER COLUMN taxonomy_id failed because one or more objects access this column.