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

v-prakumar commented 1 year 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 and Debug the workflow.

Expected: The workflow should be failed after 2 minutes.

Actual: The workflow is succeeded after 2 minutes.

What type of Logic App Is this happening in?

Standard (VSCode)

Are you using Preview Designer or GA Designer

Preview

Workflow JSON

No response

Screenshots or Videos

No response

Browser

VS Code

Additional context

Vendor Testing

VS Code extension - vscode-azurelogicapps-2.15.10.vsix NuGet package: https://artprodeussu2.artifacts.visualstudio.com/A41bf5486-7392-4b7a-a7e3-a735c767e3b3/b32aa71e-8ed2-41b2-9d77-5bc261222004/_apis/artifact/cGlwZWxpbmVhcnRpZmFjdDovL21zYXp1cmUvcHJvamVjdElkL2IzMmFhNzFlLThlZDItNDFiMi05ZDc3LTViYzI2MTIyMjAwNC9idWlsZElkLzcyNDMyOTY3L2FydGlmYWN0TmFtZS9kcm9wX2J1aWxkX0J1aWxkQXJ0aWZhY3RzX1dpbmRvd3M1/content?format=file&subPath=%2FMicrosoft.Azure.Workflows.WebJobs.Extension.1.19.4.nupkg Extension Bundle (CDN URL): https://cdnforlogicappsv2.blob.core.windows.net/logicapps-vendortesting Extension Bundle (Direct Download): https://cdnforlogicappsv2.blob.core.windows.net/logicapps-vendortesting/ExtensionBundles/Microsoft.Azure.Functions.ExtensionBundle.Workflows/1.19.4/Microsoft.Azure.Functions.ExtensionBundle.Workflows.1.19.4_any-any.zip

AB#24182121

preetriti1 commented 1 year ago

@v-prakumar - Please share your workflow definition so we know what inputs or settings you have provided.

v-prakumar commented 1 year ago

@preetriti1 @ccastrotrejo VSIX(2.15.15) , Given workflow.json

Note: The issue may be intermittent sometime it is as per expected as Failed or sometimes it is passing in all 3 Artifacts.

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

v-prakumar commented 1 year ago

@ccastrotrejo Issue is same in the VSIX - 2.18.0, and also it is succeeded with this error.PFA.

preetriti1 commented 1 year ago

Looks like backend issue.

v-prakumar commented 1 year ago

@ccastrotrejo Issue is repro in VSIX : 2.24.3

v-prakumar commented 1 year ago

@ccastrotrejo Issue is repro in vsix 2.28.3

v-prakumar commented 11 months ago

@ccastrotrejo Issue is repro in the vsix 2.55.1

vgouth commented 10 months ago

Issue repro in the latest request.

1.VS Code extension - vscode-azurelogicapps-2.58.0.vsix 2.NuGet package: https://artprodeussu2.artifacts.visualstudio.com/A41bf5486-7392-4b7a-a7e3-a735c767e3b3/b32aa71e-8ed2-41b2-9d77-5bc261222004/_apis/artifact/cGlwZWxpbmVhcnRpZmFjdDovL21zYXp1cmUvcHJvamVjdElkL2IzMmFhNzFlLThlZDItNDFiMi05ZDc3LTViYzI2MTIyMjAwNC9idWlsZElkLzc4MzA5NDU2L2FydGlmYWN0TmFtZS9kcm9wX2J1aWxkX0J1aWxkQXJ0aWZhY3RzX1dpbmRvd3M1/content?format=file&subPath=%2FMicrosoft.Azure.Workflows.WebJobs.Extension.1.36.3.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.36.3/Microsoft.Azure.Functions.ExtensionBundle.Workflows.1.36.3_any-any.zip

vgouth commented 10 months ago

Issue repro in the latest VS code request

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-2", "operationId": "executeQuery", "serviceProviderId": "/serviceProviders/sql" } }, "runAfter": {} } }, "contentVersion": "1.0.0.0", "outputs": {}, "triggers": { "When_a_HTTP_request_is_received": { "type": "Request", "kind": "Http" } }, "parameters": {} }, "kind": "Stateful" }

vgouth commented 9 months ago

