web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : kKvq+R8PunIFOHmWFIOsvf
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Managed Solution Impor...
Power Apps - Microsoft Dataverse
Answered

Managed Solution Import - Missing Table required by... the missing table?!

Like (1) ShareShare
ReportReport
Posted on 11 Jan 2022 17:06:56 by WayneIles 19

Strange one here. Just importing a managed solution from Dev > UAT for testing purposes. I'm getting a single missing depency error when trying to import whereby the missing table is required by... itself?! The table is, of course, in the managed solution. 


Never seen this happen before?! Any help appreciated...

 

Dependency.jpg

 

 

 

 

 

Categories:
Solution Explorer
Tables
Microsoft Dataverse
I have the same question (0)
  • Ram Prakash Profile Picture
    Ram Prakash 5,520 Super User 2025 Season 2 on 11 Jan 2022 at 17:13:14
    Re: Managed Solution Import - Missing Table required by... the missing table?!

    Hello @WayneIles,

     

    Hope you are doing good, this issue may happen because of below scinario's

     

    1. Make Sure you PUBLISH your solution before Exporting in DEV environment

     

    2. In the Dev Environment --> Click on the Table and Select ADD REQUIRED COMPONENTS --> PUBLISH and Import it

     

    3. Try Removing the Entity and ADD IT AGAIN --> PUBLISH and Import it

     

    Any one of the three can help you 

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Blog : https://microsoftcrmtechie.blogspot.com

  • WayneIles Profile Picture
    WayneIles 19 on 11 Jan 2022 at 17:46:07
    Re: Managed Solution Import - Missing Table required by... the missing table?!

    Have of course done 1 & 3 multiple times with same results.

     

    RE: #2 - I really don’t want to bloat this solution and include ALL components from the ‘Master Project’ table. Largely because this is a really simple lightweight model driven app – solution contains just 4 tables, 2 choices, a site map and a MDA.

     

    Beneath the Master Projects table there is a large hierarchy of 1:N relationships that are completely unrelated to this solution (and will be moved to UAT in separate solution(s) in due course). I’d have to add dozens of other tables, choices etc to this solution just to workaround this problem - which in itself makes absolutely no sense at all!!!

     

    It’s worth noting that there are zero other dependency issues mentioned in the error log, which leads me to believe there’s no issues with components I’ve excluded from the Master Project table within the solution.

  • Ram Prakash Profile Picture
    Ram Prakash 5,520 Super User 2025 Season 2 on 11 Jan 2022 at 18:49:05
    Re: Managed Solution Import - Missing Table required by... the missing table?!

    Hello @WayneIles 

     

    That was strange, can you please try this last attempt which am having in my mind

     

    Download XRMToolbox tool

     And install component "DependencyIdentifier"

     

    https://github.com/Power-Maverick/DependencyIdentifier

     

     

    Please mark as Answer if it is helpful and provide Kudos

     

     

    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

    Blog : https://microsoftcrmtechie.blogspot.com

  • AnttiKai Profile Picture
    AnttiKai 64 on 11 Aug 2022 at 13:13:39
    Re: Managed Solution Import - Missing Table required by... the missing table?!

    Hey @WayneIles I'd be really happy to hear if you solved the issue or if you can point me towards material that is helpful in this situation. I'm facing the exact same problem currently..

    regards, have a nice day all!
    /Antti

  • Verified answer
    WayneIles Profile Picture
    WayneIles 19 on 11 Aug 2022 at 13:39:42
    Re: Managed Solution Import - Missing Table required by... the missing table?!

    Hey @AnttiKai 

     

    Was a while ago now but this was related to active business rules on the table in the target environment that had been deleted from the managed solution that I was trying to import from the source environment. 

    Annoyingly the dependency pop up doesn’t mention business rules at all, hence my initial confusion. 

    As it was a managed solution I couldn’t delete the business rule from the target environment - memory is hazy but I’m pretty sure I simply deactivated the business rule in target, then importing the managed solution (with deleted business rule) worked fine. 

     

     

  • AnttiKai Profile Picture
    AnttiKai 64 on 12 Aug 2022 at 10:56:54
    Re: Managed Solution Import - Missing Table required by... the missing table?!

    Hey @WayneIles thanks for the info! Unluckily this does not solve my issue. I'm trying to import into a blank environment and these two tables have become tangled within themselves in some weird way...

    Have a good day!

  • Verified answer
    AnttiKai Profile Picture
    AnttiKai 64 on 12 Aug 2022 at 14:45:53
    Re: Managed Solution Import - Missing Table required by... the missing table?!

    And giving anoter reply if someone comes here looking for the answer. For me the problem was (for now) solved by:

    1. Creating a new solution with all the same, needed components, making sure to "include table metadata" and NOT "Include all objects"
    2. After export, editing the solution.xml file found within the exported Zip folder to comment out those missing dependencies that give error when starting the import. This was done for a few circular references because who knows why some tables might want to require themselves.

  • BrainSlugs83 Profile Picture
    BrainSlugs83 7 on 14 Sep 2022 at 02:27:44
    Re: Managed Solution Import - Missing Table required by... the missing table?!

    @AnttiKai your answer is the only thing that worked for me.  Kinda lame that it wanted to include circular references in the package so badly.  This really feels like a bug to me.

     

    Anyway, I ended up scripting this in PowerShell to remove circular references from our solutions (via our ADO Build Pipeline; this should be run this after the solution is exported and extracted with PAC):

     

    # Find all "Solution.xml" files, recursively
