Unanswered

Object reference not set to an instance of an object when connecting to on prem SQL

(0) Share

Report

Posted on by szona

Hi All,

First time poster/Flow newb. I'm trying to use a SQL execute stored procedure action against an on-prem SQL server via the gateway. I believe the gateway configuration is fine; when I select the server the list of available stored procedures populates. However, when I select one I get the error message: Unknown Mashup Exception. inner exception: Object reference not set to an instance of an object.

I am trying to execute sp_start_job

thanks!

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

szona 6 on at

Like (0)

Report

ugh well just found this tidbit in the release notes, so I guess it isn't going to happen!

SQL Stored Procedures cannot be run on On-premises SQL Servers. Only SQL Azure supports Stored Procedures at this time.

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report

Hi Szona,

Thanks for your understanding. I have also seen another thread which says that Stored procedures are unfortunately not supported while using a Gateway. Please check the thread for a reference:
https://powerusers.microsoft.com/t5/Flow-Forum/Unable-to-Execute-Stored-procedure/td-p/7764

Best regards,
Mabel Mao

Was this reply helpful? Yes No