cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mcolbert
Level 8

Flow Fails on Cannot Find Stored Procedure

SQL Server Connection and Flow are not playing nice together to say the least. Have a flow that WORKED! Yet today, failing on ...

 

Could not find stored procedure 'dbo.SynchSourceLogInsert'.
clientRequestId: 13063526-211f-479d-93de-cf2701ce0dde

 

Yet flow allows me to configure the step just find so it surely knows it exists when I configure it. But fails when I run it.

Issues with SQL connector are CONSTANT!!!!! These really needs some attention.

3 REPLIES 3
Community Support Team
Community Support Team

Re: Flow Fails on Cannot Find Stored Procedure

Hi @mcolbert ,

 

Please try to check the connection status in Connection list and fix it here:

Capture.JPG

 

For further flow issue, please post in Flow community here:

https://powerusers.microsoft.com/t5/Microsoft-Flow-Community/ct-p/FlowCommunity

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mcolbert
Level 8

Re: Flow Fails on Cannot Find Stored Procedure

This is not the problem. The SQL connection is fine. And when I say teh connection works in design byut fails when running I mean the following;

 

I edit the flow

click the elipsis on the stored procedure step and shows my connection selected, if I clkikc the drop down onb the stored procedure name, it shows a correct list

I then click save & test

Flow fails with stpored procedure not found

 

The run environment seems to be picking up a different connection. 

 

 

 

AlwasyMKT
Level: Powered On

Re: Flow Fails on Cannot Find Stored Procedure

Hi @mcolbert ,

 

how you solved the issue?

 

Thanks.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 197 members 4,428 guests
Please welcome our newest community members: