Azure / logicapps

Azure Logic Apps labs, samples, and tools
MIT License
357 stars 299 forks source link

Azure logic app stops working sometimes even without justified reason. #1107

Open Jainam3eco opened 1 month ago

Jainam3eco commented 1 month ago

Describe the Bug with repro steps

  1. Create a Logic app
  2. Add more then two azure function sequenced one after another without any middle condition.
  3. First function's Success body used in another function's input body.
  4. Even though first function completed without any error and also with valid body.
  5. Second function skipped/Terminated .!!

Also I don't have nay information why it skipped, because there is no such conditions which are failing.

What type of Logic App Is this happening in?

Consumption (Portal)

Are you using new designer or old designer

New Designer

Did you refer to the TSG before filing this issue? https://aka.ms/lauxtsg

Yes

Workflow JSON

{
    "definition": {
        "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
        "actions": {
            "[Weekly_Newsletter_Flow]_Is_Today_Wednesday": {
                "actions": {
                    "Do_we_have_any_weekly_articles_to_process": {
                        "actions": {
                            "Do_we_have_any_weekly_subscription_to_process": {
                                "actions": {
                                    "Do_we_have_any_weekly_email_data_to_send": {
                                        "actions": {
                                            "[weekly]_dev-3enewslet-sendemailsendgrid-SendEmailTemplate": {
                                                "inputs": {
                                                    "body": "@body('[weekly]_dev-3enewslet-prepareemaildata-PrepareEmailNewsletter')",
                                                    "function": {
                                                        "id": "/subscriptions/18d89cc4-f5ae-4fbc-bd7e-262dbf7b8233/resourceGroups/dev-3enews-email-newsletter-distr-westus2-rg/providers/Microsoft.Web/sites/dev-3enewslet-sendemailsendgrid/functions/SendEmailTemplate"
                                                    },
                                                    "method": "POST",
                                                    "queries": {
                                                        "recepientEmailAddress": "@parameters('RecepientEmailAddress')"
                                                    }
                                                },
                                                "type": "Function"
                                            }
                                        },
                                        "else": {
                                            "actions": {
                                                "No_email_data_found_to_process_-_Terminated!": {
                                                    "inputs": {
                                                        "runStatus": "Cancelled"
                                                    },
                                                    "type": "Terminate"
                                                }
                                            }
                                        },
                                        "expression": {
                                            "and": [
                                                {
                                                    "equals": [
                                                        "@outputs('[weekly]_dev-3enewslet-prepareemaildata-PrepareEmailNewsletter')?['statusCode']",
                                                        200
                                                    ]
                                                }
                                            ]
                                        },
                                        "runAfter": {
                                            "[weekly]_dev-3enewslet-prepareemaildata-PrepareEmailNewsletter": [
                                                "Succeeded"
                                            ]
                                        },
                                        "type": "If"
                                    },
                                    "[weekly]_dev-3enewslet-prepareemaildata-PrepareEmailNewsletter": {
                                        "inputs": {
                                            "body": "@body('[weekly]_dev-3enewslet-getsubsnewsletter-NewsLetterSubscription')",
                                            "function": {
                                                "id": "/subscriptions/18d89cc4-f5ae-4fbc-bd7e-262dbf7b8233/resourceGroups/dev-3enews-email-newsletter-distr-westus2-rg/providers/Microsoft.Web/sites/dev-3enewslet-prepareemaildata/functions/PrepareEmailNewsletter"
                                            },
                                            "method": "POST"
                                        },
                                        "type": "Function"
                                    }
                                },
                                "else": {
                                    "actions": {
                                        "No_subscription_found_to_process_-_Terminated!": {
                                            "inputs": {
                                                "runStatus": "Cancelled"
                                            },
                                            "type": "Terminate"
                                        }
                                    }
                                },
                                "expression": {
                                    "and": [
                                        {
                                            "greater": [
                                                "@length(body('[weekly]_dev-3enewslet-getsubsnewsletter-NewsLetterSubscription'))",
                                                0
                                            ]
                                        }
                                    ]
                                },
                                "runAfter": {
                                    "[weekly]_dev-3enewslet-getsubsnewsletter-NewsLetterSubscription": [
                                        "Succeeded"
                                    ]
                                },
                                "type": "If"
                            },
                            "[weekly]_dev-3enewslet-getsubsnewsletter-NewsLetterSubscription": {
                                "inputs": {
                                    "body": "@body('[weekly]_dev-3enewslet-getarticles-QueryNewsletterArticles')",
                                    "function": {
                                        "id": "/subscriptions/18d89cc4-f5ae-4fbc-bd7e-262dbf7b8233/resourceGroups/dev-3enews-email-newsletter-distr-westus2-rg/providers/Microsoft.Web/sites/dev-3enewslet-getsubsnewsletter/functions/NewsLetterSubscription"
                                    },
                                    "method": "POST",
                                    "queries": {
                                        "pageNumber": "@parameters('PageNumber')",
                                        "pageSize": "@parameters('PageSize')",
                                        "weeklySubscriptionDay": "@parameters('WeeklySubscriptionDay')"
                                    }
                                },
                                "type": "Function"
                            }
                        },
                        "else": {
                            "actions": {
                                "No_article_found_to_process_-_Terminated!": {
                                    "inputs": {
                                        "runStatus": "Cancelled"
                                    },
                                    "type": "Terminate"
                                }
                            }
                        },
                        "expression": {
                            "and": [
                                {
                                    "greater": [
                                        "@length(body('[weekly]_dev-3enewslet-getarticles-QueryNewsletterArticles'))",
                                        0
                                    ]
                                }
                            ]
                        },
                        "runAfter": {
                            "[weekly]_dev-3enewslet-getarticles-QueryNewsletterArticles": [
                                "Succeeded"
                            ]
                        },
                        "type": "If"
                    },
                    "[weekly]_dev-3enewslet-getarticles-QueryNewsletterArticles": {
                        "inputs": {
                            "body": {
                                "pageNumber": "@parameters('PageNumber')",
                                "pageSize": "@parameters('PageSize')",
                                "weeklyDispatchHour": "@parameters('WeeklyDispatchHour')",
                                "weeklyStartDate": "@formatDateTime(utcNow(), 'yyyy-MM-dd')",
                                "weeklySubscriptionDay": "@parameters('WeeklySubscriptionDay')"
                            },
                            "function": {
                                "id": "/subscriptions/18d89cc4-f5ae-4fbc-bd7e-262dbf7b8233/resourceGroups/dev-3enews-email-newsletter-distr-westus2-rg/providers/Microsoft.Web/sites/dev-3enewslet-getarticles/functions/QueryNewsletterArticles"
                            },
                            "method": "POST",
                            "queries": {
                                "pageNumber": "@parameters('PageNumber')",
                                "pageSize": "@parameters('PageSize')",
                                "weeklyDispatchHour": "@parameters('WeeklyDispatchHour')",
                                "weeklyStartDate": "@formatDateTime(utcNow(), 'yyyy-MM-dd')",
                                "weeklySubscriptionDay": "@parameters('WeeklySubscriptionDay')"
                            }
                        },
                        "type": "Function"
                    }
                },
                "else": {
                    "actions": {
                        "Not_a_matching_weekly_day_-_Terminated!": {
                            "inputs": {
                                "runStatus": "Cancelled"
                            },
                            "type": "Terminate"
                        }
                    }
                },
                "expression": {
                    "and": [
                        {
                            "equals": [
                                "@dayOfWeek(convertTimeZone(utcNow(), 'UTC', 'Eastern Standard Time'))",
                                "@parameters('WeeklySubscriptionDayNum')"
                            ]
                        }
                    ]
                },
                "runAfter": {},
                "type": "If"
            },
            "dev-3enewslet-getarticles-QueryNewsletterArticles": {
                "inputs": {
                    "body": {
                        "dailyDispatchHour": "@parameters('DailyDispatchHour')",
                        "dailyStartDate": "@formatDateTime(utcNow(), 'yyyy-MM-dd')",
                        "pageNumber": "@parameters('PageNumber')",
                        "pageSize": "@parameters('PageSize')"
                    },
                    "function": {
                        "id": "/subscriptions/18d89cc4-f5ae-4fbc-bd7e-262dbf7b8233/resourceGroups/dev-3enews-email-newsletter-distr-westus2-rg/providers/Microsoft.Web/sites/dev-3enewslet-getarticles/functions/QueryNewsletterArticles"
                    },
                    "method": "POST",
                    "queries": {
                        "dailyDispatchHour": "@parameters('DailyDispatchHour')",
                        "dailyStartDate": "@formatDateTime(utcNow(), 'yyyy-MM-dd')",
                        "pageNumber": "@parameters('PageNumber')",
                        "pageSize": "@parameters('PageSize')"
                    }
                },
                "runAfter": {},
                "type": "Function"
            },
            "dev-3enewslet-getsubsnewsletter-NewsLetterSubscription": {
                "inputs": {
                    "body": "@body('dev-3enewslet-getarticles-QueryNewsletterArticles')",
                    "function": {
                        "id": "/subscriptions/18d89cc4-f5ae-4fbc-bd7e-262dbf7b8233/resourceGroups/dev-3enews-email-newsletter-distr-westus2-rg/providers/Microsoft.Web/sites/dev-3enewslet-getsubsnewsletter/functions/NewsLetterSubscription"
                    },
                    "method": "POST",
                    "queries": {
                        "pageNumber": "@parameters('PageNumber')",
                        "pageSize": "@parameters('PageSize')"
                    }
                },
                "runAfter": {
                    "dev-3enewslet-getarticles-QueryNewsletterArticles": [
                        "Succeeded"
                    ]
                },
                "type": "Function"
            },
            "dev-3enewslet-prepareemaildata-PrepareEmailNewsletter": {
                "inputs": {
                    "body": "@body('dev-3enewslet-getsubsnewsletter-NewsLetterSubscription')",
                    "function": {
                        "id": "/subscriptions/18d89cc4-f5ae-4fbc-bd7e-262dbf7b8233/resourceGroups/dev-3enews-email-newsletter-distr-westus2-rg/providers/Microsoft.Web/sites/dev-3enewslet-prepareemaildata/functions/PrepareEmailNewsletter"
                    },
                    "method": "POST"
                },
                "runAfter": {
                    "dev-3enewslet-getsubsnewsletter-NewsLetterSubscription": [
                        "Succeeded"
                    ]
                },
                "type": "Function"
            },
            "dev-3enewslet-sendemailsendgrid-SendEmailTemplate": {
                "inputs": {
                    "body": "@body('dev-3enewslet-prepareemaildata-PrepareEmailNewsletter')",
                    "function": {
                        "id": "/subscriptions/18d89cc4-f5ae-4fbc-bd7e-262dbf7b8233/resourceGroups/dev-3enews-email-newsletter-distr-westus2-rg/providers/Microsoft.Web/sites/dev-3enewslet-sendemailsendgrid/functions/SendEmailTemplate"
                    },
                    "method": "POST",
                    "queries": {
                        "recepientEmailAddress": "@parameters('RecepientEmailAddress')"
                    }
                },
                "runAfter": {
                    "dev-3enewslet-prepareemaildata-PrepareEmailNewsletter": [
                        "Succeeded"
                    ]
                },
                "type": "Function"
            }
        },
        "contentVersion": "1.0.0.0",
        "outputs": {},
        "parameters": {
            "$connections": {
                "defaultValue": {},
                "type": "Object"
            },
            "DailyDispatchHour": {
                "defaultValue": 9,
                "type": "Int"
            },
            "PageNumber": {
                "defaultValue": 1,
                "type": "Int"
            },
            "PageSize": {
                "defaultValue": 500,
                "type": "Int"
            },
            "RecepientEmailAddress": {
                "defaultValue": "jainam.shah@3eco.com",
                "type": "String"
            },
            "WeeklyDispatchHour": {
                "defaultValue": 7,
                "type": "Int"
            },
            "WeeklySubscriptionDay": {
                "defaultValue": "thursday",
                "type": "String"
            },
            "WeeklySubscriptionDayNum": {
                "defaultValue": 4,
                "type": "Int"
            }
        },
        "triggers": {
            "Recurrence": {
                "evaluatedRecurrence": {
                    "frequency": "Day",
                    "interval": 1,
                    "schedule": {
                        "hours": [
                            "1"
                        ],
                        "minutes": [
                            5
                        ]
                    },
                    "timeZone": "Eastern Standard Time"
                },
                "recurrence": {
                    "frequency": "Day",
                    "interval": 1,
                    "schedule": {
                        "hours": [
                            "1"
                        ],
                        "minutes": [
                            5
                        ]
                    },
                    "timeZone": "Eastern Standard Time"
                },
                "type": "Recurrence"
            }
        }
    },
    "parameters": {
        "$connections": {
            "value": {}
        }
    }
}

Screenshots or Videos

https://github.com/Azure/LogicAppsUX/assets/141911463/97303836-faca-4953-80a7-33f75bcfa2c7

Browser

Google Chrome

Version 126.0.6478.127 (Official Build) (64-bit)

Additional context

My Azure Logic app has many Azure function sequenced one after another. My first Azure Function's body is used in second azure function. Problem is first function returns 200 status with valid body, Still second azure function is Skipped / Terminated. I want any reason or insights why it gets terminated.!

I am a developer in my organization.!!

-Jainam

jainam.shah@3eco.com

Eric-B-Wu commented 1 month ago

Moving issue to backend to address runtime issue

github-actions[bot] commented 3 days ago

This issue is stale because it has been open for 45 days with no activity.