Unanswered

Error on running SQL Stored Procedure from ms flow

Like (0) Share

Report

Posted on 13 Apr 2018 10:53:29 by Community Power Pla...

I am using a flow to run an SQL stored procedure.

As a bit of background, the SQL server holding the stored procedure is a connection on the On Premise Data Gateway we have running.

When testing i had the SP run a SQL Server Agent job this was all good.

Now i have it assigned to a flow running another SP that requires an input parameter, but whenever i test this i get this error.

On testing this parameter is hard coded but the error suggests it can't even find the SP.

Which looks to be saying that MS Flow can't find the SP which is hard to believe as it is selected from the connection list.

Any ideas?

Error message :
  "status": 400,
  "message": "Invalid Mashup Expression using supplied values.\r\n     inner exception: The specified item '[dbo].[SP_PartnerDataLoadRetrieveFile]' is not found.\r\nclientRequestId: 3b1974b3-edd2-4fcf-8292-d6cf07e92397",
  "source": "sqlconnectionprovider-westeurope.am2-ase-001.p.azurewebsites.net"

Categories:

Connecting to Data

All responses (3)

Answers (0)

Community Power Pla... on 16 Apr 2018 at 09:54:37

Like (0)

Report

Re: Error on running SQL Stored Procedure from ms flow

Thanks for the reply, i have the flow working now. When was running as test from the Ms Flow front end it was defaulting to a different connection. No idea why but there is a little drop down and finally found that for this issue.

I now seem to be stuck at another point. I have an SSIS package that i essentially want to run from a button in powerapps.

The flow runs correctly from the button or on test from Ms Flow management area.

However the SSIS package returns as if it is reading this package being used not from where i assumed it would do (run as me.)

I am assuming this is some disconnect from the flow calling the stored procedure on the SQL server.

Whatever user is defined by default doesn't have access to run the SSIS package.

Is there anyway to set this to resolve the job running as normal?
Community Power Pla... on 16 Apr 2018 at 09:53:58

Like (0)

Report

Re: Error on running SQL Stored Procedure from ms flow

Thanks for the reply, i have the flow working now. When was running as test from the Ms Flow front end it was defaulting to a different connection. No idea why but there is a little drop down and finally found that for this issue.

I now seem to be stuck at another point. I have an SSIS package that i essentially want to run from a button in powerapps.

The flow runs correctly from the button or on test from Ms Flow management area.

However the SSIS package returns as if it is reading this package being used not from where i assumed it would do (run as me.)

I am assuming this is some disconnect from the flow calling the stored procedure on the SQL server.

Whatever user is defined by default doesn't have access to run the SSIS package.

Is there anyway to set this to resolve the job running as normal?
v-xida-msft on 16 Apr 2018 at 07:55:03

Like (0)

Report

Re: Error on running SQL Stored Procedure from ms flow

Hi @Anonymous,

Could you please share a screenshot of your flow's configuration?

The error message told that the SQL Stored Procudure that you specified could not be found within your SQL database. I have made a test on my side and don't have the issue that you mentioned. My flow's configuration as below:

The flow works successfully as below:

Please check if the SQL Stored Procedure that you specified is existed in your SQL database. In addition, please check if the connection to the SQL Server connector is invalid, if yes, please update the connection to the SQL Server connector and then try your flow again.

You could also consider take a try to re-create a new connection to the SQL Server connector within your flow and then try your flow again to check if the issue is solved.

Best regards,

Kris