eConnect 到 Great Plains 错误：“超时已过期” - 如何修复？

发布于 2024-10-08 23:57:54 字数 1020 浏览 14 评论 0原文

尝试通过 SOAP 调用提取 Great Plains 过去 30 天的对帐订单时收到以下错误：

服务器System.Web.Services.Protocols.SoapException：服务器无法处理请求。 ---> System.Data.SqlClient.SqlException：超时已过。超时时间完成前已过去操作或服务器不回应。在 System.Data.SqlClient.SqlConnection.OnError（SqlException 异常，布尔值断开连接）在 System.Data.SqlClient.SqlInternalConnection.OnError（SqlException 异常，布尔值breakConnection）

如何确定或更改超时设置？那是一个连接字符串变量吗？在我们的 Web 服务方法中，它的开头是这样的：

ConnectionString = ConfigurationManager.ConnectionStrings["gp"].ToString();

它从 web.config 文件中获取：

<configuration>

    <appSettings/>
    <connectionStrings>
        <add name="gp" connectionString="Data Source=10.10.10.90;Integrated Security=SSPI;Persist Security Info=False;trusted_connection=true;Initial Catalog=DEFAULT;" />
    </connectionStrings>
    <system.web>

并非所有精通 ASP/eConnect 的人都知道这一点，直到几周前超时错误开始时才起作用。

原文

Receiving the following error when trying to pull reconciled orders from the last 30 days in Great Plains from a SOAP call:

Server</faultcode><faultstring>System.Web.Services.Protocols.SoapException:
Server was unable to process request.
---> System.Data.SqlClient.SqlException:
Timeout expired. The timeout period
elapsed prior to completion of the
operation or the server is not
responding. at
System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean
breakConnection) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)

How can I determine or change the timeout setting? Is that a connection string variable? In our web service method, it has this at the beginning:

ConnectionString = ConfigurationManager.ConnectionStrings["gp"].ToString();

Which it gets from a web.config file:

<configuration>

    <appSettings/>
    <connectionStrings>
        <add name="gp" connectionString="Data Source=10.10.10.90;Integrated Security=SSPI;Persist Security Info=False;trusted_connection=true;Initial Catalog=DEFAULT;" />
    </connectionStrings>
    <system.web>

Not all that versed in ASP/eConnect and this has worked up until a few weeks ago when the timeout error started.

分享到QQ

分享到微博