ly1331 发表于 2021-11-28 09:55:10

AR15 Dokcer中使用日期条件查询异常

{"status":"Failed","completed":false,"error":"ERROR ERROR: date/time field value out of range: \"11/28/2021\";\nError while executing the query","errorCode":null,"errorData":[],"errorType":"OdbcException","stackTrace":"   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)\n   at GrapeCity.ActiveReports.Rendering.DataProcessing.RecordsAdapter.GetEnumerator()+MoveNext()\n   at GrapeCity.Enterprise.Data.DataEngine.Extensions.MemoizeEnumerableExtensions.MemoizedReadOnlyList`1.CacheItem()\n   at GrapeCity.Enterprise.Data.DataEngine.Extensions.MemoizeEnumerableExtensions.MemoizedReadOnlyList`1.GetEnumerator()+MoveNext()\n   at System.Linq.Enumerable.TryGetFirst(IEnumerable`1 source, Boolean& found)\n   at GrapeCity.ActiveReports.Core.Rendering.I.\uE1A4.\uE005(IList`1 finalizers, \uE1A3 buildCommandFn, DataParameter[] parameters, IDataSet dataSet, IExpressionContext expressionContext, CancellationToken token, IDictionary`2 recordSetsCache)\n   at GrapeCity.ActiveReports.Core.Rendering.I.\uE1A4.\uE004.\uE000(RecordSetKey key)\n   at GrapeCity.ActiveReports.Rendering.Tools.FuncExtensions.<>c__DisplayClass0_0`2.<Memoize>b__0(T x)\n   at GrapeCity.Enterprise.Data.DataEngine.DataProcessing.RecordSetProvider.GetDataSet(String name, DataParameter[] parameters)\n   at GrapeCity.Enterprise.Data.DataEngine.DataProcessing.DataProcessor.<>c__DisplayClass13_0.<MakeDataSetFn>b__2(ExecutionContext exc)\n   at System.Linq.Enumerable.SelectArrayIterator`2.ToArray()\n   at GrapeCity.Enterprise.Data.DataEngine.DataTree`1.Scope.get_Regions()\n   at GrapeCity.Enterprise.Data.DataEngine.DataProcessing.DataTreeGenerator.<>c__DisplayClass18_1.<MakeScopeFn>b__5()\n   at GrapeCity.Enterprise.Data.DataEngine.DataTree`1.Scope.get_Regions()\n   at GrapeCity.ActiveReports.Core.Rendering.I.\uE1BA.GetRegion(String name)\n   at GrapeCity.ActiveReports.Rendering.Components.RenderReportItemFactory.Create(IReportRenderingContext reportRenderingContext, ReportItem rdlItem, IDataScopeInternal currentDataContext)\n   at GrapeCity.ActiveReports.Core.Rendering.I.\uE1AA.\uE002.\uE000(ReportItem item)\n   at System.Linq.Enumerable.SelectIListIterator`2.MoveNext()\n   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()\n   at System.Linq.Enumerable.TryGetFirst(IEnumerable`1 source, Boolean& found)\n   at GrapeCity.ActiveReports.Core.Rendering.I.\uE0FF.BodyLayout(\uE12C context, IBody body, Object item, Size`1 contentSize, Nullable`1 size, Boolean consumeWhiteSpace, Nullable`1 isInFpl)\n   at GrapeCity.ActiveReports.Core.Rendering.I.\uE127.BuildPages(\uE12C context, Int32 limit)\n   at GrapeCity.ActiveReports.Core.Rendering.I.\uE127.\uE000.PagesLimited(Int32 limit)\n   at GrapeCity.ActiveReports.Export.Html.Page.Core.HtmlRendering.RenderInStreamingMode(IReport report, Func`2 getStream, HtmlSettings settings, CancellationToken cancel, Action`1 onComplete)\n   at GrapeCity.ActiveReports.Web.Viewer.I.\uE030.RenderHtmlView(Object document, Func`2 getOutStreamFn, \uE014 exportSettings, Action onPageReady)\n   at GrapeCity.ActiveReports.Web.Viewer.I.\uE00C.\uE002.\uE000(Task`1 task)"}
在windows下调试正常。这个问题怎么解决，没搜索到解决方法

James.Lv 发表于 2021-11-29 09:33:13

您好，您的demo能通过附件发上来不？我这边验证一下

ly1331 发表于 2021-12-7 14:53:04

换docker了，这个不需要解决了

Bella.Yuan 发表于 2021-12-7 14:59:20

ly1331 发表于 2021-12-7 14:53
换docker了，这个不需要解决了

好的:hjyzw:
页: [1]
查看完整版本: AR15 Dokcer中使用日期条件查询异常