@ccastrotrejo , @AbodeSaafan

Issue not repro in the latest request but there is an error in the terminal. Is the error expected?

1. VS Code extension - vscode-azurelogicapps-2.69.0.vsix 2. NuGet package: https://artprodeussu2.artifacts.visualstudio.com/A41bf5486-7392-4b7a-a7e3-a735c767e3b3/b32aa71e-8ed2-41b2-9d77-5bc261222004/_apis/artifact/cGlwZWxpbmVhcnRpZmFjdDovL21zYXp1cmUvcHJvamVjdElkL2IzMmFhNzFlLThlZDItNDFiMi05ZDc3LTViYzI2MTIyMjAwNC9idWlsZElkLzgwMDY5MTEwL2FydGlmYWN0TmFtZS9kcm9wX2J1aWxkX0J1aWxkQXJ0aWZhY3RzX1dpbmRvd3M1/content?format=file&subPath=%2FMicrosoft.Azure.Workflows.WebJobs.Extension.1.41.1.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.41.1/Microsoft.Azure.Functions.ExtensionBundle.Workflows.1.41.1_any-any.zip</p

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" } }, "parameters": {} }, "kind": "Stateful" }

Error message in terminal:

[2023-09-26T05:54:47.636Z] Error message: correlationId='4a3772c3-478c-4b72-9eea-8bb718199a5d', operationName='sql.SqlServiceOperationsProvider.ExecuteQueryAsync', message='A severe error occurred on the current command. The results, if any, should be discarded. [2023-09-26T05:54:47.637Z] Operation cancelled by user.', exception='Microsoft.Data.SqlClient.SqlException (0x80131904): A severe error occurred on the current command. The results, if any, should be discarded. [2023-09-26T05:54:47.638Z] Operation cancelled by user. [2023-09-26T05:54:47.639Z] at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) [2023-09-26T05:54:47.641Z] at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) [2023-09-26T05:54:47.642Z] at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) [2023-09-26T05:54:47.642Z] at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) [2023-09-26T05:54:47.643Z] at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() [2023-09-26T05:54:47.644Z] at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() [2023-09-26T05:54:47.645Z] at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) [2023-09-26T05:54:47.646Z] at Microsoft.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption) [2023-09-26T05:54:47.646Z] at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, Boolean isInternal, String endMethod) [2023-09-26T05:54:47.647Z] at Microsoft.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) [2023-09-26T05:54:47.648Z] at Microsoft.Data.SqlClient.SqlCommand.EndExecuteReaderAsync(IAsyncResult asyncResult) [2023-09-26T05:54:47.649Z] at System.Threading.Tasks.TaskFactory1.FromAsyncCoreLogic(IAsyncResult iar, Func2 endFunction, Action1 endAction, Task1 promise, Boolean requiresSynchronization) [2023-09-26T05:54:47.650Z] --- End of stack trace from previous location --- [2023-09-26T05:54:47.651Z] at Microsoft.Azure.Workflows.ServiceProviders.Sql.Utilities.SqlExecutor.GetSqlDataReader(SqlCommand command, CommandBehavior commandBehavior, CancellationToken cancellationToken) [2023-09-26T05:54:47.653Z] at Microsoft.Azure.Workflows.ServiceProviders.Sql.Utilities.SqlExecutor.ExecuteQueryAndGetResult(SqlCommand command, CommandBehavior commandBehavior, CancellationToken cancellationToken, String callerName) [2023-09-26T05:54:47.655Z] at Microsoft.Azure.Workflows.ServiceProviders.Sql.Utilities.SqlExecutor.ExecuteQueryAsync(ConnectionProperties connectionProperties, IDictionary`2 queryParameters, String query, CommandBehavior commandBehavior) [2023-09-26T05:54:47.656Z] ClientConnectionId:445aa76a-45af-4d28-9ad4-6034624fdc32', organizationId='', activityVector='IN.03', additionalProperties='{"ParentActivityId":"00-e05703eeb881765332ffbeb7fc70e042-51ff31301fb24dc7-00"}', extensionVersion='1.41.1.0', siteName='UNDEFINED_SITE_NAME', slotName='', activityId='c27bf7be-1d70-4494-9616-37162f1f9a3e'.

