Error with Pipeline Upgrade

[Tom Butkevich]

Hello Team,

I am receiving an error when upgrading a pipeline from V5 to current version for two Brand propensity models.  The error I receive is this referring to a registered vertex ai model which I haven't used.

Job: Product Propensity Training, Worker Class: BQScriptExecutor
Execution failed: WorkerException: This model was registered to Vertex AI before. Please ensure model_registry is set to 'vertex_ai' should you want to continue to register to Vertex AI. Otherwise please DROP MODEL to deregister first and then recreate.

Can you help with the upgrade process for these propensity models?

Thanks, Tom

[Instant BQML and Vertex Users]

Hi Tom,

Thanks for reaching out. I understand that you're getting an error when training your model after upgrading your pipelines from V5. This is happening because your newer pipelines no longer register the model with Vertex AI in the BigQuery ML configuration and if you don't explicitly register the model in the BigQuery ML configuration the BigQuery API has this exception.

Not to worry! What you need to do now is delete your current model in BigQuery before retraining.

To do so:

1. Go to BigQuery and locate the dataset containing your Brand propensity models.
2. Find the model that's causing the error.
3. Click the three vertical dots next to the model name.
4. Select "Delete" to remove the model.

After you've completed these steps, please retry training and it should work.

Let me know if you have any other questions!

[Tom Butkevich]

Thanks, that solved the issue.