Error MISSING_EXPECTED_PROPERTY during migration to default publishing mode
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2025 09:35 PM - edited 08-04-2025 09:37 PM
We are in the process of migrating a pipeline from legacy publishing mode (LIVE virtual schema) to default publishing mode, following the steps outlined in the documentation:
Enable the default publishing mode in a pipeline (Public Preview)
However, when we perform the migration, we encounter the following error:
MISSING_EXPECTED_PROPERTY Pipeline with id <pipelineId> failed architecture migration due to missing property <propertyName> on table with id <tableId>. If you wish to proceed with the migration, remove the conf 'pipelines.enableDPMForExistingPipeline' and re-run an update using 'pipelines.setMigrationHints'. After running an update with 'pipelines.setMigrationHints', you can re-enable the conf 'pipelines.enableDPMForExistingPipeline'.
We followed the documented procedure carefully:
Paused the pipeline and ensured a recent update had run.
remove the conf 'pipelines.enableDPMForExistingPipeline' and re-run an update using 'pipelines.setMigrationHints'
- After running an update with 'pipelines.setMigrationHints', we re-enable the conf 'pipelines.enableDPMForExistingPipeline'
Despite this, the migration fails with the error above.
Our questions:
What exactly is the missing property that the error is referring to?
How can we fix it?
Any advice or troubleshooting steps would be greatly appreciated.
Hung Nguyen