$solutions = gci -recu -inc "Solution.xml"

# For each file found:
foreach($solution in $solutions)
{
 $xml = [System.Xml.XmlDocument](cat $solution);
 $mdeps = $xml.SelectNodes("/ImportExportXml/SolutionManifest/MissingDependencies/MissingDependency");

 $changes = $false;
 foreach($mdep in $mdeps)
 {
 # Grab the Required and Dependent tags:
 $req = $mdep.SelectSingleNode("Required");
 $dep = $mdep.SelectSingleNode("Dependent");

 # skip any dependencies that don't have type and schemaName defined for both. 
 if (-not (($req.Attributes | % { $_.Name }) -icontains "type")) { continue; }
 if (-not (($dep.Attributes | % { $_.Name }) -icontains "type")) { continue; }
 if (-not (($req.Attributes | % { $_.Name }) -icontains "schemaName")) { continue; }
 if (-not (($dep.Attributes | % { $_.Name }) -icontains "schemaName")) { continue; }

 # Do the types match for both the required and the dependent tag?
 if ($req.Attributes["type"].Value.ToString() -eq $dep.Attributes["type"].Value.ToString())
 {
 # Do the names match for both the required and the dependent tag?
 if ($req.Attributes["schemaName"].Value.ToString() -eq $dep.Attributes["schemaName"].Value.ToString())
 {
 # Are the tags otherwise identical (aside from their tag name and the solution attribute)?
 
 if (($req.Attributes | % { $_.Name }) -icontains "solution")
 {
 if ($req.Attributes["solution"].Value.ToString() -ieq "Active")
 { [void]$req.RemoveAttribute("solution"); }
 }
 
 if (($dep.Attributes | % { $_.Name }) -icontains "solution")
 {
 if ($dep.Attributes["solution"].Value.ToString() -ieq "Active")
 { [void]$dep.RemoveAttribute("solution"); }
 }

 if ($req.OuterXml.Replace("<Required ", "<A ") -ieq $dep.OuterXml.Replace("<Dependent ", "<A "))
 {
 # Remove Circular Reference Dependency
 [void]$mdep.ParentNode.RemoveChild($mdep)
 $changes = $true;
 }
 }
 }
 }

 if ($changes)
 {
 $xml.Save($solution);
 Write-Host "Updated $solution."
 }
}

     

     

     

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 629 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 397 Super User 2025 Season 2

#3
wolenberg_ Profile Picture

wolenberg_ 232 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans