SQL connector, "When a row is inserted" does not trigger on row insertion.

[VictorVenetian]

Describe the Bug with repro steps

1. Stateful workflow with "When a row is inserted" SQL connector and using a connection string to the Azure DB, does not trigger when a row is inserted into the table defined in the connector.
2. If I manually press the Run button, it will trigger but the output body is empty. Zero content length.
3. No errors indicating the condition.
4. And yes, SQL change tracking is enabled on the DB and the table.

What type of Logic App Is this happening in?

Standard (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": {
            "Compose": {
                "inputs": "@triggerBody()",
                "runAfter": {},
                "type": "Compose"
            }
        },
        "contentVersion": "1.0.0.0",
        "outputs": {},
        "triggers": {
            "When_a_row_is_inserted": {
                "inputs": {
                    "parameters": {
                        "tableName": "Test_LogicApp"
                    },
                    "serviceProviderConfiguration": {
                        "connectionName": "sql-8",
                        "operationId": "whenARowIsInserted",
                        "serviceProviderId": "/serviceProviders/sql"
                    }
                },
                "type": "ServiceProvider"
            }
        }
    },
    "kind": "Stateful"
}

Screenshots or Videos

Browser

Latest Edge browser.

Additional context

No response

AB#25044319

AB#25064540

[github-actions]

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

[VictorVenetian]

Abandoned this connector since it has restrictions on the table like an Identity column that is also a PK. This is why it does not trigger. This is not the case in my database. Refactored workflow to use a recurrence connector to periodically query a secondary storage table populated from a standard SQL trigger whenever there are inserts in the target table. Once processed in the logic app workflow, I delete the rows from the secondary storage table. This works fine.

[github-actions]

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

[github-actions]

This issue was closed because it has been inactive for 14 days since being marked as stale.