[指标管理3.1] 关于根据数据库表新建指标的问题

1184
10

李文义 初学数据Lv2

发表于2020-8-20 11:25

悬赏1

已解决

楼主
通过数据库表建立指标之后试计算,选择维度之后出现如片中的错误,请教一下是哪里设置出现了问题吗?版本号:企业版 V3.2.2_20191010142508

错误详情:ERROR:/ep/epibase/indicator.do?action=calcIndicatorData&dimFilters={"EDIM$35$5b2a053342444fa6838df8cb5e5fe336$部门$--":"EDIM$35$5b2a053342444fa6838df8cb5e5fe336$部门$KG$KG22$KG2204","EDIM$35$5b2a053342444fa6838df8cb5e5fe336$æŒ‡æ ‡å±‚çº§$--":"EDIM$35$5b2a053342444fa6838df8cb5e5fe336$æŒ‡æ ‡å±‚çº§$002"}&pageIndex=0&pageSize=20&rid=EPIB$5$f8ddadae6e4f4a2cb0b10daf0bd11254$V2837F93A21CA460E9F8FBC96A4CF7AA7
[color=rgb(138, 138, 138) !important]org.json.JSONException: JSONObject["部门"] not found.
  at org.json.JSONObject.get(JSONObject.java:473)
  at org.json.JSONObject.getString(JSONObject.java:654)
  at com.esen.epibase.indicatorcalcdata.IndicatorCalcHelper.getFilterCondition(IndicatorCalcHelper.java:762)
  at com.esen.epibase.indicatorcalcdata.IndicatorCalcHelper.calIndicator(IndicatorCalcHelper.java:693)
  at com.esen.epibase.indicatorcalcdata.IndicatorCalcHelper.getBaseSql(IndicatorCalcHelper.java:482)
  at com.esen.epibase.indicator.IndicatorServiceImpl.getCalcIndicatorData(IndicatorServiceImpl.java:2803)
  at com.esen.epibase.indicator.IndicatorServiceImpl$$FastClassBySpringCGLIB$$60538b6e.invoke()
  at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:669)
  at com.esen.epibase.indicator.IndicatorServiceImpl$$EnhancerBySpringCGLIB$$2816d4cb.getCalcIndicatorData()
  at com.esen.epibase.indicator.ActionIndicator.calcIndicatorData(ActionIndicator.java:868)
  at sun.reflect.GeneratedMethodAccessor1210.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
  at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at com.esen.eacl.web.FilterLoginCheck.doFilter(FilterLoginCheck.java:161)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at com.esen.ecascore.AbstractCasFilter.doFilter(AbstractCasFilter.java:46)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at com.esen.ecascore.AbstractCasFilter.doFilter(AbstractCasFilter.java:46)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at com.esen.ecascore.AbstractCasFilter.doFilter(AbstractCasFilter.java:46)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:105)
  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)
  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at com.esen.eweb.web.HttpMethodFilter.doFilterInternal(HttpMethodFilter.java:41)
  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
  at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
  at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137)
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
  at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2575)
  at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2564)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.lang.Thread.run(Thread.java:748)



JavaScript StackTrace:
Error: JSONObject["部门"] not found.
--detailmessage--
QueryObj ERROR:/ep/epibase/indicator.do?action=calcIndicatorData&dimFilters=%7B%22EDIM%2435%245b2a053342444fa6838df8cb5e5fe336%24%E9%83%A8%E9%97%A8%24--%22%3A%22EDIM%2435%245b2a053342444fa6838df8cb5e5fe336%24%E9%83%A8%E9%97%A8%24KG%24KG22%24KG2204%22%2C%22EDIM%2435%245b2a053342444fa6838df8cb5e5fe336%24%E6%8C%87%E6%A0%87%E5%B1%82%E7%BA%A7%24--%22%3A%22EDIM%2435%245b2a053342444fa6838df8cb5e5fe336%24%E6%8C%87%E6%A0%87%E5%B1%82%E7%BA%A7%24002%22%7D&pageIndex=0&pageSize=20&rid=EPIB%245%24f8ddadae6e4f4a2cb0b10daf0bd11254%24V2837F93A21CA460E9F8FBC96A4CF7AA7
org.json.JSONException: JSONObject["部门"] not found.
  at org.json.JSONObject.get(JSONObject.java:473)
  at org.json.JSONObject.getString(JSONObject.java:654)
  at com.esen.epibase.indicatorcalcdata.IndicatorCalcHelper.getFilterCondition(IndicatorCalcHelper.java:762)
  at com.esen.epibase.indicatorcalcdata.IndicatorCalcHelper.calIndicator(IndicatorCalcHelper.java:693)
  at com.esen.epibase.indicatorcalcdata.IndicatorCalcHelper.getBaseSql(IndicatorCalcHelper.java:482)
  at com.esen.epibase.indicator.IndicatorServiceImpl.getCalcIndicatorData(IndicatorServiceImpl.java:2803)
  at com.esen.epibase.indicator.IndicatorServiceImpl$$FastClassBySpringCGLIB$$60538b6e.invoke()
  at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:669)
  at com.esen.epibase.indicator.IndicatorServiceImpl$$EnhancerBySpringCGLIB$$2816d4cb.getCalcIndicatorData()
  at com.esen.epibase.indicator.ActionIndicator.calcIndicatorData(ActionIndicator.java:868)
  at sun.reflect.GeneratedMethodAccessor1210.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
  at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at com.esen.eacl.web.FilterLoginCheck.doFilter(FilterLoginCheck.java:161)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at com.esen.ecascore.AbstractCasFilter.doFilter(AbstractCasFilter.java:46)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at com.esen.ecascore.AbstractCasFilter.doFilter(AbstractCasFilter.java:46)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at com.esen.ecascore.AbstractCasFilter.doFilter(AbstractCasFilter.java:46)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:105)
  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)
  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at com.esen.eweb.web.HttpMethodFilter.doFilterInternal(HttpMethodFilter.java:41)
  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
  at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
  at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137)
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
  at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2575)
  at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2564)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.lang.Thread.run(Thread.java:748)

