显示销售字段不在模型中

BuildTime: 2025-04-23 17:27:14 TAG: Hotfix_SmartbiV11_20250421 Tid: null HostName: certcs-587b8f5b98-6p8xb 数据模型引擎: V2.0 smartbix.SmartbiXException: 组件 [ 产品子类销售数据 ] 查询失败 -> 组件中拖选的查询字段：[销售利润]不存在模型或者自定义字段中，模型ID:[I8a808295019939ef39ef307d019a248a2bc84917] at smartbix.SmartbiXException.create(SmartbiXException.java:68) at smartbix.augmenteddataset.service.AugmentedDataSetQueryServiceAdapter.execute(AugmentedDataSetQueryServiceAdapter.java:131) at smartbix.augmenteddataset.service.SmartbiXAugmentedDataSet.execute(SmartbiXAugmentedDataSet.java:156) at smartbix.service.ProviderService.executeQuery(ProviderService.java:150) at smartbix.dataset.service.QueryService.executeQuery(QueryService.java:34) at smartbix.dataset.service.QueryService$$FastClassBySpringCGLIB$$611408c2.invoke() at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792) at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762) at smartbixlibs.org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:49) at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762) 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:762) at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707) at smartbix.dataset.service.QueryService$$EnhancerBySpringCGLIB$$dcc664d9.executeQuery() at smartbix.page.service.QueryResultHolder.getResult(QueryResultHolder.java:52) at smartbix.page.service.BatchQueriesModel.getResult(BatchQueriesModel.java:171) at smartbix.page.service.BatchQueriesModel.execute(BatchQueriesModel.java:115) at smartbix.page.executor.common.CommonExecutor.refresh(CommonExecutor.java:200) at smartbix.page.service.PageService.lambda$queryData$1(PageService.java:1909) at smartbi.cachemanager.ehcache.EhCacheCacheManager.get(EhCacheCacheManager.java:52) at smartbi.cachemanager.CommonCacheService.get(CommonCacheService.java:59) at smartbix.page.service.PageService.queryData(PageService.java:1920) at smartbix.page.service.PageService$12.call(PageService.java:5567) at smartbix.page.service.PageService$12.call(PageService.java:5561) at smartbi.executor.NamedCallable.call(NamedCallable.java:14) at smartbi.executor.extension.SmartbiExtensionChain.doExtend(SmartbiExtensionChain.java:47) at smartbix.util.RequestCxtExtension.doExtend(RequestCxtExtension.java:106) at smartbi.executor.extension.SmartbiExtensionChain.doExtend(SmartbiExtensionChain.java:45) at smartbi.executor.extension.MonitorExtension.doExtend(MonitorExtension.java:48) at smartbi.executor.extension.SmartbiExtensionChain.doExtend(SmartbiExtensionChain.java:45) at smartbi.executor.SmartbiExecutorService.lambda$submit$2(SmartbiExecutorService.java:88) 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:750) Caused by: java.lang.IllegalArgumentException: 组件中拖选的查询字段：[销售利润]不存在模型或者自定义字段中，模型ID:[I8a808295019939ef39ef307d019a248a2bc84917] at smartbix.augmenteddataset.helper.SmartCubeQueryBuilder.checkField(SmartCubeQueryBuilder.java:138) at smartbix.augmenteddataset.helper.SmartCubeQueryBuilder.convertSmartbiCubeQueryFromDefaultQuery(SmartCubeQueryBuilder.java:220) at smartbix.augmenteddataset.smartcube.QueryPreprocessorSvcImpl.convertDefaultQueryToQuery(QueryPreprocessorSvcImpl.java:198) at smartbix.smartcube.gateway.report.preprocess.QueryBuilder$.build(QueryBuilder.scala:13) at smartbix.smartcube.gateway.report.ReportQueryService$.queryData(ReportQueryService.scala:45) at smartbix.smartcube.gateway.report.ReportQueryService.queryData(ReportQueryService.scala) at smartbix.augmenteddataset.service.AugmentedDataSetQueryServiceAdapter.lambda$executeForSmartCubeByDataset$3(AugmentedDataSetQueryServiceAdapter.java:261) at smartbi.monitor.MetricHelper$.withSpan(MetricHelper.scala:148) at smartbi.monitor.MetricHelper.withSpan(MetricHelper.scala) at smartbix.augmenteddataset.service.AugmentedDataSetQueryServiceAdapter.executeForSmartCubeByDataset(AugmentedDataSetQueryServiceAdapter.java:252) at smartbix.augmenteddataset.service.AugmentedDataSetQueryServiceAdapter.executeForSmartCube(AugmentedDataSetQueryServiceAdapter.java:241) at smartbix.augmenteddataset.service.AugmentedDataSetQueryServiceAdapter.getDataIterator(AugmentedDataSetQueryServiceAdapter.java:145) at smartbix.augmenteddataset.service.AugmentedDataSetQueryServiceAdapter.execute(AugmentedDataSetQueryServiceAdapter.java:124) ... 37 more 组件被删除这个组件后还是会出现这个错误是为什么呢？但是销售字段就在我现在的模型中

在模型中校验一下看看有没有垃圾数据吧

是不是字段后来在数据模型中删除了呢？

是不是可能有隐藏的组件也用到了原来的这个字段。比如隐藏的筛选器等等之类的。