Hi All ,
I'm trying to update a row in SQL table and i get this error.
Error :
{
"error": {
"code": 502,
"source": "europe-002.azure-apim.net",
"clientRequestId": "a0206a35-1ff7-442c-97a0-cc08babe386b",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "Unexpected Exception : System.IndexOutOfRangeException: Index was outside the bounds of the array.\r\n at Microsoft.Azure.Connectors.Mashup.Sql.SqlNativeAdapter.GetKeyFilter(HttpRequestMessage request, PassThroughNativeQueryResult schema, String dataset, String table, String id) in X:\\bt\\1078991\\repo\\src\\source\\Mashup\\Sql\\Native\\Adapter\\SqlNativeAdapter.cs:line 1031\r\n at Microsoft.Azure.Connectors.Mashup.Sql.SqlNativeAdapter.<GetSqlUpdateInputs>d__48.MoveNext() in X:\\bt\\1078991\\repo\\src\\source\\Mashup\\Sql\\Native\\Adapter\\SqlNativeAdapter.cs:line 1076\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Azure.Connectors.Mashup.Sql.SqlNativeAdapter.<PatchItemAsync>d__29.MoveNext() in X:\\bt\\1078991\\repo\\src\\source\\Mashup\\Sql\\Native\\Adapter\\SqlNativeAdapter.cs:line 527\r\n inner exception: Index was outside the bounds of the array.\r\nclientRequestId: a0206a35-1ff7-442c-97a0-cc08babe386b",
"error": {
"message": "Unexpected Exception : System.IndexOutOfRangeException: Index was outside the bounds of the array.\r\n at Microsoft.Azure.Connectors.Mashup.Sql.SqlNativeAdapter.GetKeyFilter(HttpRequestMessage request, PassThroughNativeQueryResult schema, String dataset, String table, String id) in X:\\bt\\1078991\\repo\\src\\source\\Mashup\\Sql\\Native\\Adapter\\SqlNativeAdapter.cs:line 1031\r\n at Microsoft.Azure.Connectors.Mashup.Sql.SqlNativeAdapter.<GetSqlUpdateInputs>d__48.MoveNext() in X:\\bt\\1078991\\repo\\src\\source\\Mashup\\Sql\\Native\\Adapter\\SqlNativeAdapter.cs:line 1076\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Azure.Connectors.Mashup.Sql.SqlNativeAdapter.<PatchItemAsync>d__29.MoveNext() in X:\\bt\\1078991\\repo\\src\\source\\Mashup\\Sql\\Native\\Adapter\\SqlNativeAdapter.cs:line 527\r\n inner exception: Index was outside the bounds of the array."
},
"source": "sql-ne.azconn-ne.p.azurewebsites.net"
}
}
}
Flow :
Note : This is only table i cannot update , i was successful while updating other tables.
Maybe it has something to do with the design of the sql table?
I have a few primary keys with relation to other tables , is this the issue?
Appreciate any help!
