This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 27%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBT%3C/text%3E%3C/svg%3E)
Hi,
I have an Azure Function based on a blob trigger.
Simple C# application converting an Excel file to a CSV one. Pushes back to the same storage account.
Seemed to be working fine for a while, but not it doesn't seem to run automatically. I have to go on the portal itself to see it kick in.
I've noticed that there seems to be a lot discussions around this on the Web, but I couldn't find any fix.
I'm requesting some help get it back to working automatically.
Thank you,
Benoit Thiboutot
@Benoit Thiboutot When you have mentioned that "it is working fine for a while" so does it mean that your function was getting executed for some of the blobs that are uploaded but the after some time you see that when the blobs are uploaded the function are not triggered. In that case have you looked into your application insights logs and see any exception/error during the time when you observed that the function was not triggered. Can you share more details in my private comment.
List<string> items = new List<string>();
for (int i = 0; i < result.Tables.Count; i++)
items.Add(result.Tables[i].TableName.ToString());
string csv;
log.LogInformation("START CONVERTTOCSV");
if (result.Tables[0].Rows[0][1].ToString() == "")
csv = convertToCSV(result, workSheetIndex, 3);
else
csv = convertToCSV(result, workSheetIndex, 0);
log.LogInformation("END CONVERTTOCSV");
var config = new ConfigurationBuilder()
.SetBasePath(context.FunctionAppDirectory)
.AddJsonFile("local.settings.json", optional: true, reloadOnChange: true)
.AddEnvironmentVariables()
.Build();
string blobConnString = config["AzureTriggerStorage"];
string containerName = config["BlobContainer"];
string zone = config["BlobZone"];
string subject = config["BlobSubject"];
BlobServiceClient blobServiceClient = new BlobServiceClient(blobConnString);
BlobContainerClient containerClient = blobServiceClient.GetBlobContainerClient($"{containerName}");
BlobClient blobClient = containerClient.GetBlobClient($"{zone}/{subject}/csv/{(isXlsx == true ? name.Replace(".xlsx", "") : name.Replace(".xls", ""))}.csv");
Hi Mayank,
I've shared more information in your private comment.
This function app was set up by a third party. I'm monitoring them right now, but I still don't have a full knowledge about how all of this works.
How would I know if they used Application Insights?
I do know that when I turn up on the portal, it then fires and works correctly.
I know I contacted the third party some time earlier in September, and this may be the cause, but he did publish a new version of the code fixing another problem we had.
Thank you,
Benoit Thiboutot
So I figured out the part about the Application Insights, at least partially for now ;p
I do not have any failures. I do have Traces telling me the listeners and JobHost are stopping.
Not sure why that is. I did check the Function App and it seems to be set to "Always On" = false. But the App Service plan looks to be set to a Dynamic tier.
Thank you,
Benoit Thiboutot
@Benoit Thiboutot Apology for the delay as I couldn't get notify. It looks like the trigger sync issue. Can you please confirm the exact date and timeframe (in UTC) for the recent occurrence so I can check the logs.
Hi Mayank,
I have another occurence right now.
File was sent to the container yesterday at 18h24 EST.
File has still not been transformed from an Excel into a CSV.
I will hold off on going to the Azure Function in the portal as I know it will trigger it.
Let me know how else I can help in resolving this issue.
Thank you,
Benoit Thiboutot
@Benoit Thiboutot I couldn't see any blob created event for the mentioned timeframe. Please refer to my private comment so you can create the support ticket.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 42%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
Hi @MayankBargali-MSFT were you able to resolve this issue. I am facing the same problem with a blobtrigger that originally automatically picked up a file but now only works if I manually call the trigger from the azure portal. I have other triggers on the same function app that work fine.
Hi David,
Found the issue after quite some time with Functions and Storage Account teams.
For some reason, logs were not being created anymore for some time and then they just restarted by themselves.
I suspect an update on the Azure part was responsible for the issue both times (stopping and restarting them), but we never got to it.
Look into "Diagnostic Settings (classic)" and turn on logs if they have been turned off.
Thank you,
Benoit Thiboutot
Thanks for the reply. I eventually found the I figured out there is was a bug in the earlier version of Nuget package Microsoft.Azure.Webjobs.Extensions.Storage. I upgraded the version and it solved my issue. I think there was a bug in version 3.0.8 and I upgraded to 5.0 and it was resolved.
Thanks again
David