请选择 进入手机版 | 继续访问电脑版
 找回密码
 立即注册

QQ登录

只需一步,快速开始

Zdaoyu
金牌服务用户   /  发表于:2022-4-2 12:16  /   查看:1830  /  回复:3
1金币
导出表格到excel报错了,下面是报错页面在执行导出操作时,未知的异常出现。请再次尝试。{  "ClassName": "System.AggregateException",  "Message": "One or more errors occurred.",  "Data": null,  "InnerException": {    "$type": "System.OverflowException, System.Private.CoreLib",    "ClassName": "System.OverflowException",    "Message": "Not a legal OleAut date.",    "Data": null,    "InnerException": null,    "HelpURL": null,    "StackTraceString": "   at System.DateTime.TicksToOADate(Int64 value)   at CommonUtilities.JsonUtilities.UtcDateJsonConverter.WriteJson(JsonWriter writer, Object value, JsonSerializer serializer)   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeConvertable(JsonWriter writer, JsonConverter converter, Object value, JsonContract contract, JsonContainerContract collectionContract, JsonProperty containerProperty)   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeDictionary(JsonWriter writer, IDictionary values, JsonDictionaryContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.Serialize(JsonWriter jsonWriter, Object value, Type objectType)   at Newtonsoft.Json.JsonSerializer.SerializeInternal(JsonWriter jsonWriter, Object value, Type objectType)   at Newtonsoft.Json.JsonConvert.SerializeObjectInternal(Object value, Type type, JsonSerializer jsonSerializer)   at CommonUtilities.JsonUtilities.GetJsonString(Object obj, Boolean useUTCDateJsonConverter, JsonConverter[] converters, JsonSerializerSettings settings)   at CommonUtilities.JsonUtilities.GetJsonString(Object obj, Boolean useUTCDateJsonConverter, JsonConverter[] converters)   at CommonUtilities.JsonUtilities.GetJsonString(Object obj, Boolean useUTCDateJsonConverter)   at ForguncyDataAccess.DataAccess.AddQueryColumn(List`1 primaryKeyColumnIndexs, TableData tableData)   at ForguncyDataAccess.DataAccess.RemovePrimaryKeysColumnBindings(Int32 realColumnCount, List`1 columnBindingInfos, TableData tableData, List`1 primaryKeyColumnIndexs)   at ForguncyDataAccess.DataAccess.GetDetailDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct)   at ForguncyDataAccess.DataAccess.<>c__DisplayClass30_0.<<GetDetailDataTable>b__0>d.MoveNext()",    "RemoteStackTraceString": null,    "RemoteStackIndex": 0,    "ExceptionMethod": null,    "HResult": -2146233066,    "Source": "System.Private.CoreLib",    "WatsonBuckets": null  },  "HelpURL": null,  "StackTraceString": "   at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)   at Forguncy.Server2.Controllers.b.q(String A_0, String A_1)   at Forguncy.Server2.Controllers.a.a(ListViewInfo A_0, Boolean A_1)   at Forguncy.Server2.Controllers.a.e(GcExcelSheetWrapper A_0, List`1 A_1)   at Forguncy.Server2.Controllers.a.b(Int32 A_0)   at Forguncy.Server2.Controllers.a.c(Int32 A_0)   at Forguncy.Server2.Controllers.a.a(Int32 A_0)   at Forguncy.Server2.Controllers.a.a(Action`1 A_0)   at Forguncy.Server2.Controllers.a.c(Boolean A_0)   at Forguncy.Server2.Controllers.a.a(String A_0, List`1 A_1)   at Forguncy.Server2.Controllers.HomeController.a(Object A_0)",  "RemoteStackTraceString": null,  "RemoteStackIndex": 0,  "ExceptionMethod": null,  "HResult": -2146233088,  "Source": "System.Private.CoreLib",  "WatsonBuckets": null,  "InnerExceptions": {    "$type": "System.Exception[], System.Private.CoreLib",    "$values": [      {        "$type": "System.OverflowException, System.Private.CoreLib",        "ClassName": "System.OverflowException",        "Message": "Not a legal OleAut date.",        "Data": null,        "InnerException": null,        "HelpURL": null,        "StackTraceString": "   at System.DateTime.TicksToOADate(Int64 value)   at CommonUtilities.JsonUtilities.UtcDateJsonConverter.WriteJson(JsonWriter writer, Object value, JsonSerializer serializer)   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeConvertable(JsonWriter writer, JsonConverter converter, Object value, JsonContract contract, JsonContainerContract collectionContract, JsonProperty containerProperty)   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeDictionary(JsonWriter writer, IDictionary values, JsonDictionaryContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)   at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.Serialize(JsonWriter jsonWriter, Object value, Type objectType)   at Newtonsoft.Json.JsonSerializer.SerializeInternal(JsonWriter jsonWriter, Object value, Type objectType)   at Newtonsoft.Json.JsonConvert.SerializeObjectInternal(Object value, Type type, JsonSerializer jsonSerializer)   at CommonUtilities.JsonUtilities.GetJsonString(Object obj, Boolean useUTCDateJsonConverter, JsonConverter[] converters, JsonSerializerSettings settings)   at CommonUtilities.JsonUtilities.GetJsonString(Object obj, Boolean useUTCDateJsonConverter, JsonConverter[] converters)   at CommonUtilities.JsonUtilities.GetJsonString(Object obj, Boolean useUTCDateJsonConverter)   at ForguncyDataAccess.DataAccess.AddQueryColumn(List`1 primaryKeyColumnIndexs, TableData tableData)   at ForguncyDataAccess.DataAccess.RemovePrimaryKeysColumnBindings(Int32 realColumnCount, List`1 columnBindingInfos, TableData tableData, List`1 primaryKeyColumnIndexs)   at ForguncyDataAccess.DataAccess.GetDetailDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct)   at ForguncyDataAccess.DataAccess.<>c__DisplayClass30_0.<<GetDetailDataTable>b__0>d.MoveNext()",        "RemoteStackTraceString": null,        "RemoteStackIndex": 0,        "ExceptionMethod": null,        "HResult": -2146233066,        "Source": "System.Private.CoreLib",        "WatsonBuckets": null      }    ]  }}CurrentMethodName: ExportToExcelThread

