1、错误描述
version: 2017-09-14 16:13:04
packageinfo: Branch_SmartbiV702_20170818
Java查询对象类错误
at smartbi.freequery.querydata.store.DBSQLResultStore.executeInJavaQuery(DBSQLResultStore.java:1924)
at ...(...)
at smartbi.JavaScriptJavaQuery.getGridData(JavaScriptJavaQuery.java:279)
Caused by: org.mozilla.javascript.EcmaError: TypeError: Cannot read property "value" from null (Smartbi#118)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3785)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3763)
at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:3791)
at org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntime.java:3810)
at org.mozilla.javascript.ScriptRuntime.undefReadError(ScriptRuntime.java:3823)
at org.mozilla.javascript.ScriptRuntime.getObjectProp(ScriptRuntime.java:1508)
at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1398)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:854)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:164)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:426)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3178)
at org.mozilla.javascript.Context.callFunctionWithContinuations(Context.java:1204)
at smartbi.JavaScriptJavaQuery.getGridData(JavaScriptJavaQuery.java:279)
at smartbi.freequery.querydata.store.DBSQLResultStore.executeInJavaQuery(DBSQLResultStore.java:1708)
at smartbi.freequery.querydata.store.DBSQLResultStore.executeInDatabase(DBSQLResultStore.java:1287)
at smartbi.freequery.querydata.store.DBSQLResultStore.ensureGridDataInMemDB(DBSQLResultStore.java:4321)
at smartbi.freequery.querydata.store.DBSQLResultStore.getGridDataInternal(DBSQLResultStore.java:3739)
at smartbi.freequery.querydata.store.SQLResultStore.getGridData(SQLResultStore.java:143)
at smartbi.decisionpanel.dashboard.TPDataUtil.getGridData(TPDataUtil.java:159)
at smartbi.decisionpanel.dashboard.TPDataUtil.getGridDataWithFuture(TPDataUtil.java:131)
at smartbi.decisionpanel.dashboard.TPDataUtil.getChartData(TPDataUtil.java:63)
at smartbi.decisionpanel.dashboard.DashboardService.getChartOptionsInPage(DashboardService.java:1208)
at smartbi.decisionpanel.dashboard.DashboardService.syncAndGetOptions(DashboardService.java:1248)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at smartbi.framework.rmi.ClientService.execute(Smartbi:118)
at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:197)
at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:141)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
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 smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:140)
at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:129)
at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:152)
at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:55)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:93)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:111)
at smartbi.freequery.filter.Filter.doFilter(Filter.java:36)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:59)
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:218)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
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:1115)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
2、错误原因
在使用报表工具创建仪表分析,出现了这个错误;由错误提示可知,是传输的参数有问题,需要检查一下参数。
这里,传了三个参数:组织ID、开始日期和结束日期
3、解决办法