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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Failed to migrate powe...
Power Pages
Answered

Failed to migrate power pages using solution (Missing dependency lookup type = PrimaryKeyLookup)

(1) ShareShare
ReportReport
Posted on by

Hello,

 

I have been building a site in a developer environment for a while. Now my company wants to migrate it to a production environment to convert it to production so that our clients can test it. I put the site into a solution, exported it and tried to import it into the new environment but I always got error messages about dependencies. I tried to add components that were missing according to the error messages (choices, table columns, table relationships, ...) to the solution. It got to a point where I did't get this message with the list of missing components anymore and could proceed until I see the message "Currently importing solution..." at the top of the page. However, after a while I would always get this error message

"Solution "..." failed to import: The dependent component EntityDataSource (Id=500816e2-d7f7-ee11-a1fe-002248d88859) does not exist. Failure trying to associate it with Entity (Id=05dbf962-abff-4a70-8169-4e868fedad10) as a dependency. Missing dependency lookup type = PrimaryKeyLookup."

 

(The first Id is always the same but the second Id changes each time I try to import the solution)

This time I have no idea which component is the problem because it only shows the Id and not the name. Could you tell me how I can search for it and maybe add it to the solution? I also use virtual tables (from SQL) on my site. Could this be the cause of this error and what do I have to add to the solution or how can I solve it?

 

 

Also when I open the "solution" xml file in the exported zip solution filed, there are still these error messages regarding missing dependencies even though it doesn't show the list of missing components anymore when I import the solution.

 

<MissingDependency>
<Required type="181" schemaName="Virtual Connector Data Provider" displayName="Virtual Connector Data Provider" solution="msft_ConnectorProvider (9.1.0.202)" id="{b581d5dc-72e1-ea11-a81e-000d3af5fff1}">
<package>msft_ConnectorProviderAnchor (9.1.0.202)</package>
</Required>
<Dependent type="1" schemaName="..." displayName="..."/>
</MissingDependency>
 
...
 
<MissingDependency>
<Required type="26" schemaName="All Contacts" displayName="All Contacts" parentSchemaName="contact" parentDisplayName="Contact" solution="msdynce_AppCommon (9.0.4.0066)" id="{0d5d377b-5e7c-47b5-bab1-a5cb8b4ac105}">
<package>msdynce_AppCommonAnchor (9.0.24063.10001)</package>
</Required>
<Dependent type="60" displayName="..." parentDisplayName="Account" id="..."/>
</MissingDependency>
 
...
 
<MissingDependency>
<Required type="26" schemaName="Latest" displayName="Latest" parentSchemaName="contact" parentDisplayName="Contact" solution="PowerPages_ProgramRegistrationCore_V2 (2.0.2306.2)" id="{1e4f3b74-771f-ec11-b6e6-000d3a57224b}">
<package>PowerPages_ProgramRegistration_V2 (3.0.2402.10)</package>
</Required>
<Dependent type="60" displayName="caisec_organization_form_create" parentDisplayName="Account" id="{60b3dfe3-6df2-ee11-a1fd-002248d8871a}"/>
</MissingDependency>
 
...
 
<MissingDependency>
<Required type="26" schemaName="ASP C1 Contacts" displayName="ASP C1 Contacts" parentSchemaName="contact" parentDisplayName="Contact" solution="PowerPages_BookMeetingSalesRep_V2 (2.0.2402.1)" id="{2dee6b2a-2acb-4173-ab03-b0cc278b986a}">
<package>PowerPages_BookMeeting_V2 (3.0.2402.10)</package>
</Required>
<Dependent type="60" displayName="..." parentDisplayName="Account" id="..."/>
</MissingDependency>
 
...
 
<MissingDependency>
<Required type="26" schemaName="All Accounts" displayName="All Accounts" parentSchemaName="account" parentDisplayName="Account" solution="msdynce_AppCommon (9.0.4.0066)" id="{65ffaf9a-e8c5-432d-860b-32f841b00d87}">
<package>msdynce_AppCommonAnchor (9.0.24063.10001)</package>
</Required>
<Dependent type="60" displayName="..." parentDisplayName="Account" id="..."/>
</MissingDependency>
 
...
 
<MissingDependency>
<Required type="26" schemaName="All Accounts" displayName="All Accounts" parentSchemaName="account" parentDisplayName="Account" solution="msdynce_AppCommon (9.0.4.0066)" id="{65ffaf9a-e8c5-432d-860b-32f841b00d87}">
<package>msdynce_AppCommonAnchor (9.0.24063.10001)</package>
</Required>
<Dependent type="26" schemaName="All Accounts" displayName="All Accounts" parentSchemaName="account" parentDisplayName="Account" id="{65ffaf9a-e8c5-432d-860b-32f841b00d87}"/>
</MissingDependency>
 
...
 
<MissingDependency>
<Required type="26" schemaName="BAM C1 Specialties Profile Info" displayName="BAM C1 Specialties Profile Info" parentSchemaName="contact" parentDisplayName="Contact" solution="PowerPages_BookMeetingSalesRep_V2 (2.0.2402.1)" id="{79f4545c-ed38-ec11-8c64-000d3a8fd36d}">
<package>PowerPages_BookMeeting_V2 (3.0.2402.10)</package>
</Required>
<Dependent type="60" displayName="..." parentDisplayName="Account" id="..."/>
</MissingDependency>
 
...
 
<MissingDependency>
<Required type="61" schemaName="AppCommon/Account/Account_main_system_library.js" displayName="AppCommon/Account/Account_main_system_library.js" solution="msdynce_AppCommon (9.0.4.0066)">
<package>msdynce_AppCommonAnchor (9.0.24063.10001)</package>
</Required>
<Dependent type="60" displayName="..." parentDisplayName="Account" id="..."/>
</MissingDependency>
 
...
 
<MissingDependency>
<Required type="66" schemaName="MscrmControls.RichTextEditor.RichTextEditorControl" displayName="MscrmControls.RichTextEditor.RichTextEditorControl" solution="msdyn_RichTextEditor (1.0.0.3445)"/>
<Dependent type="60" displayName="..." parentDisplayName="Account" id="..."/>
</MissingDependency>
 
 
Are they connected to the error message I get and how can I add these to the solutions?
 
Thanks a lot in advance for your help!
Categories:
I have the same question (0)
  • Verified answer
    KR-24070732-0 Profile Picture
    on at

    Update: I solved this problem by adding "Virtual table data source" into the solution.

     

    "Add existing" --> "More" --> "Developer" --> "Virtual table data source"

    There are several data sources there and I wasn't sure which one(s) was/were needed so I added all of them except "Solution History Data Provider"


    The import was successful but I got this warning message "Solution "..." imported successfully with warnings: Data Source secrets are not included in solutions. You'll need to edit your data sources to add secrets back following solution import."

     

    Could anyone please tell me how I can do it? 🙂

     

    Still checking if I will run into any other problems.

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

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
11manish Profile Picture

11manish 50

#1
11manish Profile Picture

11manish 50

#3
Valantis Profile Picture

Valantis 26

Last 30 days Overall leaderboard