SQL Based_SQL Action: Before adding long running scenario query, the workflow is succeeded.

[vgouth]

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"
}

Screenshots or Videos

Browser

VS Code

Additional context

VS Code extension - 4.71.5

[AzureDev0012]

@ccastrotrejo
I am facing the issue in portal, not only in Vs Code.
I have added bug for the same.

##1167

[vgouth]

Issue repro in the latest VS code request

VSIX Version: 4.85.2

[vgouth]

Issue repro in the latest VS code request. Getting success with error log.

VSIX Version: 4.96.0

[vgouth]

Issue repro in the latest VS code request. Getting success run.

VSIX Version: 4.107.0