本帖最后由 Zhangjqy 于 2026-1-6 09:26 编辑
查询操作超时，提示如下，请问能不能设置活字格查询时间长一点。
C:\Users\79338\AppData\Local\Temp\企业微信截图_1767662607344.png/Forguncy/Home/GetTableDataWithOffset
Internal Server Error
Request Exception Happened-------------------------------
Path/Home/GetTableDataWithOffset
UserName:Administrator
Sql Statement:
[
{
"Sql": "SELECT TABLE_NAME , COLUMN_NAME , DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE (DATA_TYPE = 'rowversion' OR DATA_TYPE = 'timestamp') AND TABLE_NAME = \"V_HZG_SO_SOMain\" AND TABLE_SCHEMA = \"dbo\" ",
"OriginalSql": "SELECT TABLE_NAME , COLUMN_NAME , DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE (DATA_TYPE = 'rowversion' OR DATA_TYPE = 'timestamp') AND TABLE_NAME = @p0 AND TABLE_SCHEMA = @p1",
"SqlParams": [
{
"Name": "@p0",
"Value": "V_HZG_SO_SOMain"
},
{
"Name": "@p1",
"Value": "dbo"
}
],
"SqlParam": null,
"Duration": "1.2056ms"
},
{
"Sql": "select Top 50 a.[AutoID] as C0,a.[iStatus] as C1,a.[id] as C2,a.[订单号] as C3,a.[订单状态] as C4,a.[客户编码] as C5,a.[客户] as C6,a.[订单日期] as C7,a.[销售类型] as C8,a.[部门编码] as C9,a.[部门名称] as C10,a.[制单人] as C11,a.[业务员名称] as C12,a.[业务员编码] as C13,a.[付款条件] as C14,a.[仓库] as C15,a.[产品编码] as C16,a.[产品名称] as C17,a.[产品规格] as C18,a.[单位] as C19,a.[销售数量] as C20,a.[含税单价] as C21,a.[含税金额] as C22,a.[预发货日期] as C23,a.[备注] as C24,a.[未发货数量] as C25,a.[客户PO号] as C26,a.[是否停用] as C27,a.[付款条件编码] as C28,a.[累计发货数量] as C29,a.[税率] as C30,a.[已下达生产数量] as C31,a.[主表备注] as C32,a.[创建日期] as C33 from [dbo].[V_HZG_SO_SOMain] as a Where a.[iStatus] = 1 AND a.[未发货数量] > 0 AND a.[cAcctID] = \"天津供应链\" AND (a.[cCloser] <> \"1\" OR a.[cCloser] is null ) AND (a.[临时发货标识] <> 1 OR a.[临时发货标识] is null ) ORDER BY a.[订单日期] DESC,a.[AutoID] ASC ",
"OriginalSql": "select Top 50 a.[AutoID] as C0,a.[iStatus] as C1,a.[id] as C2,a.[订单号] as C3,a.[订单状态] as C4,a.[客户编码] as C5,a.[客户] as C6,a.[订单日期] as C7,a.[销售类型] as C8,a.[部门编码] as C9,a.[部门名称] as C10,a.[制单人] as C11,a.[业务员名称] as C12,a.[业务员编码] as C13,a.[付款条件] as C14,a.[仓库] as C15,a.[产品编码] as C16,a.[产品名称] as C17,a.[产品规格] as C18,a.[单位] as C19,a.[销售数量] as C20,a.[含税单价] as C21,a.[含税金额] as C22,a.[预发货日期] as C23,a.[备注] as C24,a.[未发货数量] as C25,a.[客户PO号] as C26,a.[是否停用] as C27,a.[付款条件编码] as C28,a.[累计发货数量] as C29,a.[税率] as C30,a.[已下达生产数量] as C31,a.[主表备注] as C32,a.[创建日期] as C33 from [dbo].[V_HZG_SO_SOMain] as a Where a.[iStatus] = @p0 AND a.[未发货数量] > @p1 AND a.[cAcctID] = @p2 AND (a.[cCloser] <> @p3 OR a.[cCloser] is null ) AND (a.[临时发货标识] <> 1 OR a.[临时发货标识] is null ) ORDER BY a.[订单日期] DESC,a.[AutoID] ASC",
"SqlParams": [
{
"Name": "@p0",
"Value": 1
},
{
"Name": "@p1",
"Value": 0.0
},
{
"Name": "@p2",
"Value": "天津供应链"
},
{
"Name": "@p3",
"Value": "1"
}
],
"SqlParam": null,
"Duration": "30004.9584ms"
}
]
{
"IsTransient": false,
"SqlState": null,
"BatchCommand": null,
"ErrorCode": -2147467259,
"Message": "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
select Top 50 a.[AutoID] as C0,a.[iStatus] as C1,a.[id] as C2,a.[订单号] as C3,a.[订单状态] as C4,a.[客户编码] as C5,a.[客户] as C6,a.[订单日期] as C7,a.[销售类型] as C8,a.[部门编码] as C9,a.[部门名称] as C10,a.[制单人] as C11,a.[业务员名称] as C12,a.[业务员编码] as C13,a.[付款条件] as C14,a.[仓库] as C15,a.[产品编码] as C16,a.[产品名称] as C17,a.[产品规格] as C18,a.[单位] as C19,a.[销售数量] as C20,a.[含税单价] as C21,a.[含税金额] as C22,a.[预发货日期] as C23,a.[备注] as C24,a.[未发货数量] as C25,a.[客户PO号] as C26,a.[是否停用] as C27,a.[付款条件编码] as C28,a.[累计发货数量] as C29,a.[税率] as C30,a.[已下达生产数量] as C31,a.[主表备注] as C32,a.[创建日期] as C33 from [dbo].[V_HZG_SO_SOMain] as a Where a.[iStatus] = @p0 AND a.[未发货数量] > @p1 AND a.[cAcctID] = @p2 AND (a.[cCloser] <> @p3 OR a.[cCloser] is null ) AND (a.[临时发货标识] <> 1 OR a.[临时发货标识] is null ) ORDER BY a.[订单日期] DESC,a.[AutoID] ASC",
"Data": {
"$type": "System.Collections.ListDictionaryInternal, System.Private.CoreLib"
},
"InnerException": null,
"HelpLink": null,
"Source": "GrapeCity.Forguncy.DataBaseApi",
"HResult": -2147467259,
"StackTrace": " at GrapeCity.Forguncy.DataBaseApi.DataWrapperBase.FillTableAsync(String commandText, IEnumerable`1 parameters)
at GrapeCity.Forguncy.DataBaseApi.DataWrapperBase.FillTableAsync(String commandText, IEnumerable`1 parameters)
at Forguncy.DataSourceBase.FillTableAsync(String commandText, IEnumerable`1 parameters)
at ForguncyDataAccess.DataAccess.SelectFromDatabaseAsync(String connectionString, String selectString, String databaseType, DbParameter[] parameters, ISqlSettings sqlSettings)
at ForguncyDataAccess.DataAccess.SelectAsync(ISqlSettings sqlSettings, List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
at Forguncy.Server2.ForguncyServerDataAccess.SelectAsync(ISqlSettings sqlSettings, List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
at ForguncyDataAccess.DataAccess.GetDetailDataTableWithSqlSettingsAsync(ISqlSettings sqlSettings, List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct, Boolean ensureOrderBy)
at ForguncyDataAccess.DataAccess.GetDetailDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct, Boolean ensureOrderBy)
at ForguncyDataAccess.DataAccess.GetDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct, Boolean ensureOrderBy)
at Forguncy.Server2.ForguncyServerDataAccess.GetDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct, Boolean ensureOrderBy)
at Forguncy.Server2.Controllers.HomeController.QueryDataByDataAccessAsync(List`1 infos, Int32 demandRowCount, OffsetSqlCondition offsetCondition, Boolean distinct, ISqlCondition queryConditionObj, TopSqlConditionBase topConditionObj, OrderBySqlCondition orderByConditionObj, List`1 primaryKeys, IDataAccess dataAccess)
at Forguncy.Server2.Controllers.HomeController.GetListviewDataAsync(List`1 infos, CurrentRowInfo currentRowInfo, Int32 demandRowCount, Int32 currentDataLength, Boolean needRowVersion, QueryCommandInfo queryCommandInfo, List`1 currentOrderByInfo, RuntimeQueryConditionData runtimeQueryConditionData, String sortCommandID, OffsetSqlCondition offsetCondition, Boolean needWriteDataAccessLog, ColumnFilterQuery[] columnFilterQueries, Boolean distinct, List`1 totalRowBindingInfos, Boolean allowLoadOnDemaid, Boolean addQueryConditionStatisticColumnToBindingInfoList, String dataSourceGUID)
at Forguncy.Server2.Controllers.HomeController.GetListviewDataAsync(List`1 infos, CurrentRowInfo currentRowInfo, Int32 demandRowCount, Int32 currentDataLength, Boolean needRowVersion, QueryCommandInfo queryCommandInfo, List`1 currentOrderByInfo, RuntimeQueryConditionData runtimeQueryConditionData, String sortCommandID, OffsetSqlCondition offsetCondition, Boolean needWriteDataAccessLog, ColumnFilterQuery[] columnFilterQueries, Boolean distinct, List`1 totalRowBindingInfos, Boolean allowLoadOnDemaid, Boolean addQueryConditionStatisticColumnToBindingInfoList, String dataSourceGUID)
at Forguncy.Server2.Controllers.HomeController.<>c__DisplayClass35_0.<<GetTableDataWithOffsetAsync>b__0>d.MoveNext()
--- End of stack trace from previous location ---
at Forguncy.Server2.Controllers.HomeController.GetTableDataWithCacheAsync[T](CacheSetting cacheSetting, String tableName, Object paramObj, Func`1 action)
at Forguncy.Server2.Controllers.HomeController.GetTableDataWithOffsetAsync(GetTableDataWithOffsetParam data)
at lambda_method1245(Closure, Object)
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
at ServerDesignerCommon.CodeEditor.CodeEditorMiddleware.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.JavaAdapterReflectMiddleWare.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.ProcessEngineMiddleware.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.ReportsMiddleware.DoInvokeAsync(HttpContext context, ICacheService cacheService, IReportServerService reportServerService)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase`2.InvokeAsync(HttpContext context, TService1 service1, TService2 service2)
at Forguncy.KatanaMiddleware.ServerCommandMiddleware.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.AppServiceMiddleware.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at ak.DoInvokeAsync(HttpContext a)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at aj.DoInvokeAsync(HttpContext a)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.StartPageMiddleware.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.ResourceMiddleware.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at ForguncyServerCommon.HttpHeaderMiddlewareBase.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
at ForguncyServerCommon.HttpResponseHeaderMiddlewareBase.DoInvokeAsync(HttpContext context)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.IpRestrictionMiddleware.DoInvokeAsync(HttpContext httpContext)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.RecordProxyHeaderInfoMiddleware.DoInvokeAsync(HttpContext httpContext)
at Forguncy.Log.Logger.Component.LoggingMiddlewareBase.InvokeAsync(HttpContext context)
at ar.DoInvokeAsync(HttpContext a)"
}
|
