Unanswered

Importing a Solution with Virtual Tables Fails

(0) Share

Report

Posted on by Tommy-Upton

119

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)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (24)

Answers (1)

Marcin_Roger 15 on at

Like (0)

Report

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

Was this reply helpful? Yes No
timlee 27 on at

Like (0)

Report

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

Was this reply helpful? Yes No
timlee 27 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Tommy-Upton 119 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Marcin_Roger 15 on at

Like (0)

Report

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-into-New-Environment/td-p/2306982

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.

Was this reply helpful? Yes No
timlee 27 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Tommy-Upton 119 on at

Like (0)

Report

How did you manually add the Virtual table data source?

Was this reply helpful? Yes No
timlee 27 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Tommy-Upton 119 on at

Like (0)

Report

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

Was this reply helpful? Yes No
timlee 27 on at

Like (0)

Report

did you get the same error? or did it reference something else is required? I had a connection reference once

Was this reply helpful? Yes No