用户CA4bS5191167(提问者) 2021-08-06 15:03:39 INFO LogLabel 20 sql create: 1ms sql: select T_CB1331.`village_id` as `__fcol_0` from (SELECT id as village_id,village_name FROM sams_housing_village_copy1 WHERE delete_status = 0 ) as `T_CB1331` where T_CB1331.`village_name` in (\'东南青年汇新门口店\') group by 1 info: PerformSessionInfo{type=0, user=\'admin\', category=\'null\', subCategory=\'文本下拉\'} 2021-08-06 15:03:39 INFO LogLabel 20 slice sql execute: 22ms 2021-08-06 15:03:39 INFO LogLabel 20 dataModel build: 0ms, row : 0, column : 0 这段SQL在本地是有数据的，但是好像没有建立数据模型

回复

2021-08-06 15:08 

取消 回复

zsh331 回复 用户CA4bS5191167(提问者) 抽取还是实时数据？抽取数据的话，更新下业务包；问一下，使用的finebi哪个版本

回复

2021-08-06 15:10 

取消 回复

用户CA4bS5191167(提问者) 2021-08-06 15:10:09 WARN cache key:com.finebi.ehcache.CacheKeyWrapper@ac6f3877 and value:null occur exception java.lang.IllegalArgumentException at com.fr.third.guava.base.Preconditions.checkArgument(Preconditions.java:127) at com.finebi.mem.model.SizeOfEstimator.sizeOf(SizeOfEstimator.java:16) at com.finebi.ehcache.FlashSizeOfEngine.sizeOf(FlashSizeOfEngine.java:14) at com.fr.third.net.sf.ehcache.pool.impl.AbstractPoolAccessor.add(AbstractPoolAccessor.java:63) at com.fr.third.net.sf.ehcache.store.MemoryStore.put(MemoryStore.java:278) at com.fr.third.net.sf.ehcache.Cache.putInternal(Cache.java:1608) at com.fr.third.net.sf.ehcache.Cache.put(Cache.java:1534) at com.fr.third.net.sf.ehcache.Cache.put(Cache.java:1499) at com.finebi.ehcache.Cache.put(Cache.java:23) at com.finebi.ehcache.AsyncCache$CacheWorker.run(AsyncCache.java:121) at com.finebi.base.concurrent.PrintExceptionExecutorService.lambda$wrap$0(ExecutorServiceFactory.java:310) 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) 2021-08-06 15:10:09 INFO [DirectThread] parent: http-nio-37799-exec-7, child: direct-sql-timeout-42-worker-3 2021-08-06 15:10:09 INFO LogLabel 24 sql create: 1ms sql: select T_CB1331.`village_name` as `__fcol_0` from (SELECT id as village_id,village_name FROM sams_housing_village_copy1 WHERE delete_status = 0 ) as `T_CB1331` where ( T_CB1331.`village_name` not in (\'东南青年汇景祥店2\') or T_CB1331.`village_name` is null ) group by 1 info: PerformSessionInfo{type=0, user=\'admin\', category=\'测试租客信息\', subCategory=\'文本下拉\'} 2021-08-06 15:10:09 INFO LogLabel 24 slice sql execute: 4ms 2021-08-06 15:10:09 INFO LogLabel 24 dataModel build: 0ms, row : 28, column : 1 2021-08-06 15:10:09 INFO tree sort cost time : 0ms 2021-08-06 15:10:10 WARN cache key:com.finebi.ehcache.CacheKeyWrapper@8ad87b2c and value:null occur exception java.lang.IllegalArgumentException at com.fr.third.guava.base.Preconditions.checkArgument(Preconditions.java:127) at com.finebi.mem.model.SizeOfEstimator.sizeOf(SizeOfEstimator.java:16) at com.finebi.ehcache.FlashSizeOfEngine.sizeOf(FlashSizeOfEngine.java:14) at com.fr.third.net.sf.ehcache.pool.impl.AbstractPoolAccessor.add(AbstractPoolAccessor.java:63) at com.fr.third.net.sf.ehcache.store.MemoryStore.put(MemoryStore.java:278) at com.fr.third.net.sf.ehcache.Cache.putInternal(Cache.java:1608) at com.fr.third.net.sf.ehcache.Cache.put(Cache.java:1534) at com.fr.third.net.sf.ehcache.Cache.put(Cache.java:1499) at com.finebi.ehcache.Cache.put(Cache.java:23) at com.finebi.ehcache.AsyncCache$CacheWorker.run(AsyncCache.java:121) at com.finebi.base.concurrent.PrintExceptionExecutorService.lambda$wrap$0(ExecutorServiceFactory.java:310) 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) 2021-08-06 15:10:10 INFO [DirectThread] parent: http-nio-37799-exec-8, child: direct-sql-timeout-42-worker-3 2021-08-06 15:10:10 INFO [HepPlanner] onMatch rule: ProjectReduce, update: true, description: -GP-P 2021-08-06 15:10:10 INFO LogLabel 25 sql create: 1ms sql: select T_CB1331.`village_id` as `__fcol_0` from (SELECT id as village_id,village_name FROM sams_housing_village_copy1 WHERE delete_status = 0 ) as `T_CB1331` where T_CB1331.`village_name` in (\'东南青年汇景祥店\') group by 1 info: PerformSessionInfo{type=0, user=\'admin\', category=\'null\', subCategory=\'文本下拉\'} 2021-08-06 15:10:10 INFO LogLabel 25 slice sql execute: 3ms 2021-08-06 15:10:10 INFO LogLabel 25 dataModel build: 0ms, row : 0, column : 0 2021-08-06 15:10:10 INFO tree sort cost time : 0ms 2021-08-06 15:10:10 WARN 未能找到字段[cb1331d998575e90_village_name], make sure that the condition is related with the widget 2021-08-06 15:10:10 INFO [DirectThread] parent: http-nio-37799-exec-8, child: direct-chart-group-data-pool-46-thread-3 2021-08-06 15:10:10 INFO current thread direct-chart-group-data-pool-46-thread-3 belong to thread http-nio-37799-exec-8 2021-08-06 15:10:10 WARN 未能找到字段[cb1331d998575e90_village_name], make sure that the condition is related with the widget 2021-08-06 15:10:10 INFO This filter not support entity condition 2021-08-06 15:10:10 INFO *************** Widget Session info start *************** SID : 407b1a8f-5740-4040-9430-30b97282dc15 reportId : cf947b996ee94977946098845d481097 reportName : ___6d588b9b79d55bad4f8560ba widgetId : ec5846bf2624c187 widgetName : ___6739543354077ecb4e92 userId : b5f0c2ee-640f-4039-a4d4-918b55354898 userName : ___0072002a00670066000a *************** Widget Session info end *************** 2021-08-06 15:10:12 INFO [UpdateDependCountCache] cost:15 完整的报错信息 实时数据 最新版fineBI

回复

2021-08-06 15:10 

取消 回复

用户CA4bS5191167(提问者) village_name为英文也会报错，但是不影响使用

回复

2021-08-06 15:12 

取消 回复

zsh331 回复 用户CA4bS5191167(提问者) 控件值，是直接从供选项选择还是手动输入的？

回复

2021-08-06 15:14 

取消 回复

还有5条评论 点击查看

评论