Some stored procedures are missing in the DACPAC for Azure for the Marketing Automation database

  • Description

    In Sitecore XP 9.0.2, several of the new stored procedures are not present in the DACPAC for Azure for the Marketing Automation database.

  • After allowing client IP address in the Azure SQL firewall, connect to the Marketing Automation database using an SQL Server Management Studio and create the following stored procedures :

    • AutomationPool_Stall
    • ContactWorkerAffinity_ReleaseLease
    • ContactWorkerAffinity_TakeLease

    and the following table:

    • StalledAutomationPool

    by executing the UpdateMarketingAutomation.sql script.

Applies to:

CMS 9.0 Update-1 - 9.0 Update-2

June 28, 2018
July 11, 2018

Reference number:

225569