When creating a Timer Trigger function from the portal i receive Value cannot be null. (Parameter 'connectionString') error

Oli Goldsmith 1 Reputation point
2020-11-09T15:53:46.107+00:00

When following the basic steps of creating a timer Trigger function within the Azure portal, i receive the error

Value cannot be null. (Parameter 'connectionString')

in the logs window within the Code + Test tab. I have no connection string set in my app settings nor do I currently need one, so im unsure of why I receive this error?

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,932 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Malcolm Young 11 Reputation points
    2020-11-11T10:12:01.307+00:00

    This also happens for me when I'm following https://learn.microsoft.com/en-us/azure/azure-functions/functions-create-scheduled-function

    The same error happens with a .NET and NodeJS function.

    Possibly related, although I couldn't see any way to follow the suggestions in that post?

    I also found this post on Stack Overflow, but I couldn't fix things following the advice there.

    1 person found this answer helpful.
    0 comments No comments

  2. NP 1 Reputation point
    2020-11-11T12:00:15.19+00:00

    i m getting the same error when i am running powershell from Azure Timer function

    0 comments No comments

  3. Anonymous
    2020-12-22T00:22:56.6+00:00

    I'm getting same error with .net Core Trigger function

    0 comments No comments

  4. Ewa Sierocka 1 Reputation point
    2021-01-25T08:41:56.817+00:00

    For me the problem was solved by adding an Application setting (app config): name: "AzureWebJobsStorage", value: string specified in keys to the storage you want to use for your function app (connectionString). You can add this parameter in Settings/Configuration for function app in the portal.
    Also, the connection for TimeTrigger in function.json was defined as: "connection": "AzureWebJobsStorage"
    If you have this paramater AzureWebJobsStorage defined before you add a new function it will be suggested as connection in the function creation form. It did not work with some other string than "AzureWebJobsStorage" even if it was also defined in application settings in the same way. Don't ask me why...

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.