When attempting to connect to a SQL Server (via a data gateway), I authenticate using SQL Server Authentication.
When trying to execute stored procedure, I am met with the following error:
The key didn't match any rows in the table
I did not specify any keys, columns or parameters - there were no optional fields, only three required: Server, database, and proc.
Yet it fails when executed.
"The dynamic operation request to API 'sql' operation 'GetProcedure_V2' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "status": 400, "message": "The key didn't match any rows in the table.\r\n inner exception: The key didn't match any rows in the table.\r\nclientRequestId: {redacted}", "error": { "message": "The key didn't match any rows in the table.\r\n inner exception: The key didn't match any rows in the table." }, "source": "sql-we.azconn-we-002.p.azurewebsites.net" }'.
I didn't specify any keys, and the proc I'm executing returns a single value in a one column/row table output.
