Importing a Solution with Virtual Tables Fails

[Tommy-Upton]

I have a solution that I can't export/import to a new environment as long as it has virtual tables.  The error is below and I've checked normal stuff: I have admin privileges, no issue with the virtual tables in the source environment.

Solution contains a Canvas app, model driven app, flows, virtual tables and custom tables. If I remove all of the virtual tables, solution seems to import fine.  The only only commonality that I can see is that all of the virtual tables use the same virtual table data source (which makes sense as they all live on the same SQL server).

Solution "XXXXXXX" failed to import: Failed to create entity with logical name cr0d1_client_episode_visit_with_notes and object type code 11167. Exception: Microsoft.Crm.BusinessEntities.CrmObjectNotFoundException: Cannot add EntityDataSource with id (fe48cbbb-a046-ee11-be6d-000d3a3707cb) to solution (743888ae-6f0a-4ba3-bd20-8642ff6ea973) because it does not exist at Microsoft.Crm.ObjectModel.SolutionComponentService.VerifyComponentExists(IBusinessEntity entity, ExecutionContext context) at Microsoft.Crm.ObjectModel.SolutionComponentService.AddSolutionComponent(Guid componentId, Int32 componentType, Guid solutionId, Boolean addRequiredComponents, Boolean doNotIncludeSubcomponents, String[] includedComponentSettingsValues, ExecutionContext context) at Microsoft.Crm.ObjectModel.SolutionComponentService.AddSolutionComponent(Guid componentId, Int32 componentType, Guid solutionId, Boolean addRequiredComponents, ExecutionContext context) at Microsoft.Crm.MetadataService.VirtualEntity.VirtualConnectorProviderService.AddDatasourceAndConnectionReferenceToSolution(Guid entityDataSourceId, Guid solutionId, ExecutionContext executionContext) at Microsoft.Crm.MetadataService.VirtualEntity.VirtualConnectorProviderService.PostProcessVirtualTableSyncCore(IEntityInfo entityInfo, ExecutionContext executionContext) at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties) at Microsoft.Crm.MetadataService.VirtualEntity.VirtualConnectorProviderService.PostProcessVirtualTableSync(IEntityInfo entityInfo, ExecutionContext executionContext) at Microsoft.Crm.Metadata.EntityService.PostProcessVirtualConnectorProviderEntity(ExecutionContext context, EntityCreateInfo entityInfo, Boolean isInSolutionImportMode) at Microsoft.Crm.Metadata.EntityService.CreateInternalHelper(EntityCreateInfo entityInfo, MetadataHelper metadataHelper, Boolean shouldCreateOnlyFromReserve, ExecutionContext context)

[Marcin_Roger]

I do have exactly same issue. I'll you know once I have this resolved.  

[timlee]

Are resolution yet?

I have same error and I opened a ticket with MS. So far the only thing they asked about is dependencies. I noticed that the Virtual Table Data Source did not auto-add when I clicked the 'add required objects' button, so I added manually. Still no luck

[timlee]

I also get 'This app stopped working. Try refreshing you browser.' error when I try and play the canvas app. Even if I remove the virtual table, I get this error, not sure if it's related

[Tommy-Upton]

I noticed the same thing.  I have an open ticket with MS support but they haven't offered much input yet.  This is definitely related to virtual tables.  I've tried different solutions and environments along with different virtual tables and it all failed.  If you remove the virtual table, everything works fine.

[Marcin_Roger]

Some update on the error. In my case:

"Solution "ALM with Virtual Tables" failed to import: Failed to create entity with logical name vtrprs_child1 and object type code 10641. Exception: Microsoft.Crm.BusinessEntities.CrmObjectNotFoundException: Cannot add EntityDataSource with id (c157b234-908f-ee11-be36-000d3ada2b65) to solution (df615d26-b7d1-41f2-872e-b7468fdfa92e) because it does not exist at Microsoft.Crm.ObjectModel.SolutionComponentService...."

I have unpacked an unmanaged zip package and searched for  c157b234-908f-ee11-be36-000d3ada2b65 in customizations.xml file and discovered that this is a Virtual Table Data source 

<EntityDataSource EntityDataSourceId="{c157b234-908f-ee11-be36-000d3ada2b65}">
<Name>VCP_DS_f007204b-6510-4bd9-b68b-0544a3737de7</Name>

I've created a separate solution that contains only the above Virtual table Data Source and imported it to the new environment ahead of the other components (Canvas app, Virtual Tables etc.).

The import was successful with a worming message: 

"Solution "ALM with Virtual Tables-VirtualTableDataSourse" 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." 

This brought me to this publication; https://powerusers.microsoft.com/t5/Building-Power-Apps/Importing-a-Solution-with-a-Virtual-Table-in...

It appears that Exporting/Importing Virtual tables may not be possible with a manual exporting and importing packages, and we may need to setup Azure DevOps Pipeline to have Data Source secrets included.

I'll keep digging, and post an update if I'll find some more info. 

[timlee]

Found a fix!

Create another solution, and add just the Virtual Table Data Source and Connection Reference. Import that into the target environment. Once that complete, readd the main solution

[Tommy-Upton]

How did you manually add the Virtual table data source?

[timlee]

from 'add existing' option ... More > Developer > Virtual Table Data Source

[Tommy-Upton]

Dang.  Didn't work for me.  Same error.