1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Upgrade Issue 4.1 in alter tables

Upgrade Issue 4.1 in alter tables

2 posts, 0 answered
  1. Joel
    Joel avatar
    40 posts
    Registered:
    30 Nov 2010
    11 May 2011
    Link to this post

    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
    
  2. Joel
    Joel avatar
    40 posts
    Registered:
    30 Nov 2010
    12 May 2011
    Link to this post
    Tabled this- started over, never mind.
2 posts, 0 answered