25
I upgraded my D 365 on-premise from V 8.2.3 to 8.2.15. After that I cannot import solution, the error is:
There should not be more than one component instance for a solution being upgraded. Solution id: xxxxxxx
How to resolve this issue?
Hi all,
Thanks for all of your replies, I am getting this error for three particular solutions and all of them contain plugins. After I further analyzing, I resolved this issue by following script:
DECLARE @pluginSolutionid NVARCHAR(50)
DECLARE @configSolutionid NVARCHAR(50)
DECLARE @docSolutionid NVARCHAR(50)
SELECT @pluginSolutionid=solutionId FROM Solution WHERE UniqueName ='Solution1'
SELECT @configSolutionid=solutionId FROM Solution WHERE UniqueName ='Solution2'
SELECT @docSolutionid=solutionId FROM Solution WHERE UniqueName ='Solution3'
----delete Plugin Assembly
DELETE FROM PluginAssemblyBase WHERE SolutionId IN (@pluginSolutionid,@configSolutionid,@docSolutionid)
OR supportingsolutionid IN(@pluginSolutionid,@configSolutionid,@docSolutionid) ;
----delete Plugin
DELETE FROM PluginTypeBase WHERE PluginTypeid IN(
SELECT ID FROM (
SELECT PluginTypeBase.PluginTypeId ID, PluginAssemblyBase.PluginAssemblyid AS assemblyid
FROM PluginTypeBase LEFT JOIN PluginAssemblyBase ON PluginTypeBase.PluginAssemblyid = PluginAssemblyBase.PluginAssemblyid )
AS A WHERE A.assemblyid IS NULL
)
----delete Sdk Message Processing Step
DELETE from SdkMessageProcessingStepBase WHERE SdkMessageProcessingStepid IN(
SELECT ID FROM (
SELECT SdkMessageProcessingStepBase.SdkMessageProcessingStepid ID, PluginTypeBase.plugintypeid AS plugin
FROM SdkMessageProcessingStepBase LEFT JOIN PluginTypeBase ON SdkMessageProcessingStepBase.plugintypeid= PluginTypeBase.plugintypeid )
AS A WHERE A.plugin IS NULL
)
----delete images
DELETE from SdkMessageProcessingStepImageBase where SdkMessageProcessingStepImageID IN(
SELECT ID FROM (
SELECT SdkMessageProcessingStepImageBase.SdkMessageProcessingStepImageID ID, SdkMessageProcessingStepBase.SdkMessageProcessingStepID AS StepID
FROM SdkMessageProcessingStepImageBase LEFT JOIN SdkMessageProcessingStepBase ON SdkMessageProcessingStepBase.SdkMessageProcessingStepid= SdkMessageProcessingStepImageBase.SdkMessageProcessingStepid )
as A WHERE A.StepID IS NULL
)
----delete dependencies
DELETE FROM Dependencybase WHERE DependentComponentNodeId IN ( SELECT dependencynodeid
FROM [CaRESmoke_MSCRM].[dbo].[DependencyNodeBase] WHERE ComponentType IN (90,91,92,93) AND basesolutionid IN (@pluginSolutionid,@configSolutionid,@docSolutionid))
or RequiredComponentNodeId IN( SELECT dependencynodeid
FROM [CaRESmoke_MSCRM].[dbo].[DependencyNodeBase] WHERE ComponentType IN (90,91,92,93) AND basesolutionid IN (@pluginSolutionid,@configSolutionid,@docSolutionid))
So far works fine.
If any other negative impacts I will post here and let you guys know.
Hi Wilf,
First question is you are getting this error for particular solution or any solution?
In case of particular solution, it looks like more of one of the solution components is not being upgraded to be compatible with upgraded on premise version.
In case of all the solution, its kind of you have missed something while upgrading the version or something else which can be answered by Microsoft.
Thanks
Hi Wilf Gong,
This error indicates there's duplicate solution layer detected. So, the import job failed. Can you please post the full error message here?
Normally, you should see the error like below:
"There should not be more than one component instance for a solution being upgraded. Solution id: xxxxxx-xxxx-xxxx Component Type: 9 Object Id: xxxxxx-xxxx-xxxx CurrentState: SolutionActive".
There should not be more than one component instance for a solution being upgraded. Solution id: xxxxxx-xxxx-xxxx Component Type: 2 Object Id: xxxxxx-xxxx-xxxx CurrentState: SolutionActive
Component type 2 indicates there's duplicate attributes, Component type 9 indicates the duplicate option set.
Once this is confirmed, you need to raise the support ticket to Microsoft. The support engineer will work with you to provide the fix for your solution. It needs the script to run on your CRM DB to fix this.
You can see the similar issue here: https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/51755/crm-2011-import-solution-error-error-there-should-not-be-more-than-one-component-instance-for-a-solution-being-upgraded?pifragment-97030=1
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
