永洪社区

标题: 报告打开报发送MAP任务失败 [打印本页]

作者: caoguang 时间: 2022-6-6 10:12
标题: 报告打开报发送MAP任务失败
发送MAP任务失败：'10 智慧管理平台/工程建设管理/采购管理：真实数据集/qry_35150f54.场景9：采购价格分析表/blk.162e9b0d5b.zb'。

作者: Fiona 时间: 2022-6-6 10:27
把全部错误日志发过来看一下，从管理系统-日志管理里下载包含打开时间段的日志

作者: caoguang 时间: 2022-6-6 10:52
请帮忙查下，谢谢

作者: Fiona 时间: 2022-6-6 11:06
智慧管理平台/工程建设管理/接真实数据集/场景9：采购价格分析/历史采购价格分析v05_接真实数据集.db
看一下这个报告，哪个地方用了过滤，过滤字段和传的值类型不匹配

[2022-06-06 10:50:17.938] |-[WARN] |-[83223a307a144e7cbbf61cd240306e9f] |-[admin] |-[g5.io.IOUtil.writeInfo(IOUtil.java:605)] |-[DASHBOARD: [历史采购价格分析v05_接真实数据集20220606105013-815<智慧管理平台/工程建设管理/接真实数据集/场景9：采购价格分析/历史采购价格分析v05_接真实数据集.db>][汇总数量][ErrCode: 8192] Failed to write info: AndNode[g5.meta.AndNode@b1ae4ca, left:AndNode[g5.meta.AndNode@12eca3bb, left:BinaryNode[a:[DateCol<年_当前业务日期>], b:2022-05-01 00:00:00.0, op:<=], right:BinaryNode[a:[DateCol<年_当前业务日期>], b:2022-01-01 00:00:00.0, op:>=]], right:BinaryNode[a:[BCol<公司编码>], b:[-110, Z000001, Z000002, Z000003, Z000004, Z000006, Z000007, Z000008, Z000009, Z000014, Z000015, Z000017, Z000065, Z000068, Z000069, Z000070, Z000071, Z000072, Z000073, Z000074, Z000077, Z000078, Z000079, Z000081, Z000082, Z000083, Z000084, Z000085, Z000086, Z000087, Z000088, Z000089, Z000090, Z000091, Z000185, Z000186, Z000187, Z000188, Z000189, Z000190, Z000191, Z000192, Z000193, Z000194, Z000195, Z000196, Z000197, Z000198, Z000199, Z000200, Z000201, Z000202, Z000203, Z000204, Z000205, Z000206, Z000208, Z000212, Z000398, Z000399, Z000400, Z000402, Z000403, Z000404, Z000405, Z000406, Z000407, Z000408, Z000409, Z000410, Z000411, Z000413, Z000414, Z000415, Z000416, Z000418, Z000419, Z000420, Z000424, Z000425, Z000427, Z000428, Z000429, Z000448, Z000603, Z000654, Z000656, Z000657, Z000658, Z000659, Z000660, Z000661, Z000662, Z000663, Z000664, Z000665, Z000666, Z000667, Z000673, Z000759, Z000790, Z000791, Z000792, Z000793, Z000794, Z000795, Z000796, Z000797, Z000798, Z000799, Z000800, Z000805, Z000807, Z000808, Z000892, Z000893, Z000894, Z000912, Z000914, Z000915, Z000916, Z000917, Z000918, Z000919, Z000920, Z000921, Z000922, Z000923, Z000924, Z000925, Z000926, Z000927, Z000928, Z000931, Z000932, Z000933, Z000945, Z000947, Z000948, Z001095, Z001096, Z001100, Z001101, Z001103, Z001105, Z001106, Z001107, Z001108, Z001109, Z001110, Z001111, Z001112, Z001113, Z001114, Z001118, Z001119, Z001120, Z001122, Z001129, Z001131, Z001133, Z001134, Z001135, Z001137, Z001139, Z001140, Z001141, Z001142, Z001145, Z001146, Z001153, Z001159, Z001164, Z001165, Z001169, Z001171, Z001176, Z001178, Z001180, Z001181, Z001182, Z001184, Z001185, Z001186, Z001190, Z001192, Z001193, Z001198, Z001201, Z001202, Z001205, Z001206, Z001212, Z001213, Z001214, Z001216, Z001217, Z001218, Z001219, Z001221, Z001222, Z001223, Z001224, Z001225, Z001226, Z001227, Z001228, Z001229, Z001230, Z001231, Z001232, Z001233, Z001235, Z001237, Z001239, Z001240, Z001241, Z001242, Z001243, Z001244, Z001245, Z001246, Z001247, Z001253, Z001254, Z001255, Z001256, Z001257, Z001258, Z001260, Z001261, Z001264, Z001265, Z001266, Z001267, Z001268, Z001269, Z001270, Z001271, Z001327, Z001328, Z001329, Z001330, Z001331, Z001332, Z001333, Z001334, Z001404, Z001476, Z001478, Z001479, Z001482, Z002365, Z002366, Z002367, Z002368, Z002369, Z002370, Z002372, Z002427, Z002429, Z002430, Z002431, Z002433, Z002434, Z002435, Z002436, Z002437, Z002438, Z002439, Z002446, Z002452, Z002459, Z002460, Z002465, Z002466, Z002474, Z002553, Z002554, Z002560, Z002565, Z002568, Z002606, Z002607, Z002608, Z002609, Z002620, Z002622, Z002624, Z002626, Z002629, Z002634, Z002635, Z002637, Z002646, Z002648, Z002654, Z002661, Z002676, Z002677, Z002689, Z002690, Z002692, Z002696, Z002697, Z002698, Z002707, Z002708, Z002709, Z002710, Z002712, Z002713, Z002717, Z002719, Z002721, Z002724, Z002827, Z002828, Z002829, Z002830, Z002831, Z002832, Z002833, Z002834, Z002838, Z002843, Z002844, Z002845, Z002849, Z002851, Z002855, Z002857, Z002878, Z002883, Z002886, Z002889, Z002890, Z002892, Z002893, Z002902, Z002950, Z002953, Z002955, Z003003, Z003004, Z003060, Z003061, Z003062, Z003063, Z003064, Z003067, Z003071, Z003072, Z003073, Z003074, Z003083, Z003085, Z003087, Z003089, Z003094, Z003095, Z003106, Z003114, Z003117, Z003118, Z003131, Z003132, Z003134, Z003157, Z003159, Z003160, Z003161, Z003181, Z003195, Z003197, Z003240, Z003269, Z003270, Z003280, Z003307, Z003308, Z003319, Z003331, Z003332, Z003333, Z003334, Z003335, Z003336, Z003337, Z003339, Z003352, Z003361, Z003364, Z003371, Z003381, Z003382, Z003388, Z003389, Z003390, Z003392, Z003416, Z003453, Z003469, Z003470, Z003474, Z003475, Z003476, Z003477, Z003478, Z003479], op:IN]], error: 发现不支持的类型：“class java.sql.Timestamp”。]
g5.util.GRTException: 发现不支持的类型：“class java.sql.Timestamp”。
at g5.Info$InfoMap.getType(Info.java:206) ~[product-20211224.jar:?]
at g5.Info$InfoMap.addObject(Info.java:264) ~[product-20211224.jar:?]
at g5.meta.BinaryNode.writeMap(BinaryNode.java:599) ~[product-20211224.jar:?]
at g5.BInfo.writeData(BInfo.java:109) ~[product-20211224.jar:?]
at g5.BInfo.writeValue(BInfo.java:228) ~[product-20211224.jar:?]
at g5.BInfo.writeData(BInfo.java:118) ~[product-20211224.jar:?]
at g5.BInfo.writeValue(BInfo.java:228) ~[product-20211224.jar:?]
at g5.BInfo.writeData(BInfo.java:118) ~[product-20211224.jar:?]
at g5.io.IOUtil.writeInfo(IOUtil.java:600) [product-20211224.jar:?]
at g5.dc.data.mr.MRAggrQuery.tlength(MRAggrQuery.java:620) [product-20211224.jar:?]
at g5.dc.data.mr.MapQueryTask.tlength(MapQueryTask.java:242) [product-20211224.jar:?]
at g5.dc.mr.GMRTask.deepClone(GMRTask.java:421) [product-20211224.jar:?]
at g5.dc.mr.c.MapCProc.<init>(MapCProc.java:33) [product-20211224.jar:?]
at g5.dc.mr.impl.MRUtil.sendM(MRUtil.java:313) [product-20211224.jar:?]
at g5.dc.mr.impl.MRUtil.assignM(MRUtil.java:240) [product-20211224.jar:?]
at g5.dc.mr.impl.MRUtil.assignM(MRUtil.java:196) [product-20211224.jar:?]
at g5.dc.mr.s.GetPlan2SProc.proc0(GetPlan2SProc.java:93) [product-20211224.jar:?]
at g5.rpc.s.SProc.proc(SProc.java:163) [product-20211224.jar:?]
at g5.rpc.c.CProc.proc(CProc.java:105) [product-20211224.jar:?]
at g5.dc.mr.s.GetPlanSProc.handleData(GetPlanSProc.java:118) [product-20211224.jar:?]
at g5.rpc.s.RepeatSProc.proc0(RepeatSProc.java:62) [product-20211224.jar:?]
at g5.rpc.s.SProc.proc(SProc.java:163) [product-20211224.jar:?]
at g5.rpc.c.CProc.proc(CProc.java:105) [product-20211224.jar:?]
at g5.dc.mr.GJob.exec(GJob.java:189) [product-20211224.jar:?]
at g5.gqry.MaterialGQuery.getPreGrid1(MaterialGQuery.java:402) [product-20211224.jar:?]
at g5.gqry.GQuery.getPreGrid0(GQuery.java:1478) [product-20211224.jar:?]
at g5.gqry.GQuery.getPreGrid(GQuery.java:1601) [product-20211224.jar:?]
at g5.gqry.GQuery.getGrid0(GQuery.java:1240) [product-20211224.jar:?]
at g5.gqry.GQuery.getGrid(GQuery.java:1192) [product-20211224.jar:?]
at g5.gqry.exec.AExecutor.createBase(AExecutor.java:481) [product-20211224.jar:?]
at g5.gqry.exec.AggrCalcExecutor.getGrid(AggrCalcExecutor.java:64) [product-20211224.jar:?]
at g5.aqry.comp.DefBaseExecutor.getGrid(DefBaseExecutor.java:36) [product-20211224.jar:?]
at g5.aqry.AQuery.initGrid0(AQuery.java:761) [product-20211224.jar:?]
at g5.aqry.AQuery.initGrid(AQuery.java:682) [product-20211224.jar:?]
at g5.aqry.AQuery.getGrid0(AQuery.java:661) [product-20211224.jar:?]
at g5.aqry.AQuery.getGrid(AQuery.java:632) [product-20211224.jar:?]
at g5.aqry.AQryInfo.getGrid(AQryInfo.java:146) [product-20211224.jar:?]
at g5.aqry.load.QueryInfoLoad.preload0(QueryInfoLoad.java:34) [product-20211224.jar:?]
at g5.grid.load.GridLoad.preload(GridLoad.java:43) [product-20211224.jar:?]
at g5.grid.load.GridLoadMgr$PreLoad.run(GridLoadMgr.java:134) [product-20211224.jar:?]
at g5.grid.load.GridLoadMgr$PreLoadThread.run0(GridLoadMgr.java:174) [product-20211224.jar:?]
at g5.thread.GThread.run(GThread.java:199) [product-20211224.jar:?]

