Skip to main content
Community site session details

Community site session details

Session Id : k0vPvfGlqeI9riCjkQUc1O
Power Pages - General Discussions
Answered

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

Like (1) ShareShare
ReportReport
Posted on 9 Jul 2024 00:04:50 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!
  • Verified answer
    KR-24070732-0 Profile Picture
    on 09 Jul 2024 at 06:59:11
    Re: Failed to migrate power pages using solution (Missing dependency lookup type = PrimaryKeyLookup)

    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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 2

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 2

#3
surya narayanan Profile Picture

surya narayanan 35