Unable to Parse Schema

[jmarbutt]

I am receiving the following error on the latest version of

Microsoft.Azure.WebJobs.Extensions.Sql: Encountered error(s) while parsing schema and object name:
Incorrect syntax near ..

Here is one of my functions:

    [FunctionName("User_SqlTrigger")]
    public async Task Run(
        [SqlTrigger("[dbo].[User]",  "DefaultConnection")]
        IReadOnlyList<SqlChange<UserTriggerRow>> changes,
        ILogger logger)
    {
    
    // ..
    }

Here are my packages:

  <ItemGroup>
        <PackageReference Include="Azure.Extensions.AspNetCore.Configuration.Secrets" Version="1.2.2" />
        <PackageReference Include="Azure.Security.KeyVault.Secrets" Version="4.5.0" />
        <PackageReference Include="Microsoft.ApplicationInsights.WorkerService" Version="2.21.0" />
        <PackageReference Include="Microsoft.Azure.Functions.Extensions" Version="1.1.0" />
        <PackageReference Include="Microsoft.Azure.WebJobs.Extensions.Http" Version="3.2.0" />
        <PackageReference Include="Microsoft.Azure.WebJobs.Extensions.ServiceBus" Version="5.10.0" />

        <PackageReference Include="Microsoft.Azure.WebJobs.Extensions.Sql" Version="3.0.253-preview" />
        <PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="6.0.16" />
        <PackageReference Include="Microsoft.Extensions.Configuration.UserSecrets" Version="6.0.1" />
        <PackageReference Include="Microsoft.Extensions.Http" Version="6.0.0" />
        <PackageReference Include="Microsoft.NET.Sdk.Functions" Version="4.1.3" />
        <PackageReference Include="RestSharp" Version="109.0.1" />
    </ItemGroup>

[github-actions]

We need more info to debug your particular issue. If you could attach your logs to the issue, it would help us fix the issue much faster.

1. Set the default logging level to Debug and enable logging to a file. To do this ensure the following entries are in your host.json. (instructions)

{
  "logging": {
    "fileLoggingMode": "always",
    "logLevel": {
      "default": "Debug"
    }
  }
}

2. Restart your function and reproduce your issue

3. Get the log file and attach it to this issue. By default this will be in %TMP%/LogFiles/Application/Functions/Host.

NOTE Debug logging will include information such as Database and table names, if you do not wish to include this information you can either redact it from the logs before attaching or let us know and we will provide a way to send logs directly to us.

[MaddyDev]

@jmarbutt We released a new package with the fix (https://github.com/Azure/azure-functions-sql-extension/releases/tag/v3.0.323-preview).