执行数据失败： 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 这个限制是永洪的还是其他的？
|