最佳答案

查看完整内容

老板,这个问题可能要通过demo才能具体的分析, 需要您附上一个可以复现问题的小demo和说明操作步骤。这样我们这边可以更好地理解您的问题,更好的帮助到您哦~

3 个回复

倒序浏览
最佳答案
最佳答案
Joe.xu讲师达人认证 悬赏达人认证 活字格认证
超级版主   /  发表于:2022-4-2 12:16:27
来自 4#
Zdaoyu 发表于 2022-4-2 15:14
设计器和服务器同样的报错,应该不是系统资源的问题

老板,这个问题可能要通过demo才能具体的分析
需要您附上一个可以复现问题的小demo和说明操作步骤。这样我们这边可以更好地理解您的问题,更好的帮助到您哦~
回复 使用道具 举报
嗷嗷叫
初级会员   /  发表于:2022-4-2 15:13:10
2#
从报错看,似乎是某个系统资源发生了溢出,你把工程文件发下,看能不能复现出来

你先把电脑重启下,说不定错误就没了
回复 使用道具 举报
Zdaoyu
金牌服务用户   /  发表于:2022-4-2 15:14:46
3#
嗷嗷叫 发表于 2022-4-2 15:13
从报错看,似乎是某个系统资源发生了溢出,你把工程文件发下,看能不能复现出来

你先把电脑重启下,说不 ...

设计器和服务器同样的报错,应该不是系统资源的问题
回复 使用道具 举报
您需要登录后才可以回帖 登录 | 立即注册
返回顶部