LogicAppsUX icon indicating copy to clipboard operation
LogicAppsUX copied to clipboard
verified publisher icon Azure

[SQL Artifact] Showing Incorrect syntax near the keyword 'Identity'.

Open v-ksruthi opened this issue 1 month ago • 0 comments

Severity

P1 - Critical (Blocking production)

Describe the Bug with repro steps

Reproduction Steps:

  1. Create a Logic App Standard in Vscode.
  2. Create a workflow.
  3. Convert the project to a bundle to SQL.
  4. Debug the workflow.
  5. Run the workflow.

Expected result: The workflow should run successfully. Actual result: A syntax error appears in the terminal.

What type of Logic App Is this happening in?

Standard (VSCode)

Are you experiencing a regression?

No response

Which operating system are you using?

Windows

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

Yes

Workflow JSON

Screenshots or Videos

For detailed output, run func with --verbose flag. [2025-11-19T07:49:22.092Z] Host lock lease acquired by instance ID '0000000000000000000000009D79AA71'. [2025-11-19T07:49:49.887Z] Executing 'Functions.Stateful1' (Reason='This function was programmatically called via the host APIs.', Id=7c618845-1847-4b60-95f3-d28d1b8d5cd3) [2025-11-19T07:49:52.284Z] Job dispatching error: operationName='JobDispatchingWorker.ScheduleJobExecution', jobPartition='CC299DA7FF5B499CB03E4B0D8824F14F:2D08584380682952635310623090910CU00', jobId='08584380682952635310623090910CU00', message='Job execution engine unable to schedule job executions.', exception='Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'Identity'. [2025-11-19T07:49:52.285Z] Incorrect syntax near the keyword 'Identity'. [2025-11-19T07:49:52.286Z] at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) [2025-11-19T07:49:52.287Z] at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) [2025-11-19T07:49:52.288Z] at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) [2025-11-19T07:49:52.289Z] at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
[2025-11-19T07:49:52.290Z] at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) [2025-11-19T07:49:52.291Z] at Microsoft.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption) [2025-11-19T07:49:52.292Z] at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, Boolean isInternal, String endMethod) [2025-11-19T07:49:52.294Z] at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult) [2025-11-19T07:49:52.295Z] at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult)
[2025-11-19T07:49:52.296Z] at Microsoft.Data.SqlClient.SqlCommand.<>c.<InternalExecuteNonQueryAsync>b__193_1(IAsyncResult asyncResult) [2025-11-19T07:49:52.298Z] at System.Threading.Tasks.TaskFactory1.FromAsyncCoreLogic(IAsyncResult iar, Func2 endFunction, Action1 endAction, Task1 promise, Boolean requiresSynchronization) [2025-11-19T07:49:52.299Z] --- End of stack trace from previous location --- [2025-11-19T07:49:52.300Z] at Microsoft.WindowsAzure.ResourceStack.Common.Storage.Sql.SqlStorageClient.AttemptSqlQuery[T](RequestResult requestResult, SqlResourceType resourceType, Action1 createSqlCommand, Func2 convertTo, Boolean wrapInTransaction) [2025-11-19T07:49:52.301Z] at Microsoft.WindowsAzure.ResourceStack.Common.Storage.Sql.SqlStorageClient.AttemptSqlQuery[T](RequestResult requestResult, SqlResourceType resourceType, Action1 createSqlCommand, Func2 convertTo, Boolean wrapInTransaction) [2025-11-19T07:49:52.303Z] ClientConnectionId:9f6b51f7-022d-4c64-97e7-34c8e3294803 [2025-11-19T07:49:52.304Z] Error Number:156,State:1,Class:15', correlationId='', organizationId='', activityVector='', additionalProperties='', extensionVersion='1.149.59.0', siteName='UNDEFINED_SITE_NAME', slotName='', activityId='feccbe80-c37f-4836-950a-b87595fda35c'. [2025-11-19T07:49:52.797Z] Incoming HTTP request ends with server failure: correlationId='feccbe80-c37f-4836-950a-b87595fda35c', authorizationSource='Direct', authorizationAction='', operationName='POST/API/TRIGGERS/PATHS/INVOKE', httpMethod='POST', hostName='localhost', targetUri='http://localhost:7071/api/Stateful1/triggers/When_an_HTTP_request_is_received/invoke?api-version=2022-05-01&sp=%2ftriggers%2fWhen_an_HTTP_request_is_received%2frun&sv=1.0&sig=sanitized', userAgent='insomnia/11.2.0', clientRequestId='', clientSessionId='', clientIpAddress='', clientApplicationId='', apiVersion='2022-05-01', contentLength='-1', serviceRequestId=':feccbe80-c37f-4836-950a-b87595fda35c', durationInMilliseconds='2892', httpStatusCode='503', exceptionMessage='', errorCode='', failureCause='Service', errorMessage='', referer='', commandName='', parameterSetName='', contentType='application/json; charset=utf-8', contentEncoding='', armServiceRequestId='', organizationId='', activityVector='IN', locale='', additionalProperties='{"ParentActivityId":"00-b4f30e67af863b3ed889d5f3af325d7b-38bc99b5442933d4-00"}', targetResourceProvider='', targetResourceType='', extensionVersion='1.149.59.0', siteName='UNDEFINED_SITE_NAME', slotName='', activityId='feccbe80-c37f-4836-950a-b87595fda35c'. [2025-11-19T07:49:52.813Z] Executed 'Functions.Stateful1' (Succeeded, Id=7c618845-1847-4b60-95f3-d28d1b8d5cd3, Duration=2947ms) [2025-11-19T07:50:04.587Z] Executing 'Functions.Stateful1' (Reason='This function was programmatically called via the host APIs.', Id=95963631-8ec2-4767-a5ad-25d35108f08b) [2025-11-19T07:50:04.591Z] Executed 'Functions.Stateful1' (Succeeded, Id=95963631-8ec2-4767-a5ad-25d35108f08b, Duration=5ms) [2025-11-19T07:50:04.597Z] Executing 'Functions.Stateful1' (Reason='This function was programmatically called via the host APIs.', Id=b8ba9a15-557a-4100-94a2-73588bb2b1a6) [2025-11-19T07:50:06.316Z] Job dispatching error: operationName='JobDispatchingWorker.ScheduleJobExecution', jobPartition='CC299DA7FF5B499CB03E4B0D8824F14F:2D08584380682808754908799721022CU00', jobId='08584380682808754908799721022CU00', message='Job execution engine unable to schedule job executions.', exception='Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'Identity'. [2025-11-19T07:50:06.318Z] Incorrect syntax near the keyword 'Identity'. [2025-11-19T07:50:06.319Z] at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) [2025-11-19T07:50:06.321Z] at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) [2025-11-19T07:50:06.322Z] at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) [2025-11-19T07:50:06.322Z] at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
[2025-11-19T07:50:06.322Z] at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) [2025-11-19T07:50:06.323Z] at Microsoft.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption) [2025-11-19T07:50:06.324Z] at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, Boolean isInternal, String endMethod) [2025-11-19T07:50:06.324Z] at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
[2025-11-19T07:50:06.325Z] at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult)
[2025-11-19T07:50:06.326Z] at Microsoft.Data.SqlClient.SqlCommand.<>c.<InternalExecuteNonQueryAsync>b__193_1(IAsyncResult asyncResult) [2025-11-19T07:50:06.326Z] at System.Threading.Tasks.TaskFactory1.FromAsyncCoreLogic(IAsyncResult iar, Func2 endFunction, Action1 endAction, Task1 promise, Boolean requiresSynchronization) [2025-11-19T07:50:06.327Z] --- End of stack trace from previous location --- [2025-11-19T07:50:06.327Z] at Microsoft.WindowsAzure.ResourceStack.Common.Storage.Sql.SqlStorageClient.AttemptSqlQuery[T](RequestResult requestResult, SqlResourceType resourceType, Action1 createSqlCommand, Func2 convertTo, Boolean wrapInTransaction) [2025-11-19T07:50:06.327Z] at Microsoft.WindowsAzure.ResourceStack.Common.Storage.Sql.SqlStorageClient.AttemptSqlQuery[T](RequestResult requestResult, SqlResourceType resourceType, Action1 createSqlCommand, Func2 convertTo, Boolean wrapInTransaction) [2025-11-19T07:50:06.328Z] ClientConnectionId:75941cd1-2458-4ea1-881a-6397ff8c4363 [2025-11-19T07:50:06.329Z] Error Number:156,State:1,Class:15', correlationId='', organizationId='', activityVector='', additionalProperties='', extensionVersion='1.149.59.0', siteName='UNDEFINED_SITE_NAME', slotName='', activityId='7ae9a15e-82f4-40b4-a35c-17eace07c70a'. [2025-11-19T07:50:06.756Z] Incoming HTTP request ends with server failure: correlationId='7ae9a15e-82f4-40b4-a35c-17eace07c70a', authorizationSource='Direct', authorizationAction='', operationName='POST/API/TRIGGERS/PATHS/INVOKE', httpMethod='POST', hostName='localhost', targetUri='http://localhost:7071/api/Stateful1/triggers/When_an_HTTP_request_is_received/invoke?api-version=2022-05-01&sp=%2ftriggers%2fWhen_an_HTTP_request_is_received%2frun&sv=1.0&sig=sanitized', userAgent='Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.106.1 Chrome/138.0.7204.251 Electron/37.7.0 Safari/537.36', clientRequestId='', clientSessionId='', clientIpAddress='', clientApplicationId='', apiVersion='2022-05-01', contentLength='-1', serviceRequestId=':7ae9a15e-82f4-40b4-a35c-17eace07c70a', durationInMilliseconds='2155', httpStatusCode='503', exceptionMessage='', errorCode='', failureCause='Service', errorMessage='', referer='', commandName='', parameterSetName='', contentType='application/json; charset=utf-8', contentEncoding='', armServiceRequestId='', organizationId='', activityVector='IN', locale='en-US', additionalProperties='{"ParentActivityId":"00-4e0dab6365016776c950c0b473be44f8-19b469fd0384191b-00"}', targetResourceProvider='', targetResourceType='', extensionVersion='1.149.59.0', siteName='UNDEFINED_SITE_NAME', slotName='', activityId='7ae9a15e-82f4-40b4-a35c-17eace07c70a'. [2025-11-19T07:50:06.757Z] Executed 'Functions.Stateful1' (Succeeded, Id=b8ba9a15-557a-4100-94a2-73588bb2b1a6, Duration=2159ms)

Image

Environment

Issue repro in latest Vs code request Vs code version:5.230.13 Bundle Version:1.149.59

Additional context

No response

v-ksruthi avatar Nov 19 '25 07:11 v-ksruthi