vgouth commented 8 months ago

@ccastrotrejo , @AbodeSaafan

Issue not repro in the latest request but there is an error in the terminal. Is the error expected?

Similar error logs repro in SQL and nuget artifact

1.VS Code extension - vsix icon vscode-azurelogicapps-2.72.1.vsix

2.NuGet package: https://artprodeussu2.artifacts.visualstudio.com/A41bf5486-7392-4b7a-a7e3-a735c767e3b3/b32aa71e-8ed2-41b2-9d77-5bc261222004/_apis/artifact/cGlwZWxpbmVhcnRpZmFjdDovL21zYXp1cmUvcHJvamVjdElkL2IzMmFhNzFlLThlZDItNDFiMi05ZDc3LTViYzI2MTIyMjAwNC9idWlsZElkLzgxMTY0NTE3L2FydGlmYWN0TmFtZS9kcm9wX2J1aWxkX0J1aWxkQXJ0aWZhY3RzX1dpbmRvd3M1/content?format=file&subPath=%2FMicrosoft.Azure.Workflows.WebJobs.Extension.1.44.1.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.44.1/Microsoft.Azure.Functions.ExtensionBundle.Workflows.1.44.1_any-any.zip

Error message in terminal:

[2023-10-18T13:41:43.354Z] [2023-10-18T13:41:43.355Z] [2023-10-18T13:41:43.356Z] [2023-10-18T13:41:43.357Z] [2023-10-18T13:41:43.358Z] [2023-10-18T13:41:43.359Z] [2023-10-18T13:41:43.360Z] [2023-10-18T13:41:43.361Z] [2023-10-18T13:41:43.362Z] [2023-10-18T13:41:43.365Z] [2023-10-18T13:41:43.367Z] [2023-10-18T13:41:43.368Z] [2023-10-18T13:41:43.369Z] [2023-10-18T13:41:43.371Z] [2023-10-18T13:41:43.372Z] [2023-10-18T13:41:43.373Z] [2023-10-18T13:41:43.373Z] [2023-10-18T13:41:43.374Z] [2023-10-18T13:41:43.375Z] [2023-10-18T13:41:43.437Z] Error message: correlationId='ae091658-ad43-4f2f-b9fe-64931d26b338', operationName='sql.SqlServiceOperationsProvider.ExecuteQueryAsync', message='A severe error occurred on the current command. The results, if any, should be discarded. Operation cancelled by user.', exception='Microsoft.Data.SqlClient.SqlException (0x80131904): A severe error occurred on the current command. The results, if any, should be discarded. Operation cancelled by user. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) [2023-10-18T13:41:43.358Z] at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption) at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, Boolean isInternal, String endMethod) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteReaderAsync(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory1.FromAsyncCoreLogic(IAsyncResult iar, Func2 endFunction, Action1 endAction, Task1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Microsoft.Azure.Workflows.ServiceProviders.Sql.Utilities.SqlExecutor.GetSqlDataReader(SqlCommand command, CommandBehavior commandBehavior, CancellationToken cancellationToken) at Microsoft.Azure.Workflows.ServiceProviders.Sql.Utilities.SqlExecutor.ExecuteQueryAndGetResult(SqlCommand command, CommandBehavior commandBehavior, CancellationToken cancellationToken, String callerName) at Microsoft.Azure.Workflows.ServiceProviders.Sql.Utilities.SqlExecutor.ExecuteQueryAsync(ConnectionProperties connectionProperties, IDictionary`2 queryParameters, String query, CommandBehavior commandBehavior) ClientConnectionId:3a204b1d-2cf4-4511-817b-ac082dbec2fd', organizationId='', activityVector='IN.03', additionalProperties='{"ParentActivityId":"00-21c16d5a7735661095bb3ddd707d3f49-581b3b61829e3115-00"}', extensionVersion='1.44.1.0', siteName='UNDEFINED_SITE_NAME', slotName='', activityId='b154c40d-a808-45cf-97ed-906ce7b26c74'. Executed 'Functions.WorkflowDispatcher' (Succeeded, Id=131fff88-8bb6-404a-8a31-5fab02426731, Duration=120475ms)

Azure / logicapps