We have ADX version 7 installed on our crm dynamics 365. We are trying to uninstall the managed solutions of ADX V7 in order to install V8.3 solutions.
We have managed to uninstall multiple solutions but ended up failing to do it for the rest with below error:
note: we are uninstalling in FILO order
ADXStudioPortals
We are not able to delete the dependencies.
*This post is locked for comments
we uninstalled solutions LIFO & we reached the solution called adxstudio Forum
We get an error : below
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: SqlException: Invalid column name 'adx_Locked'., View Script: if exists (select * from sys.objects where name = 'Adx_communityforumthread' and type = 'V')
begin
drop view [Adx_communityforumthread]
end
go
--
-- base view for Adx_communityforumthread
--
create view dbo.[Adx_communityforumthread]
(
-- logical attributes
[adx_forumidName],
[CreatedByName],
[CreatedByYomiName],
[CreatedOnBehalfByName],
[CreatedOnBehalfByYomiName],
[adx_typeidName],
[ModifiedByName],
[ModifiedByYomiName],
[ModifiedOnBehalfByName],
[ModifiedOnBehalfByYomiName],
[adx_firstpostidName],
[adx_lastpostidName],
[adx_publishingstateidName],
-- ownership entries
OwnerId,
OwnerIdName,
OwnerIdYomiName,
OwnerIdDsc,
OwnerIdType,
OwningUser,
OwningTeam,
-- physical attributes
[Adx_communityforumthreadId],
[CreatedOn],
[CreatedBy],
[ModifiedOn],
[ModifiedBy],
[CreatedOnBehalfBy],
[ModifiedOnBehalfBy],
[OwningBusinessUnit],
[statecode],
[statuscode],
[VersionNumber],
[ImportSequenceNumber],
[OverriddenCreatedOn],
[TimeZoneRuleVersionNumber],
[UTCConversionTimeZoneCode],
[Adx_name],
[Adx_IsAnswered],
[adx_lastpostdate],
[Adx_PostCount],
[Adx_Sticky],
[Adx_ViewCount],
[adx_forumid],
[adx_lastpostid],
[adx_firstpostid],
[adx_typeid],
[adx_publishingstateid],
[adx_Locked]
) with view_metadata as
select
-- logical attributes
[adx_communityforum_communityforumthread].[Adx_name],
[lk_adx_communityforumthread_createdby].[FullName],
[lk_adx_communityforumthread_createdby].[YomiFullName],
[lk_adx_communityforumthread_createdonbehalfby].[FullName],
[lk_adx_communityforumthread_createdonbehalfby].[YomiFullName],
[adx_forumthreadtype_communityforumthread].[Adx_name],
[lk_adx_communityforumthread_modifiedby].[FullName],
[lk_adx_communityforumthread_modifiedby].[YomiFullName],
[lk_adx_communityforumthread_modifiedonbehalfby].[FullName],
[lk_adx_communityforumthread_modifiedonbehalfby].[YomiFullName],
[adx_communityforumthrea_firstpost].[Adx_name],
[adx_communityforumpost_communityforumthread].[Adx_name],
[adx_publishingstate_communityforumthread].[Adx_name],
-- ownership entries
OwnerId = [Adx_communityforumthreadBase].OwnerId,
OwnerName = XXowner.Name,
OwnerYomiName = XXowner.YomiName,
OwnerDsc = 0, -- DSC is removed, stub it to 0
OwnerIdType = XXowner.OwnerIdType,
OwningUser = case
when XXowner.OwnerIdType= 8 then XXowner.OwnerId
else null
end,
OwningTeam = case
when XXowner.OwnerIdType= 9 then XXowner.OwnerId
else null
end,
-- physical attribute
[Adx_communityforumthreadBase].[Adx_communityforumthreadId],
[Adx_communityforumthreadBase].[CreatedOn],
[Adx_communityforumthreadBase].[CreatedBy],
[Adx_communityforumthreadBase].[ModifiedOn],
[Adx_communityforumthreadBase].[ModifiedBy],
[Adx_communityforumthreadBase].[CreatedOnBehalfBy],
[Adx_communityforumthreadBase].[ModifiedOnBehalfBy],
[Adx_communityforumthreadBase].[OwningBusinessUnit],
[Adx_communityforumthreadBase].[statecode],
[Adx_communityforumthreadBase].[statuscode],
[Adx_communityforumthreadBase].[VersionNumber],
[Adx_communityforumthreadBase].[ImportSequenceNumber],
[Adx_communityforumthreadBase].[OverriddenCreatedOn],
[Adx_communityforumthreadBase].[TimeZoneRuleVersionNumber],
[Adx_communityforumthreadBase].[UTCConversionTimeZoneCode],
[Adx_communityforumthreadBase].[Adx_name],
[Adx_communityforumthreadBase].[Adx_IsAnswered],
[Adx_communityforumthreadBase].[adx_lastpostdate],
[Adx_communityforumthreadBase].[Adx_PostCount],
[Adx_communityforumthreadBase].[Adx_Sticky],
[Adx_communityforumthreadBase].[Adx_ViewCount],
[Adx_communityforumthreadBase].[adx_forumid],
[Adx_communityforumthreadBase].[adx_lastpostid],
[Adx_communityforumthreadBase].[adx_firstpostid],
[Adx_communityforumthreadBase].[adx_typeid],
[Adx_communityforumthreadBase].[adx_publishingstateid],
[Adx_communityforumthreadBase].[adx_Locked]
from [Adx_communityforumthreadBase]
left join [Adx_communityforumBase] [adx_communityforum_communityforumthread] on ([Adx_communityforumthreadBase].[adx_forumid] = [adx_communityforum_communityforumthread].[Adx_communityforumId])
left join [Adx_communityforumpostBase] [adx_communityforumpost_communityforumthread] on ([Adx_communityforumthreadBase].[adx_lastpostid] = [adx_communityforumpost_communityforumthread].[Adx_communityforumpostId])
left join [Adx_communityforumpostBase] [adx_communityforumthrea_firstpost] on ([Adx_communityforumthreadBase].[adx_firstpostid] = [adx_communityforumthrea_firstpost].[Adx_communityforumpostId])
left join [Adx_forumthreadtypeBase] [adx_forumthreadtype_communityforumthread] on ([Adx_communityforumthreadBase].[adx_typeid] = [adx_forumthreadtype_communityforumthread].[Adx_forumthreadtypeId])
left join [Adx_publishingstateBase] [adx_publishingstate_communityforumthread] on ([Adx_communityforumthreadBase].[adx_publishingstateid] = [adx_publishingstate_communityforumthread].[Adx_publishingstateId])
left join [SystemUserBase] [lk_adx_communityforumthread_createdby] with(nolock) on ([Adx_communityforumthreadBase].[CreatedBy] = [lk_adx_communityforumthread_createdby].[SystemUserId])
left join [SystemUserBase] [lk_adx_communityforumthread_createdonbehalfby] with(nolock) on ([Adx_communityforumthreadBase].[CreatedOnBehalfBy] = [lk_adx_communityforumthread_createdonbehalfby].[SystemUserId])
left join [SystemUserBase] [lk_adx_communityforumthread_modifiedby] with(nolock) on ([Adx_communityforumthreadBase].[ModifiedBy] = [lk_adx_communityforumthread_modifiedby].[SystemUserId])
left join [SystemUserBase] [lk_adx_communityforumthread_modifiedonbehalfby] with(nolock) on ([Adx_communityforumthreadBase].[ModifiedOnBehalfBy] = [lk_adx_communityforumthread_modifiedonbehalfby].[SystemUserId])
left join OwnerBase XXowner with(nolock) on ([Adx_communityforumthreadBase].OwnerId = XXowner.OwnerId)
go
Detail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
<ActivityId>e069df3d-8c00-4e49-bdfe-918571b82291</ActivityId>
<ErrorCode>-2147220970</ErrorCode>
<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>SqlException: Invalid column name 'adx_Locked'., View Script: if exists (select * from sys.objects where name = 'Adx_communityforumthread' and type = 'V')
begin
drop view [Adx_communityforumthread]
end
go
--
-- base view for Adx_communityforumthread
--
create view dbo.[Adx_communityforumthread]
(
-- logical attributes
[adx_forumidName],
[CreatedByName],
[CreatedByYomiName],
[CreatedOnBehalfByName],
[CreatedOnBehalfByYomiName],
[adx_typeidName],
[ModifiedByName],
[ModifiedByYomiName],
[ModifiedOnBehalfByName],
[ModifiedOnBehalfByYomiName],
[adx_firstpostidName],
[adx_lastpostidName],
[adx_publishingstateidName],
-- ownership entries
OwnerId,
OwnerIdName,
OwnerIdYomiName,
OwnerIdDsc,
OwnerIdType,
OwningUser,
OwningTeam,
-- physical attributes
[Adx_communityforumthreadId],
[CreatedOn],
[CreatedBy],
[ModifiedOn],
[ModifiedBy],
[CreatedOnBehalfBy],
[ModifiedOnBehalfBy],
[OwningBusinessUnit],
[statecode],
[statuscode],
[VersionNumber],
[ImportSequenceNumber],
[OverriddenCreatedOn],
[TimeZoneRuleVersionNumber],
[UTCConversionTimeZoneCode],
[Adx_name],
[Adx_IsAnswered],
[adx_lastpostdate],
[Adx_PostCount],
[Adx_Sticky],
[Adx_ViewCount],
[adx_forumid],
[adx_lastpostid],
[adx_firstpostid],
[adx_typeid],
[adx_publishingstateid],
[adx_Locked]
) with view_metadata as
select
-- logical attributes
[adx_communityforum_communityforumthread].[Adx_name],
[lk_adx_communityforumthread_createdby].[FullName],
[lk_adx_communityforumthread_createdby].[YomiFullName],
[lk_adx_communityforumthread_createdonbehalfby].[FullName],
[lk_adx_communityforumthread_createdonbehalfby].[YomiFullName],
[adx_forumthreadtype_communityforumthread].[Adx_name],
[lk_adx_communityforumthread_modifiedby].[FullName],
[lk_adx_communityforumthread_modifiedby].[YomiFullName],
[lk_adx_communityforumthread_modifiedonbehalfby].[FullName],
[lk_adx_communityforumthread_modifiedonbehalfby].[YomiFullName],
[adx_communityforumthrea_firstpost].[Adx_name],
[adx_communityforumpost_communityforumthread].[Adx_name],
[adx_publishingstate_communityforumthread].[Adx_name],
-- ownership entries
OwnerId = [Adx_communityforumthreadBase].OwnerId,
OwnerName = XXowner.Name,
OwnerYomiName = XXowner.YomiName,
OwnerDsc = 0, -- DSC is removed, stub it to 0
OwnerIdType = XXowner.OwnerIdType,
OwningUser = case
when XXowner.OwnerIdType= 8 then XXowner.OwnerId
else null
end,
OwningTeam = case
when XXowner.OwnerIdType= 9 then XXowner.OwnerId
else null
end,
-- physical attribute
[Adx_communityforumthreadBase].[Adx_communityforumthreadId],
[Adx_communityforumthreadBase].[CreatedOn],
[Adx_communityforumthreadBase].[CreatedBy],
[Adx_communityforumthreadBase].[ModifiedOn],
[Adx_communityforumthreadBase].[ModifiedBy],
[Adx_communityforumthreadBase].[CreatedOnBehalfBy],
[Adx_communityforumthreadBase].[ModifiedOnBehalfBy],
[Adx_communityforumthreadBase].[OwningBusinessUnit],
[Adx_communityforumthreadBase].[statecode],
[Adx_communityforumthreadBase].[statuscode],
[Adx_communityforumthreadBase].[VersionNumber],
[Adx_communityforumthreadBase].[ImportSequenceNumber],
[Adx_communityforumthreadBase].[OverriddenCreatedOn],
[Adx_communityforumthreadBase].[TimeZoneRuleVersionNumber],
[Adx_communityforumthreadBase].[UTCConversionTimeZoneCode],
[Adx_communityforumthreadBase].[Adx_name],
[Adx_communityforumthreadBase].[Adx_IsAnswered],
[Adx_communityforumthreadBase].[adx_lastpostdate],
[Adx_communityforumthreadBase].[Adx_PostCount],
[Adx_communityforumthreadBase].[Adx_Sticky],
[Adx_communityforumthreadBase].[Adx_ViewCount],
[Adx_communityforumthreadBase].[adx_forumid],
[Adx_communityforumthreadBase].[adx_lastpostid],
[Adx_communityforumthreadBase].[adx_firstpostid],
[Adx_communityforumthreadBase].[adx_typeid],
[Adx_communityforumthreadBase].[adx_publishingstateid],
[Adx_communityforumthreadBase].[adx_Locked]
from [Adx_communityforumthreadBase]
left join [Adx_communityforumBase] [adx_communityforum_communityforumthread] on ([Adx_communityforumthreadBase].[adx_forumid] = [adx_communityforum_communityforumthread].[Adx_communityforumId])
left join [Adx_communityforumpostBase] [adx_communityforumpost_communityforumthread] on ([Adx_communityforumthreadBase].[adx_lastpostid] = [adx_communityforumpost_communityforumthread].[Adx_communityforumpostId])
left join [Adx_communityforumpostBase] [adx_communityforumthrea_firstpost] on ([Adx_communityforumthreadBase].[adx_firstpostid] = [adx_communityforumthrea_firstpost].[Adx_communityforumpostId])
left join [Adx_forumthreadtypeBase] [adx_forumthreadtype_communityforumthread] on ([Adx_communityforumthreadBase].[adx_typeid] = [adx_forumthreadtype_communityforumthread].[Adx_forumthreadtypeId])
left join [Adx_publishingstateBase] [adx_publishingstate_communityforumthread] on ([Adx_communityforumthreadBase].[adx_publishingstateid] = [adx_publishingstate_communityforumthread].[Adx_publishingstateId])
left join [SystemUserBase] [lk_adx_communityforumthread_createdby] with(nolock) on ([Adx_communityforumthreadBase].[CreatedBy] = [lk_adx_communityforumthread_createdby].[SystemUserId])
left join [SystemUserBase] [lk_adx_communityforumthread_createdonbehalfby] with(nolock) on ([Adx_communityforumthreadBase].[CreatedOnBehalfBy] = [lk_adx_communityforumthread_createdonbehalfby].[SystemUserId])
left join [SystemUserBase] [lk_adx_communityforumthread_modifiedby] with(nolock) on ([Adx_communityforumthreadBase].[ModifiedBy] = [lk_adx_communityforumthread_modifiedby].[SystemUserId])
left join [SystemUserBase] [lk_adx_communityforumthread_modifiedonbehalfby] with(nolock) on ([Adx_communityforumthreadBase].[ModifiedOnBehalfBy] = [lk_adx_communityforumthread_modifiedonbehalfby].[SystemUserId])
left join OwnerBase XXowner with(nolock) on ([Adx_communityforumthreadBase].OwnerId = XXowner.OwnerId)
go
</Message>
<Timestamp>2018-01-11T08:58:19.9563352Z</Timestamp>
<ExceptionRetriable>false</ExceptionRetriable>
<ExceptionSource i:nil="true" />
<InnerFault i:nil="true" />
<OriginalException i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>
And then if we go to Forum Thread we see that the field called adx_Locked does not have a display name anymore.
The screen you shared with the dependencies details shows you all of the dependencies you have that you need to remove before the solution can be deleted. You need to go through each dependency and remove it. For the most part, you should be able to click on the far right column for each row and you will be taken directly to the editor. For example, if you have a form that references a field you are attempting to delete, you will have to remove that field from the form before you can remove the managed solution. It is also not clear as to which solution you are attempting to remove, and if you have removed the other managed solutions that are stacked on top of it. We shipped about 20+ solutions and you have to remove them in the opposite order than they have been installed in. To make this actionable, you should probably note which solution you are attempting to uninstall and also show a picture as to which portal solutions you still have installed.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,253
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
