vgouth commented 3 months ago

Describe the Bug with repro steps

1.Create a project and add Stateful workflow in VS code.

2.Convert your workflow in SQL Based.

3.Open Designer and add http trigger and sql_Execute query_EXEC wait2;

4.Save, Debug the workflow and run the workflow.

Expected: The workflow should be failed after 2 minutes.

Actual: The workflow is succeeded after 2 minutes and some runs are in running state(when opened the monitoring view shows failed after 10+ minutes).

What type of Logic App Is this happening in?

Standard (VSCode)

Which operating system are you using?

Windows

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": {
            "Execute_query": {
                "type": "ServiceProvider",
                "inputs": {
                    "parameters": {
                        "query": "EXEC wait2;"
                    },
                    "serviceProviderConfiguration": {
                        "connectionName": "sql",
                        "operationId": "executeQuery",
                        "serviceProviderId": "/serviceProviders/sql"
                    }
                },
                "runAfter": {}
            }
        },
        "contentVersion": "1.0.0.0",
        "outputs": {},
        "triggers": {
            "When_a_HTTP_request_is_received": {
                "type": "Request",
                "kind": "Http"
            }
        }
    },
    "kind": "Stateful"
}