【7.0.104.0】导出出现这个，应该怎么解决呢

1. 在执行导出操作时，未知的异常出现。请再次尝试。
   
2. {
   
3.   "ClassName": "System.AggregateException",
   
4.   "Message": "One or more errors occurred.",
   
5.   "Data": null,
   
6.   "InnerException": {
   
7.     "$type": "System.InvalidCastException, System.Private.CoreLib",
   
8.     "ClassName": "System.InvalidCastException",
   
9.     "Message": "Specified cast is not valid.",
   
10.     "Data": null,
    
11.     "InnerException": null,
    
12.     "HelpURL": null,
    
13.     "StackTraceString": "   at Oracle.ManagedDataAccess.Client.OracleDataReader.GetDecimal(Int32 i)
    
14.    at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i)
    
15.    at Forguncy.DataSourceBase.FillTableAsync(String commandText, IEnumerable`1 parameters)
    
16.    at ForguncyDataAccess.DataAccess.a(String A_0, String A_1, DataBaseType A_2, DbParameter[] A_3)
    
17.    at ForguncyDataAccess.DataAccess.SelectAsync(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
    
18.    at Forguncy.Server2.b.SelectAsync(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
    
19.    at ForguncyDataAccess.DataAccess.GetDetailDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct)
    
20.    at ForguncyDataAccess.DataAccess.<>c__DisplayClass30_0.<<GetDetailDataTable>b__0>d.MoveNext()",
    
21.     "RemoteStackTraceString": null,
    
22.     "RemoteStackIndex": 0,
    
23.     "ExceptionMethod": null,
    
24.     "HResult": -2147467262,
    
25.     "Source": "Oracle.ManagedDataAccess",
    
26.     "WatsonBuckets": null
    
27.   },
    
28.   "HelpURL": null,
    
29.   "StackTraceString": "   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
    
30.    at Forguncy.Server2.Controllers.b.q(String A_0, String A_1)
    
31.    at Forguncy.Server2.Controllers.a.a(ListViewInfo A_0, Boolean A_1)
    
32.    at Forguncy.Server2.Controllers.a.e(GcExcelSheetWrapper A_0, List`1 A_1)
    
33.    at Forguncy.Server2.Controllers.a.b(Int32 A_0)
    
34.    at Forguncy.Server2.Controllers.a.c(Int32 A_0)
    
35.    at Forguncy.Server2.Controllers.a.a(Int32 A_0)
    
36.    at Forguncy.Server2.Controllers.a.a(Action`1 A_0)
    
37.    at Forguncy.Server2.Controllers.a.c(Boolean A_0)
    
38.    at Forguncy.Server2.Controllers.a.a(String A_0, List`1 A_1)
    
39.    at Forguncy.Server2.Controllers.HomeController.a(Object A_0)",
    
40.   "RemoteStackTraceString": null,
    
41.   "RemoteStackIndex": 0,
    
42.   "ExceptionMethod": null,
    
43.   "HResult": -2146233088,
    
44.   "Source": "System.Private.CoreLib",
    
45.   "WatsonBuckets": null,
    
46.   "InnerExceptions": {
    
47.     "$type": "System.Exception[], System.Private.CoreLib",
    
48.     "$values": [
    
49.       {
    
50.         "$type": "System.InvalidCastException, System.Private.CoreLib",
    
51.         "ClassName": "System.InvalidCastException",
    
52.         "Message": "Specified cast is not valid.",
    
53.         "Data": null,
    
54.         "InnerException": null,
    
55.         "HelpURL": null,
    
56.         "StackTraceString": "   at Oracle.ManagedDataAccess.Client.OracleDataReader.GetDecimal(Int32 i)
    
57.    at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i)
    
58.    at Forguncy.DataSourceBase.FillTableAsync(String commandText, IEnumerable`1 parameters)
    
59.    at ForguncyDataAccess.DataAccess.a(String A_0, String A_1, DataBaseType A_2, DbParameter[] A_3)
    
60.    at ForguncyDataAccess.DataAccess.SelectAsync(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
    
61.    at Forguncy.Server2.b.SelectAsync(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
    
62.    at ForguncyDataAccess.DataAccess.GetDetailDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct)
    
63.    at ForguncyDataAccess.DataAccess.<>c__DisplayClass30_0.<<GetDetailDataTable>b__0>d.MoveNext()",
    
64.         "RemoteStackTraceString": null,
    
65.         "RemoteStackIndex": 0,
    
66.         "ExceptionMethod": null,
    
67.         "HResult": -2147467262,
    
68.         "Source": "Oracle.ManagedDataAccess",
    
69.         "WatsonBuckets": null
    
70.       }
    
71.     ]
    
72.   }
    
73. }
    
74. 
    
75. CurrentMethodName: ExportToExcelThread

复制代码

光辉 发表于 2022-3-6 19:12
解决了 ，是因为小数点后面的位数太多。
视图里面的sql 限制一下小数位数就好了

恭喜楼主自己解决了问题，并且还主动分享后续遇到问题，欢迎继续发新帖交流哦~

光辉 发表于 2022-3-7 08:14
这怎么检查呀 ，我没有这个插件。然后  我别的导出没问题

您好，这个可能需要结合具体的工程文件才好分析问题，您可以附上一个能复现问题的小demo，这边具体帮您看一下哟~

鲁磊 发表于 2022-3-6 21:52
插件问题，检查一哈，我上次出现导出问题是用个一个个人插件叫多选插件

这怎么检查呀 ，我没有这个插件。然后  我别的导出没问题

插件问题，检查一哈，我上次出现导出问题是用个一个个人插件叫多选插件

解决了 ，是因为小数点后面的位数太多。
视图里面的sql 限制一下小数位数就好了