永洪社区

标题: 这个报错 sql重新 [打印本页]

作者: yhdata_lcIvgQYx 时间: 2023-4-18 11:08
标题: 这个报错 sql重新
执行数据失败： Related Dashboard: '预览: 门诊分析20230418110418-1703' Related Query: '门急诊就诊' Related Element: '图表2' Run user: 'yly' Caused by: java.sql.SQLException 执行SQL失败：“ERROR: Error during rewrite: Can't find rewrite due to 10120 AST node limit reached. Please check logs for additional information.QUERY: SELECT "Sub1__QryName"."Sum_门急诊人次同期" AS "Sum_门急诊人次同期", "Sub2__QryName"."Sum_门急诊人次" AS "Sum_门急诊人次" FROM ((SELECT SUM("mzjzrc") AS "Sum_门急诊人次同期" FROM "public"."TMzjzxxFt" WHERE "fyid" IN ('replaced_placeholder') AND "fyid" IN ('replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder') AND ("jzrq" >= 'replaced_placeholder' AND "jzrq" < 'replaced_placeholder'))) AS "Sub1__QryName" CROSS JOIN (SELECT SUM("mzjzrc") AS "Sum_门急诊人次" FROM "public"."TMzjzxxFt" WHERE "fyid" IN ('replaced_placeholder') AND "fyid" IN ('replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder') AND ("jzrq" >= 'replaced_placeholder' AND "jzrq" < 'replaced_placeholder')) AS "Sub2__QryName" LIMIT 5000000”

Can't find rewrite due to 10120 AST node limit reached 这个限制是永洪的还是其他的？

作者: yhdata_ruby 时间: 2023-4-18 13:37
工单跟进您的问题

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