Procedure not found auto_audience_segmentation_dataset_preparation when invoking stored procedures

[julianandersennoa]

During last step of post-deployment, when I run:
CALL 'auto_audience_segmentation.invoke_auto_audience_segmentation_training_preparation'();

I receive the following error:
Procedure is not found: .auto_audience_segmentation.auto_audience_segmentation_dataset_preparation at [.auto_audience_segmentation.auto_audience_segmentation_training_preparation:41:6].

auto_audience_segmentation_training_preparation seems to try to run a procedure which does not exist. We also cannot find any reference to this in the procedures under the 'scripts'-folder.

Is there a way for us to create this procedure manually? This is the only procedure which fails in this step.

[chmstimoteo]

Hi @julianandersennoa thanks for reaching out.

It seems to be you're missing the project_id in one of your configurations.

On your deployment environment, using your favourite Code Editor, find the sql/query/ folder.
Next, open the following generated file invoke_auto_audience_segmentation_training_preparation.sql.

You should have your project id in line 38, like in this example:

[julianandersennoa]

Hi there.
That's not the case, I just removed it before posting this issue to keep the project ID discrete. :)

[blimmox]

I am currently facing this issue as well.

Line 41 in auto_audience_segmentation_training_preperation.sqlx found in the sql/procedure/ folder attempts to call
{{project_id}}.{{dataset}}.auto_audience_segmentation_dataset_preparation, but I cannot find any procedure with that name.

Does this mean that a step has failed somewhere in the process?