Deployment of dab.config file with stored procedure fails

[ax365]

I've defined a very standard stored procedure in an Azure SQL database that returns back [3] values [nvarchar, bigint, nvarchar].

Running SELECT * FROM sys.dm_exec_describe_first_result_set('sp_name', null, 0) --> returns back valid results.
https://learn.microsoft.com/en-us/azure/data-api-builder/database-objects#limitations

I've defined this stored procedure inside the dab.config.

"entities": {
    "my_stored_procedure_api": {
      "source": {
        "object": "dbo.StoredProcedureName",
        "type": "stored-procedure"
      },
      "rest": {
        "enabled": true,
        "methods": [
          "get"
        ]
      },
      "permissions": [
        {
          "role": "anonymous",
          "actions": [
            {
              "action": "execute"
            }
          ]
        }
      ]
    }
  }

---

Meanwhile, I get this error when viewing from the WebApp deployment center logs.

Unable to complete runtime initialization. Refer to exception for error details.
2025-03-14T19:52:50.795260610Z Azure.DataApiBuilder.Service.Exceptions.DataApiBuilderException: No stored procedure definition found for the given database object <stored procedure name here>. 

If I reference just database tables in my dab.config, that same deployment process succeeds just fine.

For some reason there is some issue with the stored procedure.

[ax365]

This same dab.config, when deployed locally, is able to identify the stored procedure and successfully enable the API.

Why would the deployment of the webapp error out though? Why can't it identify the stored procedure?

Could this have anything to do with database roles on the user-defined-managed identity?

[ax365]

I've managed to resolve this.

DAB has now successfully created an API for my stored procedure.

---

Two things are important:

• Execute permission for user-defined-managed-identity --> GRANT EXECUTE to [your_user_defined_managed_identity]
• Make sure you have the Allow Azure services and resources access to this server enabled on the database server