作者: caoguang 时间: 2022-6-6 14:53
方便确认到哪一个字段吗

作者: caoguang 时间: 2022-6-6 14:54
或者确认到哪一个图表

作者: Fiona 时间: 2022-6-6 15:10
您看看有个“汇总数量”的组件

作者: yhdata_yzm 时间: 2022-6-6 15:36
方便确认哪个字段吗

作者: yhdata_1bnSuCGr 时间: 2022-6-6 15:36
挺好的

作者: Fiona 时间: 2022-6-6 15:42

yhdata_Fg5ikqHT 发表于 2022-6-6 15:36
方便确认哪个字段吗

您看看这个组件上有没有过滤，或这个组件依赖的数据集上有没有过滤。字段是：年_当前业务日

作者: yhdata_yzm 时间: 2022-6-6 16:48

Fiona 发表于 2022-6-6 15:42
您看看这个组件上有没有过滤，或这个组件依赖的数据集上有没有过滤。字段是：年_当前业务日 ...

你的日期类型能给我举个咧吗

作者: caoguang 时间: 2022-6-10 11:39
目前已解决，正式环境用了集市，清除了集市的数据就是OK的，但为什么产生这个原因，暂时不清楚

作者: caoguang 时间: 2022-6-10 11:40

Fiona 发表于 2022-6-6 15:42
您看看这个组件上有没有过滤，或这个组件依赖的数据集上有没有过滤。字段是：年_当前业务日 ...

目前已解决，正式环境用了集市，清除了集市的数据就是OK的，但为什么产生这个原因，暂时不清楚

作者: yhdata_yzm 时间: 2022-6-10 13:09

caoguang 发表于 2022-6-10 11:40
目前已解决，正式环境用了集市，清除了集市的数据就是OK的，但为什么产生这个原因，暂时不清楚 ...

后续我们会关注这个问题的

欢迎光临永洪社区 (https://club.yonghongtech.com/)