Vs Code SQL based_Parameterization_Debug Issue.

v-prakumar commented 1 year ago

Describe the Bug with repro steps

1.Create a project and add stateful workflow in vs code. 2.Add http trigger after opening the designer. 3.Add Azure function, Office_Send an email, Service Bus actions. 4.Add parameters.json file and replace the connection values. Follow the instructions given in parameterization test case. 5.Save it and Debug it.

Expected: Debug should be fine.

Actual: Debug is failing.

What type of Logic App Is this happening in?

Standard (VSCode)

Are you using new designer or old designer

New Designer

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

No

Workflow JSON



### Screenshots or Videos

_No response_

### Browser

VS Code

## Additional context

VS Code: [vscode-azurelogicapps-2.55.1.vsix](https://microsoft.sharepoint.com/:u:/t/LogicApps/EcOCJqfpIctBowgwybn5N2IB_Xzx3ekjXLlHGJHJm_yrAA?e=u0WeSb&xsdata=MDV8MDF8di1wcmFrdW1hckBtaWNyb3NvZnQuY29tfGFjMjUyYTA4MDgzZTRkN2U4MWI4MDhkYjkyNmNhMzVkfDcyZjk4OGJmODZmMTQxYWY5MWFiMmQ3Y2QwMTFkYjQ3fDF8MHw2MzgyNjQ3Njc1OTkwNjk3NDV8VW5rbm93bnxUV0ZwYkdac2IzZDhleUpXSWpvaU1DNHdMakF3TURBaUxDSlFJam9pVjJsdU16SWlMQ0pCVGlJNklrMWhhV3dpTENKWFZDSTZNbjA9fDMwMDB8fHw%3d&sdata=WGRGQ1hVVHVQZXFDVHZ6RnAwMDI3SDJIUWZRV0ZTMHI2Skw2aERjdGthOD0%3d)

2. NuGet package: https://artprodeussu2.artifacts.visualstudio.com/A41bf5486-7392-4b7a-a7e3-a735c767e3b3/b32aa71e-8ed2-41b2-9d77-5bc261222004/_apis/artifact/cGlwZWxpbmVhcnRpZmFjdDovL21zYXp1cmUvcHJvamVjdElkL2IzMmFhNzFlLThlZDItNDFiMi05ZDc3LTViYzI2MTIyMjAwNC9idWlsZElkLzc3MzU3NDkxL2FydGlmYWN0TmFtZS9kcm9wX2J1aWxkX0J1aWxkQXJ0aWZhY3RzX1dpbmRvd3M1/content?format=file&subPath=%2FMicrosoft.Azure.Workflows.WebJobs.Extension.1.33.6.nupkg

3. Extension Bundle (CDN URL): https://cdnforlogicappsv2.blob.core.windows.net/logicapps-vendortesting

4. Extension Bundle (Direct Download): https://cdnforlogicappsv2.blob.core.windows.net/logicapps-vendortesting/ExtensionBundles/Microsoft.Azure.Functions.ExtensionBundle.Workflows/1.33.6/Microsoft.Azure.Functions.ExtensionBundle.Workflows.1.33.6_any-any.zip

AB#24721158

nidhi-pathak commented 1 year ago

This is result of contract update to subscription definition and the fact we dont support schema upgrades in sql storage provider.

To mitigate this bug, please drop all tables in target sql instance and retest the scenario.

Synced with kent offline on how to handle this break in public preview sql storage based logicapps.

v-prakumar commented 1 year ago

@nidhi-pathak I tried the test case again in the SQL Based, now it is working fine with the same steps as in the test case. It may be some glitch in the connection string. If it will occur again we will connect with you. Closing the bug.

Azure / LogicAppsUX