Error MISSING_EXPECTED_PROPERTY during migration to default publishing mode

minhhung0507
Valued Contributor

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:

  1. Paused the pipeline and ensured a recent update had run.

  2. remove the conf 'pipelines.enableDPMForExistingPipeline' and re-run an update using 'pipelines.setMigrationHints'

  3. 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.

Regards,
Hung Nguyen