Org.mozilla.javascript.EcmaError:TypeError:Cannot Read Property ' value ' from null

1, error description

version:2017-09-14 16:13:04 packageinfo:branch_smartbiv702_20170818 Java Query object class error at Smartbi.freequery.querydata.stor E.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. Error reason

This error occurs when you use the Report tool to create instrumentation analysis, and you can see from the error that there is a problem with the transmitted parameters and that you need to check the parameters.

Here, three parameters are passed: Organization ID, start date, and end date

3. Solutions