Unanswered

The key didn't match any rows in the table

(0) Share

Report

Posted on by Community Power Pla...

Hi All

we have an issue with our gateway ( version 3000.5.185 ) when running complex queries ( as Stored Procedure ).
Each time we get:

The key didn't match any rows in the table.

inner exception: The key didn't match any rows in the table.

clientRequestId: 7f803c00-ac4a-4f5a-bf1f-9d68113f5f14"

This is getting frustrating since there is no indication to what is the issue.
we tried to add extra logging via the gateway BUT nothing came up.
is there a way to know why the SP failed ?

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

v-zhos-msft on at

Like (0)

Report

Hi @Anonymous ,

Could you please share a screenshot of the configuration of your flow?

The error message told that the key didn't match any rows in the table,I afraid that there is something wrong in your flow's configuration.

I am afraid I need more details to analysis for you.

There is a similar case you can take a reference:

https://powerusers.microsoft.com/t5/Connecting-To-Data/New-SQL-Actions-failing-Connection-on-prem-problem-quot-The-key/m-p/254540?collapse_discussion=true&q=The%20key%20didn%27t%20match%20any%20rows%20in%20the%20table.&search_type=thread

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @v-zhos-msft
Thanks for your replay

My configuration is very simple:
i tried what you suggested in the mention post BUT it didnt worked.
my "Hunch" says it has to do to my SP and the way it's build.
is there any restriction to what Flow can run ?

The SP in my SS checks if a user ( UserName ) can run a SP ( FullObjectName )
when i try to change the connection to just run the SP i get the expected result i.e. no permission to table1 etc..

The BIG SP "GetMissingReferencedPermissionsForUser" is very complex ( even though Flow knows it's expected parameters )

My end result will be to embed it in PA inside an existing app to check if the user can run a SP or he should get the necessary permission

Was this reply helpful? Yes No