--messageInfo--
rootExceptionClass=org.json.JSONException
at Object.throwError (http://10.200.7.30:8080/ep/eui/eui.js:2597:19)
at QueryObj.checkResult (http://10.200.7.30:8080/ep/eui/eui.js:3908:9)
at QueryObj._onreadystatechange (http://10.200.7.30:8080/ep/eui/eui.js:3564:11)
at XMLHttpRequest.hp.onreadystatechange (http://10.200.7.30:8080/ep/eui/eui.js:3636:10)


确定详情




最近看过此主题的会员

liu20220622

bbk

最佳答案

xxxl

发表于2020-8-20 11:25

只看该作者

取消 关注该作者的回复

李文义 发表于 2020-8-20 14:58
维度我也重新建了绑定了,而且不止这一个维度,我的两个维度都不可以,都报错sweat.gif ...

这应该是您的数据存在问题导致的
10个回答

只看楼主

xxxl 数据领袖Lv6

发表于2020-8-20 11:41

只看该作者

取消 关注该作者的回复

沙发

您有绑定这个维度吗 这个维表是否存在呢

李文义 初学数据Lv2

发表于2020-8-20 11:45

只看该作者

取消 关注该作者的回复

板凳

有的呢

xxxl 数据领袖Lv6

发表于2020-8-20 13:40

只看该作者

取消 关注该作者的回复

地板

重新在建指标再关联维度试试

李文义 初学数据Lv2

发表于2020-8-20 14:19

只看该作者

取消 关注该作者的回复

5#

重建了还是不行

xxxl 数据领袖Lv6

发表于2020-8-20 14:44

只看该作者

取消 关注该作者的回复

6#


重建了 还是这个维度出的问题吗换个维度呢

李文义 初学数据Lv2

发表于2020-8-20 14:58

只看该作者

取消 关注该作者的回复

7#

xxxl 发表于 2020-8-20 14:44
重建了 还是这个维度出的问题吗换个维度呢

维度我也重新建了绑定了,而且不止这一个维度,我的两个维度都不可以,都报错

xxxl 数据领袖Lv6

发表于2020-8-20 11:25

只看该作者

取消 关注该作者的回复

8#

李文义 发表于 2020-8-20 14:58
维度我也重新建了绑定了,而且不止这一个维度,我的两个维度都不可以,都报错sweat.gif ...

这应该是您的数据存在问题导致的

李文义 初学数据Lv2

发表于2020-8-20 16:09

只看该作者

取消 关注该作者的回复

9#

那我再试试看吧,或者是我流程上面出错了,有没有具体的操作步骤发给我们看看

xxxl 数据领袖Lv6

发表于2020-8-20 16:15

只看该作者

取消 关注该作者的回复

10#

李文义 发表于 2020-8-20 16:09
那我再试试看吧,或者是我流程上面出错了,有没有具体的操作步骤发给我们看看 ...

这是有指标管理的教学视频https://www.esensoft.com/learn/training.html以及指标管理的操作手册 指标管理平台_V3.1操作手册V1.2.pdf (4.38 MB, 下载次数: )

李文义 初学数据Lv2

发表于2020-8-20 16:27

只看该作者

取消 关注该作者的回复

11#

好的,谢谢

登录后可回答问题,请登录注册

快速回复 返回顶部 返回列表

小时

全天响应

分钟

快速处理问题

工程师强势助力

明星产品
解决方案
联系合作

渠道咨询电话:137-0120-6790

技术支持QQ:400-0011-866(工作日9:00-18:00)

产品建议邮箱yixin@esensoft.com

关注我们

扫TA学习更多干货

一对一专家交流

版权所有© 2006-2024 北京亿信华辰软件有限责任公司 京ICP备07017321号 京公网安备11010802016281号