麦粉社区
>
帖子详情

数据预览出错问题

数据准备 发表于 2024-3-13 10:08
发表于 2024-3-13 10:08:20

数据准备中:


1、添加数据源表后,最下方的预览数据,可以正常查看各字段内容,如下图1截图。



2、但是,在数据模型处点击预览数据按钮进入,勾选想要的字段进行预览时,提示查询失败,如下图



请问,这种应该如何处理?

发表于 2024-3-13 13:37:18
把完整的错误日志贴上来看看
  •   梅
    version:	2023-12-08 19:56:21
    packageinfo:	Hotfix_SmartbiV11_20231206 
    
    
    查询失败:errorMessageMondrian Error:mondrian.olap.MondrianException: Mondrian Error:Failed to load segment form SQL
    errorStackTrace=mondrian.olap.MondrianException: Mondrian Error:mondrian.olap.MondrianException: Mondrian Error:Failed to load segment form SQL
    	at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:201)
    	at mondrian.rolap.agg.SegmentLoader.access$000(SegmentLoader.java:60)
    	at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:158)
    	at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:137)
    	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    	at java.lang.Thread.run(Thread.java:748)
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to load segment form SQL
    	at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:534)
    	at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:177)
    	... 7 more
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select `T0`.`立项批复时间` as `c0`, `T0`.`可研批复时间` as `c1`, `T0`.`关闭计划(月份)` as `c2`, count(1) as `m0` from `bc_base_client`.`项目明细表` as `T0` where `T0`.`立项批复时间` in ('', '2021-01-02 14:28:04.0', '2021-03-24 00:30:15.0', '2021-04-12 23:29:15.0', '2021-04-14 12:29:20.0', '2021-04-15 15:03:28.0', '2021-04-16 17:30:52.0', '2021-04-16 17:31:09.0', '2021-04-16 17:42:48.0', '2021-04-21 10:41:27.0', '2021-04-21 10:42:07.0', '2021-04-23 15:46:11.0', '2021-04-27 08:17:29.0', '2021-05-08 11:11:20.0', '2021-05-12 22:00:04.0', '2021-05-14 11:09:26.0', '2021-05-16 16:55:29.0', '2021-05-17 09:53:29.0', '2021-05-18 23:18:11.0', '2021-05-20 20:40:05.0', '2021-05-21 09:29:31.0', '2021-05-24 15:13:37.0', '2021-05-25 08:37:08.0', '2021-05-25 14:09:42.0', '2021-05-25 15:17:36.0', '2021-05-25 16:50:32.0', '2021-05-25 17:06:18.0', '2021-05-25 18:11:51.0', '2021-05-26 17:22:52.0', '2021-05-27 12:22:53.0', '2021-06-03 15:51:30.0', '2021-06-05 11:50:55.0', '2021-06-07 16:02:16.0', '2021-06-08 16:21:09.0', '2021-06-11 10:18:16.0', '2021-06-14 13:03:02.0', '2021-06-21 16:02:58.0', '2021-06-21 19:44:28.0', '2021-06-23 16:44:12.0', '2021-06-24 22:41:14.0', '2021-07-06 17:55:29.0', '2021-07-07 09:49:24.0', '2021-07-07 17:29:05.0', '2021-07-07 17:31:23.0', '2021-07-08 16:23:27.0', '2021-07-15 16:02:32.0', '2021-07-16 09:14:41.0', '2021-07-16 20:54:12.0', '2021-07-19 14:26:18.0', '2021-07-19 19:33:27.0', '2021-07-19 19:34:41.0', '2021-07-26 10:30:40.0', '2021-07-26 10:35:06.0', '2021-07-26 10:38:37.0', '2021-07-26 10:41:34.0', '2021-07-26 15:54:48.0', '2021-07-26 16:13:52.0', '2021-07-27 11:06:57.0', '2021-07-27 11:07:36.0', '2021-07-27 11:07:56.0', '2021-07-27 11:08:35.0', '2021-07-27 11:09:07.0', '2021-07-31 16:26:46.0', '2021-08-09 15:51:08.0', '2021-08-10 17:33:54.0', '2021-08-12 12:30:32.0', '2021-08-12 22:11:29.0', '2021-08-18 10:11:45.0', '2021-08-23 16:54:33.0', '2021-08-25 16:05:22.0', '2021-08-29 19:19:50.0', '2021-09-09 17:18:10.0', '2021-09-11 20:36:54.0', '2021-09-11 20:37:20.0', '2021-09-15 11:50:18.0', '2021-09-18 16:24:39.0', '2021-09-22 22:49:07.0', '2021-09-25 20:26:05.0', '2021-09-26 17:15:49.0', '2021-10-07 14:46:53.0', '2021-10-21 16:51:56.0', '2021-10-22 14:07:04.0', '2021-10-22 18:00:44.0', '2021-10-27 15:45:12.0', '2021-10-29 17:54:41.0', '2021-11-03 19:28:25.0', '2021-11-03 20:05:40.0', '2021-11-03 20:07:57.0', '2021-11-09 08:48:39.0', '2021-11-09 16:58:38.0', '2021-11-09 16:59:21.0', '2021-11-19 14:48:53.0', '2021-11-19 14:49:14.0', '2021-11-22 16:38:01.0', '2021-11-23 22:13:02.0', '2021-11-23 22:13:15.0', '2021-11-23 22:13:29.0', '2021-11-23 22:13:42.0', '2021-11-23 22:13:56.0', '2021-11-24 10:50:56.0', '2021-11-24 12:16:10.0', '2021-11-24 14:05:40.0', '2021-11-24 14:06:51.0', '2021-11-24 14:09:09.0', '2021-11-24 14:09:52.0', '2021-11-24 14:10:42.0', '2021-11-25 08:57:33.0', '2021-11-25 13:56:29.0', '2021-11-25 15:13:16.0', '2021-11-25 15:13:38.0', '2021-11-25 15:14:00.0', '2021-11-25 21:50:03.0', '2021-11-25 21:50:46.0', '2021-11-29 08:58:32.0', '2021-11-29 20:06:38.0', '2021-11-30 09:56:22.0', '2021-11-30 10:55:55.0', '2021-11-30 10:56:15.0', '2021-11-30 11:06:54.0', '2021-11-30 11:07:15.0', '2021-11-30 11:07:36.0', '2021-11-30 11:11:46.0', '2021-11-30 11:12:06.0', '2021-11-30 11:12:30.0', '2021-11-30 11:12:47.0', '2021-11-30 11:13:25.0', '2021-11-30 11:14:03.0', '2021-11-30 11:14:23.0', '2021-11-30 11:44:52.0', '2021-12-01 17:51:26.0', '2021-12-01 23:27:27.0', '2021-12-01 23:27:59.0', '2021-12-01 23:28:12.0', '2021-12-02 11:51:48.0', '2021-12-02 11:52:00.0', '2021-12-02 11:52:17.0', '2021-12-02 11:52:34.0', '2021-12-02 11:52:53.0', '2021-12-02 11:53:11.0', '2021-12-02 11:53:22.0', '2021-12-02 11:53:42.0', '2021-12-06 09:04:08.0', '2021-12-06 09:04:29.0', '2021-12-06 14:07:24.0', '2021-12-06 14:07:46.0', '2021-12-06 14:14:08.0', '2021-12-06 14:47:12.0', '2021-12-06 14:47:33.0', '2021-12-06 15:12:15.0', '2021-12-06 16:37:51.0', '2021-12-06 16:51:32.0', '2021-12-06 16:51:52.0', '2021-12-06 16:52:11.0', '2021-12-06 16:52:30.0', '2021-12-06 16:52:49.0', '2021-12-06 17:29:00.0', '2021-12-06 17:29:25.0', '2021-12-06 17:30:42.0', '2021-12-06 17:31:07.0', '2021-12-06 17:31:29.0', '2021-12-07 15:06:05.0', '2021-12-07 15:15:35.0', '2021-12-07 16:45:10.0', '2021-12-07 16:47:53.0', '2021-12-07 20:34:00.0', '2021-12-07 20:34:43.0', '2021-12-08 15:31:18.0', '2021-12-08 15:31:43.0', '2021-12-08 20:27:11.0', '2021-12-08 20:28:48.0', '2021-12-09 23:56:44.0', '2021-12-10 02:19:48.0', '2021-12-10 02:21:07.0', '2021-12-10 11:29:03.0', '2021-12-10 14:28:10.0', '2021-12-10 15:22:24.0', '2021-12-13 09:20:15.0', '2021-12-13 11:18:37.0', '2021-12-13 11:41:28.0', '2021-12-13 11:47:43.0', '2021-12-13 14:33:36.0', '2021-12-13 14:47:20.0', '2021-12-13 16:31:05.0', '2021-12-13 16:32:12.0', '2021-12-14 11:49:33.0', '2021-12-14 11:49:53.0', '2021-12-14 11:50:58.0', '2021-12-14 11:51:13.0', '2021-12-14 13:34:04.0', '2021-12-14 17:02:42.0', '2021-12-14 21:50:27.0', '2021-12-14 21:50:41.0', '2021-12-14 21:50:52.0', '2021-12-14 21:51:05.0', '2021-12-14 21:51:17.0', '2021-12-14 21:51:31.0', '2021-12-14 21:51:45.0', '2021-12-14 21:51:56.0', '2021-12-15 16:57:06.0', '2021-12-15 21:03:56.0', '2021-12-15 21:04:06.0', '2021-12-16 10:53:57.0', '2021-12-16 10:54:33.0', '2021-12-16 20:35:15.0', '2021-12-17 08:19:18.0', '2021-12-17 16:15:08.0', '2021-12-17 17:45:28.0', '2021-12-17 17:47:20.0', '2021-12-18 18:08:22.0', '2021-12-18 18:49:44.0', '2021-12-20 16:49:28.0', '2021-12-20 18:40:53.0', '2021-12-21 09:51:25.0', '2021-12-22 15:15:54.0', '2021-12-22 17:54:36.0', '2021-12-22 17:54:58.0', '2021-12-22 17:55:24.0', '2021-12-23 16:32:12.0', '2021-12-24 15:42:07.0', '2021-12-24 15:42:27.0', '2021-12-24 15:42:54.0', '2021-12-24 17:08:23.0', '2021-12-27 09:01:51.0', '2021-12-27 09:03:03.0', '2021-12-27 09:04:04.0', '2021-12-27 09:06:05.0', '2021-12-27 09:06:49.0', '2021-12-27 09:07:17.0', '2021-12-27 09:07:58.0', '2021-12-27 09:08:26.0', '2021-12-27 09:08:49.0', '2021-12-27 09:09:17.0', '2021-12-27 09:09:39.0', '2021-12-27 09:10:11.0', '2021-12-27 10:43:40.0', '2021-12-28 09:54:37.0', '2021-12-29 16:35:30.0', '2021-12-30 16:16:31.0', '2021-12-31 10:12:44.0', '2022-01-03 13:41:48.0', '2022-01-04 14:38:50.0', '2022-01-04 15:51:03.0', '2022-01-04 15:51:35.0', '2022-01-04 15:51:56.0', '2022-01-07 14:28:57.0', '2022-01-10 15:07:22.0', '2022-01-10 15:08:13.0', '2022-01-11 11:21:32.0', '2022-01-11 11:34:14.0', '2022-01-11 14:04:33.0', '2022-01-12 08:30:02.0', '2022-01-12 16:11:17.0', '2022-01-13 08:34:28.0', '2022-01-13 14:23:09.0', '2022-01-13 14:23:40.0', '2022-01-14 16:39:51.0', '2022-01-17 18:16:47.0', '2022-01-17 18:21:50.0', '2022-01-18 16:38:59.0', '2022-01-20 08:03:19.0', '2022-01-20 08:03:42.0', '2022-01-20 08:04:05.0', '2022-01-20 11:47:09.0', '2022-01-20 15:18:01.0', '2022-01-20 15:22:14.0', '2022-01-20 15:22:39.0', '2022-01-20 15:23:17.0', '2022-01-22 09:29:32.0', '2022-01-24 09:05:07.0', '2022-01-25 13:41:38.0', '2022-01-25 14:25:35.0', '2022-01-26 15:37:18.0', '2022-01-26 17:39:17.0', '2022-01-27 17:16:31.0', '2022-01-27 17:22:59.0', '2022-01-28 11:34:09.0', '2022-02-08 10:46:26.0', '2022-02-11 11:40:16.0', '2022-02-18 08:59:10.0', '2022-02-22 11:04:44.0', '2022-02-22 17:25:47.0', '2022-02-22 17:39:10.0', '2022-02-23 16:57:38.0', '2022-02-23 20:59:21.0', '2022-02-25 10:13:26.0', '2022-02-25 10:13:50.0', '2022-02-25 14:40:35.0', '2022-02-25 17:13:25.0', '2022-02-25 18:50:09.0', '2022-02-25 22:29:51.0', '2022-02-25 22:31:25.0', '2022-02-25 22:41:58.0', '2022-02-25 22:45:34.0', '2022-02-25 22:46:26.0', '2022-02-25 22:49:33.0', '2022-02-25 22:52:26.0', '2022-02-28 10:47:25.0', '2022-02-28 21:17:47.0', '2022-02-28 21:22:36.0', '2022-03-01 12:42:50.0', '2022-03-01 15:08:23.0', '2022-03-01 15:08:33.0', '2022-03-01 17:21:44.0', '2022-03-02 09:02:08.0', '2022-03-02 14:11:52.0', '2022-03-02 18:30:33.0', '2022-03-02 18:49:17.0', '2022-03-03 14:41:40.0', '2022-03-03 16:29:04.0', '2022-03-03 17:01:13.0', '2022-03-03 19:02:10.0', '2022-03-04 10:40:31.0', '2022-03-04 16:32:42.0', '2022-03-04 16:49:19.0', '2022-03-04 17:13:56.0', '2022-03-07 08:55:17.0', '2022-03-07 10:33:53.0', '2022-03-07 10:43:49.0', '2022-03-07 12:44:41.0', '2022-03-07 13:26:48.0', '2022-03-07 13:28:19.0', '2022-03-07 13:28:40.0', '2022-03-07 13:29:21.0', '2022-03-07 16:22:23.0', '2022-03-07 16:24:38.0', '2022-03-07 16:26:41.0', '2022-03-08 10:18:43.0', '2022-03-08 13:53:18.0', '2022-03-08 14:47:13.0', '2022-03-08 14:51:13.0', '2022-03-08 16:26:43.0', '2022-03-08 16:28:02.0', '2022-03-08 17:47:47.0', '2022-03-09 11:24:26.0', '2022-03-09 11:34:04.0', '2022-03-09 17:15:18.0', '2022-03-09 17:20:18.0', '2022-03-09 17:26:57.0', '2022-03-09 18:01:53.0', '2022-03-10 09:54:04.0', '2022-03-10 10:51:47.0', '2022-03-10 12:38:03.0', '2022-03-10 12:38:29.0', '2022-03-10 12:38:52.0', '2022-03-10 12:45:56.0', '2022-03-10 14:12:52.0', '2022-03-10 14:14:32.0', '2022-03-10 14:18:01.0', '2022-03-10 14:32:22.0', '2022-03-10 15:09:27.0', '2022-03-10 15:18:58.0', '2022-03-10 15:24:31.0', '2022-03-10 16:15:19.0', '2022-03-10 16:20:34.0', '2022-03-10 16:24:04.0', '2022-03-10 16:44:53.0', '2022-03-10 17:15:58.0', '2022-03-10 17:50:15.0', '2022-03-10 17:50:44.0', '2022-03-10 18:09:16.0', '2022-03-11 09:36:14.0', '2022-03-11 09:51:55.0', '2022-03-11 09:56:15.0', '2022-03-11 11:29:11.0', '2022-03-11 11:55:09.0', '2022-03-11 18:11:29.0', '2022-03-14 08:49:15.0', '2022-03-14 08:49:41.0', '2022-03-14 08:50:07.0', '2022-03-14 11:57:55.0', '2022-03-14 11:58:13.0', '2022-03-14 11:58:32.0', '2022-03-14 11:58:51.0', '2022-03-14 12:00:03.0', '2022-03-14 15:54:37.0', '2022-03-14 16:27:30.0', '2022-03-14 16:47:18.0', '2022-03-14 16:48:50.0', '2022-03-14 19:35:12.0', '2022-03-15 11:44:14.0', '2022-03-15 12:53:21.0', '2022-03-15 14:11:31.0', '2022-03-15 14:14:58.0', '2022-03-15 14:18:53.0', '2022-03-15 15:19:30.0', '2022-03-15 15:23:40.0', '2022-03-15 15:24:24.0', '2022-03-15 15:24:57.0', '2022-03-15 15:25:25.0', '2022-03-15 15:28:11.0', '2022-03-15 16:59:29.0', '2022-03-15 16:59:52.0', '2022-03-16 09:19:14.0', '2022-03-16 09:32:57.0', '2022-03-16 10:52:26.0', '2022-03-16 16:37:46.0', '2022-03-16 16:43:07.0', '2022-03-16 16:44:05.0', '2022-03-16 17:52:14.0', '2022-03-17 14:48:58.0', '2022-03-17 15:00:37.0', '2022-03-17 15:03:17.0', '2022-03-17 18:59:23.0', '2022-03-18 09:19:09.0', '2022-03-18 09:19:21.0', '2022-03-18 11:24:58.0', '2022-03-21 14:51:34.0', '2022-03-21 17:52:15.0', '2022-03-21 19:48:26.0', '2022-03-22 10:19:27.0', '2022-03-22 10:44:35.0', '2022-03-22 10:49:22.0', '2022-03-22 10:58:01.0', '2022-03-22 11:07:35.0', '2022-03-22 16:01:33.0', '2022-03-22 16:27:45.0', '2022-03-22 17:04:50.0', '2022-03-22 17:28:29.0', '2022-03-22 17:30:04.0', '2022-03-22 17:34:48.0', '2022-03-22 19:20:16.0', '2022-03-24 09:16:36.0', '2022-03-24 09:17:24.0', '2022-03-24 09:32:16.0', '2022-03-24 09:32:59.0', '2022-03-24 09:33:44.0', '2022-03-24 09:37:35.0', '2022-03-24 09:52:52.0', '2022-03-24 10:09:54.0', '2022-03-24 15:46:19.0', '2022-03-24 16:27:14.0', '2022-03-24 16:27:20.0', '2022-03-24 16:39:48.0', '2022-03-24 17:39:25.0', '2022-03-25 08:29:19.0', '2022-03-25 15:05:37.0', '2022-03-25 16:59:14.0', '2022-03-25 17:01:34.0', '2022-03-25 17:20:43.0', '2022-03-28 09:13:03.0', '2022-03-28 09:34:58.0', '2022-03-28 09:36:40.0', '2022-03-28 09:39:42.0', '2022-03-28 09:40:52.0', '2022-03-28 09:41:43.0', '2022-03-28 09:46:01.0', '2022-03-28 09:48:15.0', '2022-03-28 09:48:54.0', '2022-03-28 11:56:38.0', '2022-03-29 09:13:40.0', '2022-03-29 09:14:56.0', '2022-03-29 10:12:22.0', '2022-03-29 16:03:01.0', '2022-03-29 16:03:14.0', '2022-03-29 16:03:26.0', '2022-03-29 16:03:34.0', '2022-03-29 16:03:42.0', '2022-03-29 16:36:23.0', '2022-03-29 16:36:42.0', '2022-03-29 16:37:02.0', '2022-03-29 16:37:21.0', '2022-03-29 16:37:41.0', '2022-03-29 16:38:01.0', '2022-03-29 16:38:21.0', '2022-03-29 17:18:34.0', '2022-03-29 18:02:09.0', '2022-03-29 19:11:25.0', '2022-03-30 09:49:53.0', '2022-03-30 10:40:52.0', '2022-03-30 15:08:26.0', '2022-03-30 19:16:27.0', '2022-03-31 11:15:53.0', '2022-03-31 11:24:58.0', '2022-03-31 17:37:01.0', '2022-04-01 11:30:03.0', '2022-04-02 08:50:53.0', '2022-04-02 10:49:46.0', '2022-04-02 15:12:08.0', '2022-04-02 16:18:05.0', '2022-04-02 17:55:10.0', '2022-04-06 09:23:37.0', '2022-04-06 09:26:47.0', '2022-04-06 09:34:28.0', '2022-04-11 08:49:49.0', '2022-04-11 10:34:20.0', '2022-04-13 17:55:48.0', '2022-04-13 18:05:21.0', '2022-04-13 20:59:53.0', '2022-04-15 16:39:25.0', '2022-04-15 16:42:13.0', '2022-04-19 18:23:44.0', '2022-04-20 16:41:30.0', '2022-04-20 16:43:27.0', '2022-04-21 14:17:52.0', '2022-04-21 14:18:07.0', '2022-04-21 16:41:04.0', '2022-04-21 17:54:08.0', '2022-04-22 14:41:23.0', '2022-04-22 14:43:09.0', '2022-04-24 14:14:43.0', '2022-04-24 18:57:26.0', '2022-04-25 11:45:55.0', '2022-04-25 11:46:11.0', '2022-04-26 08:39:58.0', '2022-04-26 08:40:26.0', '2022-04-26 08:40:51.0', '2022-04-26 09:21:10.0', '2022-04-26 09:46:13.0', '2022-04-26 16:34:49.0', '2022-04-27 09:40:45.0', '2022-04-27 09:45:33.0', '2022-04-27 16:15:01.0', '2022-04-27 17:05:55.0', '2022-04-27 17:57:40.0', '2022-04-29 09:26:30.0', '2022-04-29 11:31:50.0', '2022-04-29 11:36:00.0', '2022-04-29 15:45:35.0', '2022-04-29 16:30:00.0', '2022-04-29 16:44:25.0', '2022-05-05 08:26:53.0', '2022-05-05 11:22:10.0', '2022-05-05 11:35:16.0', '2022-05-05 12:09:56.0', '2022-05-05 13:07:28.0', '2022-05-06 09:10:00.0', '2022-05-07 14:22:01.0', '2022-05-09 14:13:58.0', '2022-05-10 15:23:31.0', '2022-05-10 15:25:30.0', '2022-05-10 20:13:58.0', '2022-05-10 20:22:35.0', '2022-05-12 14:05:14.0', '2022-05-13 09:21:51.0', '2022-05-13 15:31:50.0', '2022-05-15 18:26:24.0', '2022-05-16 16:08:45.0', '2022-05-16 17:58:49.0', '2022-05-16 20:04:11.0', '2022-05-18 11:42:03.0', '2022-05-19 08:54:26.0', '2022-05-19 17:33:21.0', '2022-05-19 19:06:59.0', '2022-05-20 08:24:39.0', '2022-05-20 08:25:01.0', '2022-05-20 08:25:24.0', '2022-05-20 10:47:32.0', '2022-05-22 13:29:31.0', '2022-05-22 13:30:02.0', '2022-05-22 13:30:44.0', '2022-05-22 13:31:22.0', '2022-05-22 13:35:24.0', '2022-05-22 13:36:40.0', '2022-05-22 13:37:09.0', '2022-05-22 13:38:21.0', '2022-05-22 13:38:50.0', '2022-05-22 13:39:14.0', '2022-05-22 21:27:08.0', '2022-05-22 21:27:27.0', '2022-05-22 22:20:41.0', '2022-05-23 10:04:04.0', '2022-05-23 10:04:40.0', '2022-05-23 10:05:09.0', '2022-05-23 11:13:13.0', '2022-05-23 12:47:58.0', '2022-05-23 14:14:00.0', '2022-05-23 14:14:29.0', '2022-05-23 18:52:43.0', '2022-05-24 09:23:45.0', '2022-05-24 09:41:57.0', '2022-05-24 10:09:33.0', '2022-05-24 10:15:32.0', '2022-05-24 10:15:55.0', '2022-05-24 12:40:00.0', '2022-05-24 16:44:58.0', '2022-05-25 11:33:59.0', '2022-05-25 11:34:28.0', '2022-05-25 11:47:15.0', '2022-05-26 11:31:16.0', '2022-05-26 11:31:40.0', '2022-05-26 11:32:04.0', '2022-05-26 15:22:04.0', '2022-05-27 16:59:07.0', '2022-05-27 17:56:10.0', '2022-05-27 18:16:11.0', '2022-05-27 18:16:25.0', '2022-05-27 18:16:48.0', '2022-05-27 18:17:08.0', '2022-05-27 18:17:19.0', '2022-05-27 18:17:31.0', '2022-05-27 18:17:42.0', '2022-05-27 18:17:57.0', '2022-05-27 18:18:11.0', '2022-05-27 18:25:47.0', '2022-05-30 14:32:27.0', '2022-05-30 17:22:29.0', '2022-05-31 10:51:59.0', '2022-05-31 10:52:30.0', '2022-05-31 13:56:51.0', '2022-05-31 14:43:40.0', '2022-05-31 15:15:09.0', '2022-05-31 16:26:56.0', '2022-06-01 12:12:43.0', '2022-06-01 15:06:59.0', '2022-06-01 15:47:23.0', '2022-06-01 15:48:30.0', '2022-06-01 15:48:56.0', '2022-06-01 16:31:56.0', '2022-06-01 18:21:08.0', '2022-06-01 19:26:19.0', '2022-06-01 19:26:29.0', '2022-06-01 19:26:38.0', '2022-06-02 09:19:21.0', '2022-06-02 09:26:40.0', '2022-06-02 14:03:41.0', '2022-06-02 14:30:41.0', '2022-06-02 16:36:28.0', '2022-06-03 10:53:57.0', '2022-06-06 08:18:49.0', '2022-06-06 09:52:56.0', '2022-06-06 11:43:04.0', '2022-06-06 14:55:21.0', '2022-06-06 16:49:06.0', '2022-06-06 16:51:28.0', '2022-06-06 16:53:06.0', '2022-06-06 16:53:40.0', '2022-06-06 16:59:55.0', '2022-06-06 17:02:18.0', '2022-06-06 18:30:57.0', '2022-06-07 09:10:52.0', '2022-06-07 09:34:30.0', '2022-06-07 16:27:29.0', '2022-06-07 16:27:55.0', '2022-06-07 17:10:31.0', '2022-06-07 17:10:52.0', '2022-06-07 17:11:14.0', '2022-06-08 14:37:55.0', '2022-06-08 20:57:30.0', '2022-06-09 08:37:42.0', '2022-06-09 08:59:15.0', '2022-06-09 08:59:51.0', '2022-06-09 09:19:55.0', '2022-06-09 11:07:18.0', '2022-06-09 19:01:58.0', '2022-06-09 20:33:59.0', '2022-06-10 11:14:35.0', '2022-06-10 11:15:09.0', '2022-06-10 15:31:52.0', '2022-06-11 02:08:06.0', '2022-06-11 02:08:17.0', '2022-06-11 02:08:27.0', '2022-06-11 12:48:19.0', '2022-06-11 14:14:17.0', '2022-06-13 08:38:48.0', '2022-06-13 09:14:18.0', '2022-06-13 09:27:11.0', '2022-06-13 09:29:13.0', '2022-06-13 14:00:54.0', '2022-06-13 14:04:54.0', '2022-06-13 16:07:00.0', '2022-06-13 17:42:32.0', '2022-06-13 17:42:56.0', '2022-06-13 17:43:21.0', '2022-06-13 17:43:45.0', '2022-06-13 17:44:12.0', '2022-06-13 17:44:37.0', '2022-06-13 17:47:48.0', '2022-06-13 19:47:03.0', '2022-06-13 19:52:28.0', '2022-06-14 11:12:33.0', '2022-06-14 15:46:54.0', '2022-06-14 16:05:30.0', '2022-06-14 16:17:10.0', '2022-06-14 16:17:51.0', '2022-06-14 16:22:50.0', '2022-06-14 16:23:19.0', '2022-06-15 16:12:05.0', '2022-06-15 17:17:13.0', '2022-06-15 18:04:15.0', '2022-06-16 09:08:01.0', '2022-06-16 16:57:11.0', '2022-06-17 10:51:07.0', '2022-06-17 10:51:51.0', '2022-06-17 13:24:16.0', '2022-06-17 15:42:28.0', '2022-06-17 15:45:13.0', '2022-06-18 08:59:44.0', '2022-06-20 17:34:05.0', '2022-06-20 17:34:42.0', '2022-06-20 17:35:33.0', '2022-06-21 08:43:28.0', '2022-06-21 09:21:43.0', '2022-06-21 09:22:09.0', '2022-06-21 09:22:33.0', '2022-06-21 09:22:58.0', '2022-06-21 09:23:25.0', '2022-06-21 09:23:51.0', '2022-06-21 10:26:32.0', '2022-06-21 10:26:54.0', '2022-06-21 19:36:19.0', '2022-06-22 10:28:51.0', '2022-06-22 11:47:00.0', '2022-06-23 11:46:00.0', '2022-06-23 13:19:13.0', '2022-06-23 15:15:12.0', '2022-06-23 16:12:45.0', '2022-06-24 08:38:02.0', '2022-06-24 08:38:15.0', '2022-06-24 08:38:56.0', '2022-06-24 08:39:06.0', '2022-06-24 08:39:38.0', '2022-06-24 08:39:49.0', '2022-06-24 08:40:17.0', '2022-06-24 08:40:26.0', '2022-06-24 08:40:55.0', '2022-06-24 08:41:29.0', '2022-06-24 08:41:39.0', '2022-06-24 12:17:29.0', '2022-06-24 20:03:11.0', '2022-06-27 10:13:11.0', '2022-06-28 08:44:57.0', '2022-06-28 10:44:11.0', '2022-06-28 10:57:41.0', '2022-06-28 16:09:12.0', '2022-06-28 16:48:46.0', '2022-06-28 17:01:55.0', '2022-06-29 11:30:23.0', '2022-06-30 03:02:29.0', '2022-06-30 03:03:29.0', '2022-06-30 11:00:35.0', '2022-06-30 17:25:20.0', '2022-07-01 11:29:37.0', '2022-07-01 11:41:20.0', '2022-07-01 18:40:52.0', '2022-07-02 13:39:09.0', '2022-07-04 09:50:16.0', '2022-07-04 10:55:57.0', '2022-07-04 12:30:32.0', '2022-07-04 14:34:17.0', '2022-07-04 14:34:47.0', '2022-07-04 14:35:12.0', '2022-07-04 14:35:52.0', '2022-07-04 15:12:15.0', '2022-07-05 14:45:05.0', '2022-07-05 15:44:49.0', '2022-07-05 15:46:34.0', '2022-07-05 16:02:56.0', '2022-07-05 16:03:37.0', '2022-07-05 16:12:57.0', '2022-07-05 16:32:49.0', '2022-07-05 17:28:29.0', '2022-07-05 18:12:10.0', '2022-07-06 10:58:44.0', '2022-07-11 14:58:21.0', '2022-07-12 09:17:02.0', '2022-07-12 10:07:15.0', '2022-07-12 15:38:59.0', '2022-07-12 18:47:10.0', '2022-07-12 18:54:28.0', '2022-07-13 10:24:57.0', '2022-07-13 16:36:51.0', '2022-07-13 17:05:29.0', '2022-07-13 17:05:44.0', '2022-07-14 09:15:19.0', '2022-07-14 16:30:24.0', '2022-07-15 08:56:52.0', '2022-07-15 08:58:01.0', '2022-07-15 08:58:31.0', '2022-07-15 12:37:19.0', '2022-07-15 14:52:38.0', '2022-07-15 15:14:37.0', '2022-07-15 15:16:22.0', '2022-07-15 15:26:28.0', '2022-07-15 17:25:23.0', '2022-07-18 18:04:32.0', '2022-07-18 18:05:02.0', '2022-07-18 18:05:33.0', '2022-07-18 18:05:58.0', '2022-07-18 18:06:22.0', '2022-07-20 09:51:25.0', '2022-07-20 10:22:00.0', '2022-07-20 11:29:09.0', '2022-07-20 14:17:41.0', '2022-07-20 16:13:56.0', '2022-07-20 17:23:19.0', '2022-07-21 09:39:12.0', '2022-07-21 09:39:39.0', '2022-07-22 08:32:41.0', '2022-07-22 15:27:36.0', '2022-07-22 15:50:26.0', '2022-07-25 14:59:10.0', '2022-07-25 16:49:46.0', '2022-07-25 17:23:46.0', '2022-07-26 11:03:02.0', '2022-07-26 11:12:36.0', '2022-07-26 11:13:04.0', '2022-07-26 14:21:10.0', '2022-07-26 19:16:13.0', '2022-07-26 20:00:28.0', '2022-07-28 18:34:24.0', '2022-07-29 12:29:47.0', '2022-08-01 09:55:22.0', '2022-08-02 10:05:13.0', '2022-08-02 16:19:09.0', '2022-08-02 16:19:35.0', '2022-08-03 13:05:24.0', '2022-08-04 08:57:36.0', '2022-08-04 10:26:15.0', '2022-08-04 15:39:33.0', '2022-08-05 09:18:41.0', '2022-08-05 14:00:55.0', '2022-08-05 15:14:00.0', '2022-08-08 11:31:02.0', '2022-08-08 11:31:51.0', '2022-08-08 15:34:10.0', '2022-08-09 17:37:25.0', '2022-08-10 10:18:23.0', '2022-08-11 09:03:55.0', '2022-08-15 08:27:13.0', '2022-08-15 08:44:49.0', '2022-08-15 09:04:36.0', '2022-08-15 09:05:07.0', '2022-08-15 09:05:32.0', '2022-08-15 09:05:56.0', '2022-08-15 09:06:20.0', '2022-08-15 11:23:51.0', '2022-08-15 11:27:49.0', '2022-08-15 14:16:31.0', '2022-08-16 09:36:12.0', '2022-08-16 17:25:01.0', '2022-08-16 17:25:38.0', '2022-08-16 18:11:23.0', '2022-08-17 16:21:19.0', '2022-08-22 11:47:46.0', '2022-08-23 10:50:36.0', '2022-08-23 10:51:47.0', '2022-08-23 10:52:26.0', '2022-08-24 01:40:23.0', '2022-08-25 12:17:06.0', '2022-08-25 18:17:47.0', '2022-08-25 18:23:08.0', '2022-08-26 08:41:46.0', '2022-08-26 08:45:10.0', '2022-08-26 11:44:54.0', '2022-08-30 23:13:06.0', '2022-09-02 01:28:56.0', '2022-09-02 01:29:26.0', '2022-09-02 01:32:39.0', '2022-09-02 15:47:45.0', '2022-09-04 22:48:29.0', '2022-09-05 10:36:42.0', '2022-09-05 14:10:58.0', '2022-09-05 15:17:38.0', '2022-09-05 23:19:23.0', '2022-09-06 09:16:04.0', '2022-09-06 15:51:03.0', '2022-09-06 16:28:58.0', '2022-09-06 16:29:59.0', '2022-09-07 16:26:58.0', '2022-09-08 10:48:31.0', '2022-09-08 11:12:36.0', '2022-09-08 11:23:53.0', '2022-09-08 13:53:41.0', '2022-09-08 13:55:04.0', '2022-09-08 18:32:30.0', '2022-09-09 12:17:41.0', '2022-09-09 14:53:31.0', '2022-09-13 09:34:54.0', '2022-09-13 16:22:11.0', '2022-09-13 16:24:33.0', '2022-09-13 16:24:57.0', '2022-09-13 16:26:15.0', '2022-09-15 08:42:14.0', '2022-09-15 08:43:13.0', '2022-09-15 08:44:05.0', '2022-09-15 09:43:49.0', '2022-09-15 12:53:24.0', '2022-09-16 08:52:56.0', '2022-09-16 10:45:10.0', '2022-09-16 10:45:21.0', '2022-09-16 10:45:34.0', '2022-09-16 10:45:43.0', '2022-09-16 12:55:15.0', '2022-09-19 09:50:07.0', '2022-09-19 19:05:47.0', '2022-09-19 19:06:17.0', '2022-09-19 19:06:54.0', '2022-09-20 10:02:19.0', '2022-09-20 13:57:10.0', '2022-09-20 14:53:52.0', '2022-09-20 15:55:20.0', '2022-09-21 08:38:33.0', '2022-09-21 19:48:59.0', '2022-09-21 19:49:29.0', '2022-09-21 19:49:55.0', '2022-09-22 17:40:47.0', '2022-09-22 17:44:48.0', '2022-09-22 17:45:15.0', '2022-09-22 17:45:24.0', '2022-09-22 17:45:31.0', '2022-09-22 17:45:38.0', '2022-09-23 10:57:20.0', '2022-09-26 10:04:31.0', '2022-09-26 11:44:26.0', '2022-09-26 16:36:42.0', '2022-09-26 18:25:00.0', '2022-09-27 08:43:42.0', '2022-09-27 09:17:03.0', '2022-09-27 11:10:46.0', '2022-09-27 11:40:59.0', '2022-09-27 18:12:53.0', '2022-09-28 09:11:41.0', '2022-09-28 14:52:16.0', '2022-09-29 08:29:15.0', '2022-09-29 08:49:44.0', '2022-09-29 09:24:27.0', '2022-09-29 18:17:58.0', '2022-09-29 18:18:23.0', '2022-09-29 18:18:51.0', '2022-09-29 20:44:37.0', '2022-09-29 20:45:03.0', '2022-09-30 17:42:13.0', '2022-09-30 18:18:15.0', '2022-10-08 17:54:01.0', '2022-10-08 17:54:23.0', '2022-10-08 17:54:52.0', '2022-10-08 17:55:19.0', '2022-10-09 10:06:31.0', '2022-10-09 15:59:48.0', '2022-10-09 17:40:36.0', '2022-10-09 18:31:48.0', '2022-10-10 10:48:15.0', '2022-10-10 14:06:16.0', '2022-10-10 14:43:52.0', '2022-10-10 14:44:27.0', '2022-10-10 14:44:57.0', '2022-10-10 14:45:22.0', '2022-10-10 21:31:06.0', '2022-10-11 09:22:28.0', '2022-10-11 09:37:07.0', '2022-10-11 09:37:29.0', '2022-10-11 10:20:02.0', '2022-10-11 11:34:39.0', '2022-10-11 11:35:03.0', '2022-10-11 11:35:27.0', '2022-10-11 11:35:50.0', '2022-10-11 12:53:05.0', '2022-10-11 12:53:17.0', '2022-10-11 14:22:46.0', '2022-10-11 14:23:26.0', '2022-10-12 14:45:51.0', '2022-10-12 14:46:11.0', '2022-10-12 15:19:56.0', '2022-10-13 10:11:23.0', '2022-10-17 00:58:06.0', '2022-10-17 00:58:33.0', '2022-10-18 12:29:30.0', '2022-10-18 15:49:56.0', '2022-10-18 15:50:31.0', '2022-10-18 19:04:36.0', '2022-10-19 11:35:33.0', '2022-10-21 10:15:36.0', '2022-10-21 14:02:54.0', '2022-10-21 17:17:56.0', '2022-10-24 09:21:34.0', '2022-10-25 17:53:08.0', '2022-10-26 08:48:03.0', '2022-10-26 09:39:40.0', '2022-10-26 10:28:26.0', '2022-10-26 15:27:54.0') and `T0`.`可研批复时间` in ('', '2021-03-16 08:03:51.0', '2021-05-11 15:23:59.0', '2021-05-17 15:13:16.0', '2021-06-27 22:45:04.0', '2021-09-24 10:04:59.0', '2021-10-12 14:53:55.0', '2021-10-18 17:36:52.0', '2021-10-27 09:13:05.0', '2021-11-22 11:32:22.0', '2021-12-11 14:15:41.0', '2022-03-21 16:55:36.0', '2022-03-22 15:31:46.0', '2022-06-23 17:36:01.0', '2022-06-27 18:20:10.0', '2022-09-13 16:40:06.0', '2022-09-27 08:55:07.0', '2022-10-24 17:11:02.0', '2022-10-28 08:39:36.0', '2022-11-01 17:09:23.0', '2022-12-02 14:01:19.0', '2022-12-30 15:47:44.0', '2023-03-08 11:49:49.0', '2023-05-12 11:47:05.0', '2023-05-30 08:03:03.0', '2023-05-30 10:38:46.0', '2023-06-20 17:59:09.0', '2023-08-04 14:16:47.0', '2023-08-27 22:40:20.0', '2023-08-28 10:06:01.0', '2023-11-02 13:35:12.0', '2023-11-15 17:22:40.0') and (`T0`.`关闭计划(月份)` in ('2024年10月', '2024年1月', '2024年2月', '2024年3月', '2024年4月', '2024年5月', '2024年6月', '2024年7月', '2024年8月', '2024年9月') or `T0`.`关闭计划(月份)` is null) group by `T0`.`立项批复时间`, `T0`.`可研批复时间`, `T0`.`关闭计划(月份)`]
    	at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1002)
    	at mondrian.olap.Util.newInternal(Util.java:2673)
    	at mondrian.olap.Util.newError(Util.java:2689)
    	at mondrian.rolap.SqlStatement.handle(SqlStatement.java:399)
    	at mondrian.rolap.SqlStatement.execute(SqlStatement.java:284)
    	at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:352)
    	at mondrian.rolap.sqlitecache.DataCacheSQLiteManager.createSqlStatementBySQLiteCache(DataCacheSQLiteManager.java:389)
    	at mondrian.rolap.sqlitecache.DataCacheSQLiteManager.createSqlStatementBySQLiteCache(DataCacheSQLiteManager.java:328)
    	at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:524)
    	... 8 more
    Caused by: java.sql.SQLException: Illegal mix of collations for operation ' IN '
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
    	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
    	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
    	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
    	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2439)
    	at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1365)
    	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
    	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
    	at mondrian.rolap.SqlStatement.execute(SqlStatement.java:219)
    	... 12 more
    
    	at smartbix.augmenteddataset.util.AugmentedDataSetException.create(AugmentedDataSetException.java:61)
    	at smartbix.augmenteddataset.olap.impl.OlapQueryService.createException(OlapQueryService.java:546)
    	at smartbix.augmenteddataset.olap.impl.OlapQueryService.executeQuery(OlapQueryService.java:423)
    	at smartbix.augmenteddataset.olap.impl.OlapQueryService$$FastClassBySpringCGLIB$$d01e6225.invoke()
    	at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
    	at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
    	at smartbixlibs.org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
    	at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
    	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
    	at smartbix.augmenteddataset.olap.impl.OlapQueryService$$EnhancerBySpringCGLIB$$22f0393c.executeQuery()
    	at smartbix.augmenteddataset.query.mondrian.MDXQueryEngine.getData(MDXQueryEngine.java:56)
    	at smartbix.augmenteddataset.handler.DefaultAugmentedDataSetHandler.getDataSetData(DefaultAugmentedDataSetHandler.java:133)
    	at smartbix.augmenteddataset.service.AugmentedDataSetQueryService.getDataSetDataInner(AugmentedDataSetQueryService.java:347)
    	at smartbix.augmenteddataset.service.AugmentedDataSetQueryService.getDataSetData(AugmentedDataSetQueryService.java:320)
    	at smartbix.augmenteddataset.service.AugmentedDataSetQueryService$$FastClassBySpringCGLIB$$3c7d00ce.invoke()
    	at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
    	at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
    	at smartbixlibs.org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
    	at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
    	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
    	at smartbix.augmenteddataset.service.AugmentedDataSetQueryService$$EnhancerBySpringCGLIB$$387c4a1e.getDataSetData()
    	at smartbix.smartbi.AugmentedDataSetForVModule.getDataSetData(AugmentedDataSetForVModule.java:810)
    	at smartbix.smartbi.AugmentedDataSetForVModule.getPreviewDataSetData(AugmentedDataSetForVModule.java:787)
    	at sun.reflect.GeneratedMethodAccessor1173.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:498)
    	at smartbi.framework.rmi.ClientService.executeInternal(ClientService.java:180)
    	at smartbi.framework.rmi.ClientService.execute(ClientService.java:158)
    	at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:235)
    	at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:153)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:515)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:583)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:212)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:249)
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:273)
    	at smartbi.aichat.AIChatFilter.doFilter(AIChatFilter.java:56)
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:273)
    	at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77)
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:273)
    	at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:276)
    	at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:127)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at smartbi.framework.rmi.TransactionFilter.doFilter(TransactionFilter.java:87)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:242)
    	at smartbi.freequery.filter.Filter.doFilter(Filter.java:33)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:93)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:179)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at smartbi.freequery.filter.CheckHttpMethodFilter.doFilter(CheckHttpMethodFilter.java:62)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:131)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:130)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at smartbi.freequery.filter.LogFilter.doFilter(LogFilter.java:63)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at smartbi.freequery.filter.DisableUrlSessionFilter.doFilter(DisableUrlSessionFilter.java:81)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at smartbi.framework.SmartbiApplicationFilter.doFilter(SmartbiApplicationFilter.java:51)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
    	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:682)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:617)
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:932)
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1695)
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    	at java.lang.Thread.run(Thread.java:748)
    	Suppressed: java.lang.RuntimeException: errorMessageMondrian Error:mondrian.olap.MondrianException: Mondrian Error:Failed to load segment form SQL
    errorStackTrace=mondrian.olap.MondrianException: Mondrian Error:mondrian.olap.MondrianException: Mondrian Error:Failed to load segment form SQL
    	at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:201)
    	at mondrian.rolap.agg.SegmentLoader.access$000(SegmentLoader.java:60)
    	at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:158)
    	at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:137)
    	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    	at java.lang.Thread.run(Thread.java:748)
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to load segment form SQL
    	at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:534)
    	at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:177)
    	... 7 more
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select `T0`.`立项批复时间` as `c0`, `T0`.`可研批复时间` as `c1`, `T0`.`关闭计划(月份)` as `c2`, count(1) as `m0` from `bc_base_client`.`项目明细表` as `T0` where `T0`.`立项批复时间` in ('', '2021-01-02 14:28:04.0', '2021-03-24 00:30:15.0', '2021-04-12 23:29:15.0', '2021-04-14 12:29:20.0', '2021-04-15 15:03:28.0', '2021-04-16 17:30:52.0', '2021-04-16 17:31:09.0', '2021-04-16 17:42:48.0', '2021-04-21 10:41:27.0', '2021-04-21 10:42:07.0', '2021-04-23 15:46:11.0', '2021-04-27 08:17:29.0', '2021-05-08 11:11:20.0', '2021-05-12 22:00:04.0', '2021-05-14 11:09:26.0', '2021-05-16 16:55:29.0', '2021-05-17 09:53:29.0', '2021-05-18 23:18:11.0', '2021-05-20 20:40:05.0', '2021-05-21 09:29:31.0', '2021-05-24 15:13:37.0', '2021-05-25 08:37:08.0', '2021-05-25 14:09:42.0', '2021-05-25 15:17:36.0', '2021-05-25 16:50:32.0', '2021-05-25 17:06:18.0', '2021-05-25 18:11:51.0', '2021-05-26 17:22:52.0', '2021-05-27 12:22:53.0', '2021-06-03 15:51:30.0', '2021-06-05 11:50:55.0', '2021-06-07 16:02:16.0', '2021-06-08 16:21:09.0', '2021-06-11 10:18:16.0', '2021-06-14 13:03:02.0', '2021-06-21 16:02:58.0', '2021-06-21 19:44:28.0', '2021-06-23 16:44:12.0', '2021-06-24 22:41:14.0', '2021-07-06 17:55:29.0', '2021-07-07 09:49:24.0', '2021-07-07 17:29:05.0', '2021-07-07 17:31:23.0', '2021-07-08 16:23:27.0', '2021-07-15 16:02:32.0', '2021-07-16 09:14:41.0', '2021-07-16 20:54:12.0', '2021-07-19 14:26:18.0', '2021-07-19 19:33:27.0', '2021-07-19 19:34:41.0', '2021-07-26 10:30:40.0', '2021-07-26 10:35:06.0', '2021-07-26 10:38:37.0', '2021-07-26 10:41:34.0', '2021-07-26 15:54:48.0', '2021-07-26 16:13:52.0', '2021-07-27 11:06:57.0', '2021-07-27 11:07:36.0', '2021-07-27 11:07:56.0', '2021-07-27 11:08:35.0', '2021-07-27 11:09:07.0', '2021-07-31 16:26:46.0', '2021-08-09 15:51:08.0', '2021-08-10 17:33:54.0', '2021-08-12 12:30:32.0', '2021-08-12 22:11:29.0', '2021-08-18 10:11:45.0', '2021-08-23 16:54:33.0', '2021-08-25 16:05:22.0', '2021-08-29 19:19:50.0', '2021-09-09 17:18:10.0', '2021-09-11 20:36:54.0', '2021-09-11 20:37:20.0', '2021-09-15 11:50:18.0', '2021-09-18 16:24:39.0', '2021-09-22 22:49:07.0', '2021-09-25 20:26:05.0', '2021-09-26 17:15:49.0', '2021-10-07 14:46:53.0', '2021-10-21 16:51:56.0', '2021-10-22 14:07:04.0', '2021-10-22 18:00:44.0', '2021-10-27 15:45:12.0', '2021-10-29 17:54:41.0', '2021-11-03 19:28:25.0', '2021-11-03 20:05:40.0', '2021-11-03 20:07:57.0', '2021-11-09 08:48:39.0', '2021-11-09 16:58:38.0', '2021-11-09 16:59:21.0', '2021-11-19 14:48:53.0', '2021-11-19 14:49:14.0', '2021-11-22 16:38:01.0', '2021-11-23 22:13:02.0', '2021-11-23 22:13:15.0', '2021-11-23 22:13:29.0', '2021-11-23 22:13:42.0', '2021-11-23 22:13:56.0', '2021-11-24 10:50:56.0', '2021-11-24 12:16:10.0', '2021-11-24 14:05:40.0', '2021-11-24 14:06:51.0', '2021-11-24 14:09:09.0', '2021-11-24 14:09:52.0', '2021-11-24 14:10:42.0', '2021-11-25 08:57:33.0', '2021-11-25 13:56:29.0', '2021-11-25 15:13:16.0', '2021-11-25 15:13:38.0', '2021-11-25 15:14:00.0', '2021-11-25 21:50:03.0', '2021-11-25 21:50:46.0', '2021-11-29 08:58:32.0', '2021-11-29 20:06:38.0', '2021-11-30 09:56:22.0', '2021-11-30 10:55:55.0', '2021-11-30 10:56:15.0', '2021-11-30 11:06:54.0', '2021-11-30 11:07:15.0', '2021-11-30 11:07:36.0', '2021-11-30 11:11:46.0', '2021-11-30 11:12:06.0', '2021-11-30 11:12:30.0', '2021-11-30 11:12:47.0', '2021-11-30 11:13:25.0', '2021-11-30 11:14:03.0', '2021-11-30 11:14:23.0', '2021-11-30 11:44:52.0', '2021-12-01 17:51:26.0', '2021-12-01 23:27:27.0', '2021-12-01 23:27:59.0', '2021-12-01 23:28:12.0', '2021-12-02 11:51:48.0', '2021-12-02 11:52:00.0', '2021-12-02 11:52:17.0', '2021-12-02 11:52:34.0', '2021-12-02 11:52:53.0', '2021-12-02 11:53:11.0', '2021-12-02 11:53:22.0', '2021-12-02 11:53:42.0', '2021-12-06 09:04:08.0', '2021-12-06 09:04:29.0', '2021-12-06 14:07:24.0', '2021-12-06 14:07:46.0', '2021-12-06 14:14:08.0', '2021-12-06 14:47:12.0', '2021-12-06 14:47:33.0', '2021-12-06 15:12:15.0', '2021-12-06 16:37:51.0', '2021-12-06 16:51:32.0', '2021-12-06 16:51:52.0', '2021-12-06 16:52:11.0', '2021-12-06 16:52:30.0', '2021-12-06 16:52:49.0', '2021-12-06 17:29:00.0', '2021-12-06 17:29:25.0', '2021-12-06 17:30:42.0', '2021-12-06 17:31:07.0', '2021-12-06 17:31:29.0', '2021-12-07 15:06:05.0', '2021-12-07 15:15:35.0', '2021-12-07 16:45:10.0', '2021-12-07 16:47:53.0', '2021-12-07 20:34:00.0', '2021-12-07 20:34:43.0', '2021-12-08 15:31:18.0', '2021-12-08 15:31:43.0', '2021-12-08 20:27:11.0', '2021-12-08 20:28:48.0', '2021-12-09 23:56:44.0', '2021-12-10 02:19:48.0', '2021-12-10 02:21:07.0', '2021-12-10 11:29:03.0', '2021-12-10 14:28:10.0', '2021-12-10 15:22:24.0', '2021-12-13 09:20:15.0', '2021-12-13 11:18:37.0', '2021-12-13 11:41:28.0', '2021-12-13 11:47:43.0', '2021-12-13 14:33:36.0', '2021-12-13 14:47:20.0', '2021-12-13 16:31:05.0', '2021-12-13 16:32:12.0', '2021-12-14 11:49:33.0', '2021-12-14 11:49:53.0', '2021-12-14 11:50:58.0', '2021-12-14 11:51:13.0', '2021-12-14 13:34:04.0', '2021-12-14 17:02:42.0', '2021-12-14 21:50:27.0', '2021-12-14 21:50:41.0', '2021-12-14 21:50:52.0', '2021-12-14 21:51:05.0', '2021-12-14 21:51:17.0', '2021-12-14 21:51:31.0', '2021-12-14 21:51:45.0', '2021-12-14 21:51:56.0', '2021-12-15 16:57:06.0', '2021-12-15 21:03:56.0', '2021-12-15 21:04:06.0', '2021-12-16 10:53:57.0', '2021-12-16 10:54:33.0', '2021-12-16 20:35:15.0', '2021-12-17 08:19:18.0', '2021-12-17 16:15:08.0', '2021-12-17 17:45:28.0', '2021-12-17 17:47:20.0', '2021-12-18 18:08:22.0', '2021-12-18 18:49:44.0', '2021-12-20 16:49:28.0', '2021-12-20 18:40:53.0', '2021-12-21 09:51:25.0', '2021-12-22 15:15:54.0', '2021-12-22 17:54:36.0', '2021-12-22 17:54:58.0', '2021-12-22 17:55:24.0', '2021-12-23 16:32:12.0', '2021-12-24 15:42:07.0', '2021-12-24 15:42:27.0', '2021-12-24 15:42:54.0', '2021-12-24 17:08:23.0', '2021-12-27 09:01:51.0', '2021-12-27 09:03:03.0', '2021-12-27 09:04:04.0', '2021-12-27 09:06:05.0', '2021-12-27 09:06:49.0', '2021-12-27 09:07:17.0', '2021-12-27 09:07:58.0', '2021-12-27 09:08:26.0', '2021-12-27 09:08:49.0', '2021-12-27 09:09:17.0', '2021-12-27 09:09:39.0', '2021-12-27 09:10:11.0', '2021-12-27 10:43:40.0', '2021-12-28 09:54:37.0', '2021-12-29 16:35:30.0', '2021-12-30 16:16:31.0', '2021-12-31 10:12:44.0', '2022-01-03 13:41:48.0', '2022-01-04 14:38:50.0', '2022-01-04 15:51:03.0', '2022-01-04 15:51:35.0', '2022-01-04 15:51:56.0', '2022-01-07 14:28:57.0', '2022-01-10 15:07:22.0', '2022-01-10 15:08:13.0', '2022-01-11 11:21:32.0', '2022-01-11 11:34:14.0', '2022-01-11 14:04:33.0', '2022-01-12 08:30:02.0', '2022-01-12 16:11:17.0', '2022-01-13 08:34:28.0', '2022-01-13 14:23:09.0', '2022-01-13 14:23:40.0', '2022-01-14 16:39:51.0', '2022-01-17 18:16:47.0', '2022-01-17 18:21:50.0', '2022-01-18 16:38:59.0', '2022-01-20 08:03:19.0', '2022-01-20 08:03:42.0', '2022-01-20 08:04:05.0', '2022-01-20 11:47:09.0', '2022-01-20 15:18:01.0', '2022-01-20 15:22:14.0', '2022-01-20 15:22:39.0', '2022-01-20 15:23:17.0', '2022-01-22 09:29:32.0', '2022-01-24 09:05:07.0', '2022-01-25 13:41:38.0', '2022-01-25 14:25:35.0', '2022-01-26 15:37:18.0', '2022-01-26 17:39:17.0', '2022-01-27 17:16:31.0', '2022-01-27 17:22:59.0', '2022-01-28 11:34:09.0', '2022-02-08 10:46:26.0', '2022-02-11 11:40:16.0', '2022-02-18 08:59:10.0', '2022-02-22 11:04:44.0', '2022-02-22 17:25:47.0', '2022-02-22 17:39:10.0', '2022-02-23 16:57:38.0', '2022-02-23 20:59:21.0', '2022-02-25 10:13:26.0', '2022-02-25 10:13:50.0', '2022-02-25 14:40:35.0', '2022-02-25 17:13:25.0', '2022-02-25 18:50:09.0', '2022-02-25 22:29:51.0', '2022-02-25 22:31:25.0', '2022-02-25 22:41:58.0', '2022-02-25 22:45:34.0', '2022-02-25 22:46:26.0', '2022-02-25 22:49:33.0', '2022-02-25 22:52:26.0', '2022-02-28 10:47:25.0', '2022-02-28 21:17:47.0', '2022-02-28 21:22:36.0', '2022-03-01 12:42:50.0', '2022-03-01 15:08:23.0', '2022-03-01 15:08:33.0', '2022-03-01 17:21:44.0', '2022-03-02 09:02:08.0', '2022-03-02 14:11:52.0', '2022-03-02 18:30:33.0', '2022-03-02 18:49:17.0', '2022-03-03 14:41:40.0', '2022-03-03 16:29:04.0', '2022-03-03 17:01:13.0', '2022-03-03 19:02:10.0', '2022-03-04 10:40:31.0', '2022-03-04 16:32:42.0', '2022-03-04 16:49:19.0', '2022-03-04 17:13:56.0', '2022-03-07 08:55:17.0', '2022-03-07 10:33:53.0', '2022-03-07 10:43:49.0', '2022-03-07 12:44:41.0', '2022-03-07 13:26:48.0', '2022-03-07 13:28:19.0', '2022-03-07 13:28:40.0', '2022-03-07 13:29:21.0', '2022-03-07 16:22:23.0', '2022-03-07 16:24:38.0', '2022-03-07 16:26:41.0', '2022-03-08 10:18:43.0', '2022-03-08 13:53:18.0', '2022-03-08 14:47:13.0', '2022-03-08 14:51:13.0', '2022-03-08 16:26:43.0', '2022-03-08 16:28:02.0', '2022-03-08 17:47:47.0', '2022-03-09 11:24:26.0', '2022-03-09 11:34:04.0', '2022-03-09 17:15:18.0', '2022-03-09 17:20:18.0', '2022-03-09 17:26:57.0', '2022-03-09 18:01:53.0', '2022-03-10 09:54:04.0', '2022-03-10 10:51:47.0', '2022-03-10 12:38:03.0', '2022-03-10 12:38:29.0', '2022-03-10 12:38:52.0', '2022-03-10 12:45:56.0', '2022-03-10 14:12:52.0', '2022-03-10 14:14:32.0', '2022-03-10 14:18:01.0', '2022-03-10 14:32:22.0', '2022-03-10 15:09:27.0', '2022-03-10 15:18:58.0', '2022-03-10 15:24:31.0', '2022-03-10 16:15:19.0', '2022-03-10 16:20:34.0', '2022-03-10 16:24:04.0', '2022-03-10 16:44:53.0', '2022-03-10 17:15:58.0', '2022-03-10 17:50:15.0', '2022-03-10 17:50:44.0', '2022-03-10 18:09:16.0', '2022-03-11 09:36:14.0', '2022-03-11 09:51:55.0', '2022-03-11 09:56:15.0', '2022-03-11 11:29:11.0', '2022-03-11 11:55:09.0', '2022-03-11 18:11:29.0', '2022-03-14 08:49:15.0', '2022-03-14 08:49:41.0', '2022-03-14 08:50:07.0', '2022-03-14 11:57:55.0', '2022-03-14 11:58:13.0', '2022-03-14 11:58:32.0', '2022-03-14 11:58:51.0', '2022-03-14 12:00:03.0', '2022-03-14 15:54:37.0', '2022-03-14 16:27:30.0', '2022-03-14 16:47:18.0', '2022-03-14 16:48:50.0', '2022-03-14 19:35:12.0', '2022-03-15 11:44:14.0', '2022-03-15 12:53:21.0', '2022-03-15 14:11:31.0', '2022-03-15 14:14:58.0', '2022-03-15 14:18:53.0', '2022-03-15 15:19:30.0', '2022-03-15 15:23:40.0', '2022-03-15 15:24:24.0', '2022-03-15 15:24:57.0', '2022-03-15 15:25:25.0', '2022-03-15 15:28:11.0', '2022-03-15 16:59:29.0', '2022-03-15 16:59:52.0', '2022-03-16 09:19:14.0', '2022-03-16 09:32:57.0', '2022-03-16 10:52:26.0', '2022-03-16 16:37:46.0', '2022-03-16 16:43:07.0', '2022-03-16 16:44:05.0', '2022-03-16 17:52:14.0', '2022-03-17 14:48:58.0', '2022-03-17 15:00:37.0', '2022-03-17 15:03:17.0', '2022-03-17 18:59:23.0', '2022-03-18 09:19:09.0', '2022-03-18 09:19:21.0', '2022-03-18 11:24:58.0', '2022-03-21 14:51:34.0', '2022-03-21 17:52:15.0', '2022-03-21 19:48:26.0', '2022-03-22 10:19:27.0', '2022-03-22 10:44:35.0', '2022-03-22 10:49:22.0', '2022-03-22 10:58:01.0', '2022-03-22 11:07:35.0', '2022-03-22 16:01:33.0', '2022-03-22 16:27:45.0', '2022-03-22 17:04:50.0', '2022-03-22 17:28:29.0', '2022-03-22 17:30:04.0', '2022-03-22 17:34:48.0', '2022-03-22 19:20:16.0', '2022-03-24 09:16:36.0', '2022-03-24 09:17:24.0', '2022-03-24 09:32:16.0', '2022-03-24 09:32:59.0', '2022-03-24 09:33:44.0', '2022-03-24 09:37:35.0', '2022-03-24 09:52:52.0', '2022-03-24 10:09:54.0', '2022-03-24 15:46:19.0', '2022-03-24 16:27:14.0', '2022-03-24 16:27:20.0', '2022-03-24 16:39:48.0', '2022-03-24 17:39:25.0', '2022-03-25 08:29:19.0', '2022-03-25 15:05:37.0', '2022-03-25 16:59:14.0', '2022-03-25 17:01:34.0', '2022-03-25 17:20:43.0', '2022-03-28 09:13:03.0', '2022-03-28 09:34:58.0', '2022-03-28 09:36:40.0', '2022-03-28 09:39:42.0', '2022-03-28 09:40:52.0', '2022-03-28 09:41:43.0', '2022-03-28 09:46:01.0', '2022-03-28 09:48:15.0', '2022-03-28 09:48:54.0', '2022-03-28 11:56:38.0', '2022-03-29 09:13:40.0', '2022-03-29 09:14:56.0', '2022-03-29 10:12:22.0', '2022-03-29 16:03:01.0', '2022-03-29 16:03:14.0', '2022-03-29 16:03:26.0', '2022-03-29 16:03:34.0', '2022-03-29 16:03:42.0', '2022-03-29 16:36:23.0', '2022-03-29 16:36:42.0', '2022-03-29 16:37:02.0', '2022-03-29 16:37:21.0', '2022-03-29 16:37:41.0', '2022-03-29 16:38:01.0', '2022-03-29 16:38:21.0', '2022-03-29 17:18:34.0', '2022-03-29 18:02:09.0', '2022-03-29 19:11:25.0', '2022-03-30 09:49:53.0', '2022-03-30 10:40:52.0', '2022-03-30 15:08:26.0', '2022-03-30 19:16:27.0', '2022-03-31 11:15:53.0', '2022-03-31 11:24:58.0', '2022-03-31 17:37:01.0', '2022-04-01 11:30:03.0', '2022-04-02 08:50:53.0', '2022-04-02 10:49:46.0', '2022-04-02 15:12:08.0', '2022-04-02 16:18:05.0', '2022-04-02 17:55:10.0', '2022-04-06 09:23:37.0', '2022-04-06 09:26:47.0', '2022-04-06 09:34:28.0', '2022-04-11 08:49:49.0', '2022-04-11 10:34:20.0', '2022-04-13 17:55:48.0', '2022-04-13 18:05:21.0', '2022-04-13 20:59:53.0', '2022-04-15 16:39:25.0', '2022-04-15 16:42:13.0', '2022-04-19 18:23:44.0', '2022-04-20 16:41:30.0', '2022-04-20 16:43:27.0', '2022-04-21 14:17:52.0', '2022-04-21 14:18:07.0', '2022-04-21 16:41:04.0', '2022-04-21 17:54:08.0', '2022-04-22 14:41:23.0', '2022-04-22 14:43:09.0', '2022-04-24 14:14:43.0', '2022-04-24 18:57:26.0', '2022-04-25 11:45:55.0', '2022-04-25 11:46:11.0', '2022-04-26 08:39:58.0', '2022-04-26 08:40:26.0', '2022-04-26 08:40:51.0', '2022-04-26 09:21:10.0', '2022-04-26 09:46:13.0', '2022-04-26 16:34:49.0', '2022-04-27 09:40:45.0', '2022-04-27 09:45:33.0', '2022-04-27 16:15:01.0', '2022-04-27 17:05:55.0', '2022-04-27 17:57:40.0', '2022-04-29 09:26:30.0', '2022-04-29 11:31:50.0', '2022-04-29 11:36:00.0', '2022-04-29 15:45:35.0', '2022-04-29 16:30:00.0', '2022-04-29 16:44:25.0', '2022-05-05 08:26:53.0', '2022-05-05 11:22:10.0', '2022-05-05 11:35:16.0', '2022-05-05 12:09:56.0', '2022-05-05 13:07:28.0', '2022-05-06 09:10:00.0', '2022-05-07 14:22:01.0', '2022-05-09 14:13:58.0', '2022-05-10 15:23:31.0', '2022-05-10 15:25:30.0', '2022-05-10 20:13:58.0', '2022-05-10 20:22:35.0', '2022-05-12 14:05:14.0', '2022-05-13 09:21:51.0', '2022-05-13 15:31:50.0', '2022-05-15 18:26:24.0', '2022-05-16 16:08:45.0', '2022-05-16 17:58:49.0', '2022-05-16 20:04:11.0', '2022-05-18 11:42:03.0', '2022-05-19 08:54:26.0', '2022-05-19 17:33:21.0', '2022-05-19 19:06:59.0', '2022-05-20 08:24:39.0', '2022-05-20 08:25:01.0', '2022-05-20 08:25:24.0', '2022-05-20 10:47:32.0', '2022-05-22 13:29:31.0', '2022-05-22 13:30:02.0', '2022-05-22 13:30:44.0', '2022-05-22 13:31:22.0', '2022-05-22 13:35:24.0', '2022-05-22 13:36:40.0', '2022-05-22 13:37:09.0', '2022-05-22 13:38:21.0', '2022-05-22 13:38:50.0', '2022-05-22 13:39:14.0', '2022-05-22 21:27:08.0', '2022-05-22 21:27:27.0', '2022-05-22 22:20:41.0', '2022-05-23 10:04:04.0', '2022-05-23 10:04:40.0', '2022-05-23 10:05:09.0', '2022-05-23 11:13:13.0', '2022-05-23 12:47:58.0', '2022-05-23 14:14:00.0', '2022-05-23 14:14:29.0', '2022-05-23 18:52:43.0', '2022-05-24 09:23:45.0', '2022-05-24 09:41:57.0', '2022-05-24 10:09:33.0', '2022-05-24 10:15:32.0', '2022-05-24 10:15:55.0', '2022-05-24 12:40:00.0', '2022-05-24 16:44:58.0', '2022-05-25 11:33:59.0', '2022-05-25 11:34:28.0', '2022-05-25 11:47:15.0', '2022-05-26 11:31:16.0', '2022-05-26 11:31:40.0', '2022-05-26 11:32:04.0', '2022-05-26 15:22:04.0', '2022-05-27 16:59:07.0', '2022-05-27 17:56:10.0', '2022-05-27 18:16:11.0', '2022-05-27 18:16:25.0', '2022-05-27 18:16:48.0', '2022-05-27 18:17:08.0', '2022-05-27 18:17:19.0', '2022-05-27 18:17:31.0', '2022-05-27 18:17:42.0', '2022-05-27 18:17:57.0', '2022-05-27 18:18:11.0', '2022-05-27 18:25:47.0', '2022-05-30 14:32:27.0', '2022-05-30 17:22:29.0', '2022-05-31 10:51:59.0', '2022-05-31 10:52:30.0', '2022-05-31 13:56:51.0', '2022-05-31 14:43:40.0', '2022-05-31 15:15:09.0', '2022-05-31 16:26:56.0', '2022-06-01 12:12:43.0', '2022-06-01 15:06:59.0', '2022-06-01 15:47:23.0', '2022-06-01 15:48:30.0', '2022-06-01 15:48:56.0', '2022-06-01 16:31:56.0', '2022-06-01 18:21:08.0', '2022-06-01 19:26:19.0', '2022-06-01 19:26:29.0', '2022-06-01 19:26:38.0', '2022-06-02 09:19:21.0', '2022-06-02 09:26:40.0', '2022-06-02 14:03:41.0', '2022-06-02 14:30:41.0', '2022-06-02 16:36:28.0', '2022-06-03 10:53:57.0', '2022-06-06 08:18:49.0', '2022-06-06 09:52:56.0', '2022-06-06 11:43:04.0', '2022-06-06 14:55:21.0', '2022-06-06 16:49:06.0', '2022-06-06 16:51:28.0', '2022-06-06 16:53:06.0', '2022-06-06 16:53:40.0', '2022-06-06 16:59:55.0', '2022-06-06 17:02:18.0', '2022-06-06 18:30:57.0', '2022-06-07 09:10:52.0', '2022-06-07 09:34:30.0', '2022-06-07 16:27:29.0', '2022-06-07 16:27:55.0', '2022-06-07 17:10:31.0', '2022-06-07 17:10:52.0', '2022-06-07 17:11:14.0', '2022-06-08 14:37:55.0', '2022-06-08 20:57:30.0', '2022-06-09 08:37:42.0', '2022-06-09 08:59:15.0', '2022-06-09 08:59:51.0', '2022-06-09 09:19:55.0', '2022-06-09 11:07:18.0', '2022-06-09 19:01:58.0', '2022-06-09 20:33:59.0', '2022-06-10 11:14:35.0', '2022-06-10 11:15:09.0', '2022-06-10 15:31:52.0', '2022-06-11 02:08:06.0', '2022-06-11 02:08:17.0', '2022-06-11 02:08:27.0', '2022-06-11 12:48:19.0', '2022-06-11 14:14:17.0', '2022-06-13 08:38:48.0', '2022-06-13 09:14:18.0', '2022-06-13 09:27:11.0', '2022-06-13 09:29:13.0', '2022-06-13 14:00:54.0', '2022-06-13 14:04:54.0', '2022-06-13 16:07:00.0', '2022-06-13 17:42:32.0', '2022-06-13 17:42:56.0', '2022-06-13 17:43:21.0', '2022-06-13 17:43:45.0', '2022-06-13 17:44:12.0', '2022-06-13 17:44:37.0', '2022-06-13 17:47:48.0', '2022-06-13 19:47:03.0', '2022-06-13 19:52:28.0', '2022-06-14 11:12:33.0', '2022-06-14 15:46:54.0', '2022-06-14 16:05:30.0', '2022-06-14 16:17:10.0', '2022-06-14 16:17:51.0', '2022-06-14 16:22:50.0', '2022-06-14 16:23:19.0', '2022-06-15 16:12:05.0', '2022-06-15 17:17:13.0', '2022-06-15 18:04:15.0', '2022-06-16 09:08:01.0', '2022-06-16 16:57:11.0', '2022-06-17 10:51:07.0', '2022-06-17 10:51:51.0', '2022-06-17 13:24:16.0', '2022-06-17 15:42:28.0', '2022-06-17 15:45:13.0', '2022-06-18 08:59:44.0', '2022-06-20 17:34:05.0', '2022-06-20 17:34:42.0', '2022-06-20 17:35:33.0', '2022-06-21 08:43:28.0', '2022-06-21 09:21:43.0', '2022-06-21 09:22:09.0', '2022-06-21 09:22:33.0', '2022-06-21 09:22:58.0', '2022-06-21 09:23:25.0', '2022-06-21 09:23:51.0', '2022-06-21 10:26:32.0', '2022-06-21 10:26:54.0', '2022-06-21 19:36:19.0', '2022-06-22 10:28:51.0', '2022-06-22 11:47:00.0', '2022-06-23 11:46:00.0', '2022-06-23 13:19:13.0', '2022-06-23 15:15:12.0', '2022-06-23 16:12:45.0', '2022-06-24 08:38:02.0', '2022-06-24 08:38:15.0', '2022-06-24 08:38:56.0', '2022-06-24 08:39:06.0', '2022-06-24 08:39:38.0', '2022-06-24 08:39:49.0', '2022-06-24 08:40:17.0', '2022-06-24 08:40:26.0', '2022-06-24 08:40:55.0', '2022-06-24 08:41:29.0', '2022-06-24 08:41:39.0', '2022-06-24 12:17:29.0', '2022-06-24 20:03:11.0', '2022-06-27 10:13:11.0', '2022-06-28 08:44:57.0', '2022-06-28 10:44:11.0', '2022-06-28 10:57:41.0', '2022-06-28 16:09:12.0', '2022-06-28 16:48:46.0', '2022-06-28 17:01:55.0', '2022-06-29 11:30:23.0', '2022-06-30 03:02:29.0', '2022-06-30 03:03:29.0', '2022-06-30 11:00:35.0', '2022-06-30 17:25:20.0', '2022-07-01 11:29:37.0', '2022-07-01 11:41:20.0', '2022-07-01 18:40:52.0', '2022-07-02 13:39:09.0', '2022-07-04 09:50:16.0', '2022-07-04 10:55:57.0', '2022-07-04 12:30:32.0', '2022-07-04 14:34:17.0', '2022-07-04 14:34:47.0', '2022-07-04 14:35:12.0', '2022-07-04 14:35:52.0', '2022-07-04 15:12:15.0', '2022-07-05 14:45:05.0', '2022-07-05 15:44:49.0', '2022-07-05 15:46:34.0', '2022-07-05 16:02:56.0', '2022-07-05 16:03:37.0', '2022-07-05 16:12:57.0', '2022-07-05 16:32:49.0', '2022-07-05 17:28:29.0', '2022-07-05 18:12:10.0', '2022-07-06 10:58:44.0', '2022-07-11 14:58:21.0', '2022-07-12 09:17:02.0', '2022-07-12 10:07:15.0', '2022-07-12 15:38:59.0', '2022-07-12 18:47:10.0', '2022-07-12 18:54:28.0', '2022-07-13 10:24:57.0', '2022-07-13 16:36:51.0', '2022-07-13 17:05:29.0', '2022-07-13 17:05:44.0', '2022-07-14 09:15:19.0', '2022-07-14 16:30:24.0', '2022-07-15 08:56:52.0', '2022-07-15 08:58:01.0', '2022-07-15 08:58:31.0', '2022-07-15 12:37:19.0', '2022-07-15 14:52:38.0', '2022-07-15 15:14:37.0', '2022-07-15 15:16:22.0', '2022-07-15 15:26:28.0', '2022-07-15 17:25:23.0', '2022-07-18 18:04:32.0', '2022-07-18 18:05:02.0', '2022-07-18 18:05:33.0', '2022-07-18 18:05:58.0', '2022-07-18 18:06:22.0', '2022-07-20 09:51:25.0', '2022-07-20 10:22:00.0', '2022-07-20 11:29:09.0', '2022-07-20 14:17:41.0', '2022-07-20 16:13:56.0', '2022-07-20 17:23:19.0', '2022-07-21 09:39:12.0', '2022-07-21 09:39:39.0', '2022-07-22 08:32:41.0', '2022-07-22 15:27:36.0', '2022-07-22 15:50:26.0', '2022-07-25 14:59:10.0', '2022-07-25 16:49:46.0', '2022-07-25 17:23:46.0', '2022-07-26 11:03:02.0', '2022-07-26 11:12:36.0', '2022-07-26 11:13:04.0', '2022-07-26 14:21:10.0', '2022-07-26 19:16:13.0', '2022-07-26 20:00:28.0', '2022-07-28 18:34:24.0', '2022-07-29 12:29:47.0', '2022-08-01 09:55:22.0', '2022-08-02 10:05:13.0', '2022-08-02 16:19:09.0', '2022-08-02 16:19:35.0', '2022-08-03 13:05:24.0', '2022-08-04 08:57:36.0', '2022-08-04 10:26:15.0', '2022-08-04 15:39:33.0', '2022-08-05 09:18:41.0', '2022-08-05 14:00:55.0', '2022-08-05 15:14:00.0', '2022-08-08 11:31:02.0', '2022-08-08 11:31:51.0', '2022-08-08 15:34:10.0', '2022-08-09 17:37:25.0', '2022-08-10 10:18:23.0', '2022-08-11 09:03:55.0', '2022-08-15 08:27:13.0', '2022-08-15 08:44:49.0', '2022-08-15 09:04:36.0', '2022-08-15 09:05:07.0', '2022-08-15 09:05:32.0', '2022-08-15 09:05:56.0', '2022-08-15 09:06:20.0', '2022-08-15 11:23:51.0', '2022-08-15 11:27:49.0', '2022-08-15 14:16:31.0', '2022-08-16 09:36:12.0', '2022-08-16 17:25:01.0', '2022-08-16 17:25:38.0', '2022-08-16 18:11:23.0', '2022-08-17 16:21:19.0', '2022-08-22 11:47:46.0', '2022-08-23 10:50:36.0', '2022-08-23 10:51:47.0', '2022-08-23 10:52:26.0', '2022-08-24 01:40:23.0', '2022-08-25 12:17:06.0', '2022-08-25 18:17:47.0', '2022-08-25 18:23:08.0', '2022-08-26 08:41:46.0', '2022-08-26 08:45:10.0', '2022-08-26 11:44:54.0', '2022-08-30 23:13:06.0', '2022-09-02 01:28:56.0', '2022-09-02 01:29:26.0', '2022-09-02 01:32:39.0', '2022-09-02 15:47:45.0', '2022-09-04 22:48:29.0', '2022-09-05 10:36:42.0', '2022-09-05 14:10:58.0', '2022-09-05 15:17:38.0', '2022-09-05 23:19:23.0', '2022-09-06 09:16:04.0', '2022-09-06 15:51:03.0', '2022-09-06 16:28:58.0', '2022-09-06 16:29:59.0', '2022-09-07 16:26:58.0', '2022-09-08 10:48:31.0', '2022-09-08 11:12:36.0', '2022-09-08 11:23:53.0', '2022-09-08 13:53:41.0', '2022-09-08 13:55:04.0', '2022-09-08 18:32:30.0', '2022-09-09 12:17:41.0', '2022-09-09 14:53:31.0', '2022-09-13 09:34:54.0', '2022-09-13 16:22:11.0', '2022-09-13 16:24:33.0', '2022-09-13 16:24:57.0', '2022-09-13 16:26:15.0', '2022-09-15 08:42:14.0', '2022-09-15 08:43:13.0', '2022-09-15 08:44:05.0', '2022-09-15 09:43:49.0', '2022-09-15 12:53:24.0', '2022-09-16 08:52:56.0', '2022-09-16 10:45:10.0', '2022-09-16 10:45:21.0', '2022-09-16 10:45:34.0', '2022-09-16 10:45:43.0', '2022-09-16 12:55:15.0', '2022-09-19 09:50:07.0', 
    2024-3-13 13:53| 回复
  •   梅
    我只想把我数据库里建好的表,原字段直接展示出来,有没得什么方法不通过数据准备建完数据模型后再在excel表中操作?
    2024-3-13 14:03| 回复
  •   清澈的愚蠢
    看不出来,这太专业了。不好意思。
    2024-3-13 16:36| 回复
  •   君茗
     回复 
    Illegal mix of collations for operation ' IN '
    立项批复时间是字符串类型,还是日期类型? 如果是日期类型把空值变为NULL
    还有这个sql有必要用in吗?between and不行?
    2024-3-13 16:56| 回复

回复

使用道具 举报

发表于 2024-3-13 13:38:48
另外,你数据库里面这个字段的名称就是 “关闭计划(月份)”?

回复

使用道具 举报

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

7回帖数 0关注人数 372浏览人数
最后回复于:2024-3-13 13:38
快速回复 返回顶部 返回列表