找回密码
 立即注册

QQ登录

只需一步,快速开始

小号

初级会员

21

主题

92

帖子

233

积分

初级会员

积分
233
小号
初级会员   /  发表于:2019-11-4 10:12  /   查看:2484  /  回复:5
1金币
Request Exception Happened-------------------------------
Path/Home/GetTableDataWithOffset
UserName:Administrator
{
  "Errors": {
    "$type": "System.Data.SqlClient.SqlErrorCollection, System.Data",
    "$values": [
      {
        "$type": "System.Data.SqlClient.SqlError, System.Data",
        "Source": ".Net SqlClient Data Provider",
        "Number": -2,
        "State": 0,
        "Class": 11,
        "Server": "THEODORE\\YUANJIU",
        "Message": "执行超时已过期。完成操作之前已超时或服务器未响应。 ",
        "Procedure": "",
        "LineNumber": 0
      }
    ]
  },
  "ClientConnectionId": "32f8a5b9-7a3b-46dc-a037-66ad52ff646b",
  "ClassName": "System.Data.SqlClient.SqlException",
  "Message": "执行超时已过期。完成操作之前已超时或服务器未响应。 ",
  "Data": {
    "$type": "System.Collections.ListDictionaryInternal, mscorlib",
    "HelpLink.ProdName": "Microsoft SQL Server",
    "HelpLink.EvtSrc": "MSSQLServer",
    "HelpLink.EvtID": "-2",
    "HelpLink.BaseHelpUrl": "http://go.microsoft.com/fwlink",
    "HelpLink.LinkId": "20476",
    "App Name": "ForguncyServerConsole.exe",
    "App Version": "5.0.6.0",
    "Timestamp of the exe": "5d368aef",
    "Assembly Name": "System.Data",
    "Version of faulting assembly": "4.8.3752.0",
    "Timestamp of faulting module": "5c7a16d5",
    "MethodDef": "1d68",
    "IL Offset of faulting instruction": "27",
    "Exception Type": "System.Data.SqlClient.Sql",
    "NIL": ""
  },
  "InnerException": {
    "$type": "System.ComponentModel.Win32Exception, System",
    "NativeErrorCode": 258,
    "ClassName": "System.ComponentModel.Win32Exception",
    "Message": "等待的操作过时。",
    "Data": null,
    "InnerException": null,
    "HelpURL": null,
    "StackTraceString": null,
    "RemoteStackTraceString": null,
    "RemoteStackIndex": 0,
    "ExceptionMethod": null,
    "HResult": -2147467259,
    "Source": null,
    "WatsonBuckets": null
  },
  "HelpURL": null,
  "StackTraceString": "   在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   在 System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   在 System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   在 System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   在 System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   在 System.Data.SqlClient.SqlDataReader.get_MetaData()
   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   在 Forguncy.DataSourceBase.FillTable(DataTable dataTable, String tableName, String tableSchema, Nullable`1 maxRows, String commandText, IEnumerable`1 parameters)
   在 ForguncyDataAccess.DataAccess.a(String A_0, String A_1, DataBaseType A_2, DbParameter[] A_3)
   在 ForguncyDataAccess.DataAccess.Select(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
   在 Forguncy.Server2.a.a(TopSqlConditionBase A_0, String A_1, Boolean A_2, h A_3, OffsetSqlCondition A_4)
   在 Forguncy.Server2.a.Select(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
   在 ForguncyDataAccess.DataAccess.GetDetailDataTable(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct)
   在 ForguncyDataAccess.DataAccess.GetDataTable(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct)
   在 Forguncy.Server2.Controllers.HomeController.a(List`1 A_0, CurrentRowInfo A_1, Int32 A_2, Int32 A_3, Boolean A_4, QueryCommandInfo A_5, List`1 A_6, String A_7, OffsetSqlCondition A_8, Boolean A_9, ColumnFilterQuery[] A_10, Boolean A_11)
   在 Forguncy.Server2.Controllers.HomeController.GetTableDataWithOffset(List`1 bindingInfos, CurrentRowInfo currentRowInfo, Int32 demandRowCount, Int32 currentDataLength, Boolean needRowVersion, QueryCommandInfo queryCommandInfo, List`1 orderByInfo, String sortCommandID, List`1 editorDataInfos, OffsetConditionInfo offsetConditionInfo, ColumnFilterQuery[] columnFilterQueries)",
  "RemoteStackTraceString": null,
  "RemoteStackIndex": 0,
  "ExceptionMethod": "8
OnError
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Data.SqlClient.SqlInternalConnection
Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])",
  "HResult": -2146232060,
  "Source": ".Net SqlClient Data Provider",
  "WatsonBuckets": null
}

5 个回复

倒序浏览
LukeLiu
超级版主   /  发表于:2019-11-4 17:48:47
沙发
你好,这是什么使用场景下产生的报错?
回复 使用道具 举报
小号
初级会员   /  发表于:2019-11-5 15:30:30
板凳
LukeLiu 发表于 2019-11-4 17:48
你好,这是什么使用场景下产生的报错?

页面打开正在加载的过程中报错,所有的表格相关的表都设置ID=0的查询
回复 使用道具 举报
Eric.Liang讲师达人认证 悬赏达人认证 活字格认证
超级版主   /  发表于:2019-11-6 16:45:02
地板
小号 发表于 2019-11-5 15:30
页面打开正在加载的过程中报错,所有的表格相关的表都设置ID=0的查询

上传下工程我们看下吧,单纯的这样描述定位不到问题的
回复 使用道具 举报
小号
初级会员   /  发表于:2019-11-7 10:00:31
5#
Eric.Liang 发表于 2019-11-6 16:45
上传下工程我们看下吧,单纯的这样描述定位不到问题的

全是外联的表,上传了 除非把客户的数据库的表全给你们,可以远程看一下吗
回复 使用道具 举报
Eric.Liang讲师达人认证 悬赏达人认证 活字格认证
超级版主   /  发表于:2019-11-7 14:16:20
6#
小号 发表于 2019-11-7 10:00
全是外联的表,上传了 除非把客户的数据库的表全给你们,可以远程看一下吗

不好意思哈,我们金牌用户的远程比较多,你可以把测试的数据库备份给我们,我们抽时间本地还原看下
回复 使用道具 举报
您需要登录后才可以回帖 登录 | 立即注册
返回顶部