Azure function app with SQL Trigger not working after deployment

Question

I have a azure function app created locally using Python Code, SQL Change Tracking that tracks any operation and triggers the SQL Trigger for further process.

app = func.FunctionApp()    
@app.function_name(name="SqlTrigger")
app.sql_trigger(arg_name="todo",table_name="TableABC", connection_string_setting="conn_string")

In local there is a local.setting.json file that contains the conn_string. Everything works fine in local development and testing. i.e I make a change in table, it is captured by function app and i can see the changes that is forwarded by another process.

Now, I successfully deploy it to Azure Function App from VS Code. Its not working and i don't find the connection_string . I tried the same process of making changes in azure sql table,but the function app doesn't react to the change. I have tried adding it manually on App Settings, Environment Variables but it didn't helped.

Answer 1

Hi @Sudeep Bala

Based on the information you provided, it seems like the issue is related to the connection string not being found in the Azure Function App after deployment.

One thing you can try is to check if the connection string is correctly set in the Azure Function App's Application Settings. You can do this by going to the Azure portal, navigating to your Function App, and then clicking on the "Configuration" tab.

From there, you can check if the connection string is set correctly. If the connection string is set correctly, you can try restarting the Function App to see if that helps.

You can do this by going to the "Overview" tab in the Azure portal, and then clicking on the "Restart" button.

If the issue still persists, you can try checking the logs of your Function App to see if there are any errors or exceptions being thrown.

You can do this by going to the "Logs" tab in the Azure portal, and then selecting the appropriate log stream.

If you are still unable to resolve the issue, please let me know and provide me with more details about the error messages or exceptions you are seeing in the logs.