Azure Sql Trigger could not found.

Question

Azure Sql Trigger could not found.

ghulam murtaza 0

Hello Microsoft community,

I'm working on an Azure Function project (version 4) within an ASP.NET Core 6 application, and I'm utilizing the Microsoft.Azure.WebJobs.Extensions.Sql package (v2.0.144) to manage Azure SQL triggers. Unfortunately, I've encountered an issue where the SQL trigger does not seem to be functioning as expected.

I have verified that I'm using version 2.0.144 of the Microsoft.Azure.WebJobs.Extensions.Sql package, and my Azure Function is set to version 4. Additionally, I have checked my configuration to ensure that the connection string ("AzureWebJobsSqlConnection") is correctly set, and there don't appear to be any issues there.

Despite all of this, the trigger doesn't seem to work, and I'm not receiving any error messages to help diagnose the problem. Is there anything specific to Azure Function v4 or this version of the Microsoft.Azure.WebJobs.Extensions.Sql package that I should be aware of? Are there any compatibility issues or known bugs that could be causing this behavior?

Thiago Custodio 196 Reputation points

2023-08-10T13:04:46.03+00:00

have you enabled change tracker in your database? Also, is it a SQL Server 2016 or higher?
ghulam murtaza 0 Reputation points

2023-08-11T04:26:41.47+00:00

Yes i run these following queries on database and table as well.

ALTER DATABASE [SampleDatabase] SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON);

ALTER TABLE [dbo].[ToDo] ENABLE CHANGE_TRACKING;

I am using sql server 2016 and visual studio 2022.
MayankBargali-MSFT 70,891 Reputation points

2023-08-21T06:30:38.0233333+00:00

Hi @ghulam murtaza

I hope the answer and comment helps. Feel free to get back to me if you need any assistance.

Please "Accept Answer" if the answer is helpful so that it can help others in the community.
MayankBargali-MSFT 70,891 Reputation points

2023-08-22T04:35:16.8+00:00

Hi @ghulam murtaza

I hope the answer helps. Feel free to "Accept Answer" if so that it can help others in the community.

1 answer

Your answer

Thiago Custodio 196 Reputation points

2023-08-10T13:04:46.03+00:00

have you enabled change tracker in your database? Also, is it a SQL Server 2016 or higher?
ghulam murtaza 0 Reputation points

2023-08-11T04:26:41.47+00:00

Yes i run these following queries on database and table as well.

ALTER DATABASE [SampleDatabase] SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON);

ALTER TABLE [dbo].[ToDo] ENABLE CHANGE_TRACKING;

I am using sql server 2016 and visual studio 2022.
MayankBargali-MSFT 70,891 Reputation points

2023-08-21T06:30:38.0233333+00:00

Hi @ghulam murtaza

I hope the answer and comment helps. Feel free to get back to me if you need any assistance.

Please "Accept Answer" if the answer is helpful so that it can help others in the community.
MayankBargali-MSFT 70,891 Reputation points

2023-08-22T04:35:16.8+00:00

Hi @ghulam murtaza

I hope the answer helps. Feel free to "Accept Answer" if so that it can help others in the community.

Answer 1

MayankBargali-MSFT 70,891

@ghulam murtaza Thanks for reaching out. As per your screenshot I can see the package was not found/installed properly or not supported as it is supported with .Net standard 2.0 or above version.

Please review the document here and readme for the Microsoft.Azure.WebJobs.Extensions.Sql package here. The sample can be found here. In case if you still observe the same behavior then please share the sample application so this can be reviewed further.

ghulam murtaza 0 Reputation points

2023-08-11T11:15:03.61+00:00

Thank you the issue is resolved. I have one more question can you tell me its possible to connect live azure function with local sql database? if possible any reference article thats can help. I am using azure consumption plan.

Thank you.
MayankBargali-MSFT 70,891 Reputation points

2023-08-11T11:59:40.14+00:00

@ghulam murtaza Thanks for your response and glad that you were able to resolve the issue. Please refer to the discussion here for your second query.

Feel free to "Accept Answer" so that it can help others in the community.

Share via

Azure Sql Trigger could not found.

1 answer

Your answer