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

[davidkr]

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!

[davidkr]

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.