在Azure Logic App中执行存储过程-网关错误 [英] Execute Stored Procedure in Azure Logic App - Bad gateway error

问题描述

当我从逻辑应用设计器中执行存储过程时，我收到了严重的网关错误.

When I execute the stored procedure from logic app designer, I'm getting bad gateway error.

我要调用的存储过程

create procedure test as select * from testable

测试表包含100000+行.

test table contains 100000+ rows.

存储过程的结果放置在Blob/FTP中.

The results of stored procedure are placed in Blob/FTP.

错误

持续时间:0秒

Duration: 0s

开始时间:2017-08-11T17:37:57.8096605Z

Start time: 2017-08-11T17:37:57.8096605Z

结束时间:2017-08-11T17:37:58.0909952Z

End time: 2017-08-11T17:37:58.0909952Z

状态:BadGateway

Status: BadGateway

有人可以帮助我吗?

推荐答案

检查那些想法 1.检查与DB的连接. 2.如果您将代理添加到数据库，请检查并列出IP. 3.检查您的SP代码在本地是否正常运行. 4.如果您有很多数据库，则检查是否选择了数据库. 5.从本地数据库检查Sp的运行时间，然后超时.

Check those thinks 1. Check the connection with DB. 2. If you put proxy to DB check and wite list the IP. 3. Check you SP code is it working properly in local. 4. The check did you select DB if you have many DB. 5. Check the Sp run time from the local DB and do the time out.

这篇关于在Azure Logic App中执行存储过程-网关错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！