Error running Google Sheet report

David Registro shared this problem 2 years ago
Resolved

Running report based on a google sheet, and the report fails to load with :

"Oh No! An error has occurred"


Behind the scenes (yellowfin.log or Tomcat window) the following error is logged:

ERROR (ReportDefinitionModelReportImpl:isEnableApplicationLevelFilters) - Error: java.lang.NullPointerException

java.lang.NullPointerException

at com.hof.pool.jdbc.ThirdPartyInfo.getDatasetColumns(ThirdPartyInfo.java:50)

at com.hof.pool.jdbc.ThirdPartyInfo.allowsColumnsAsFilters(ThirdPartyInfo.java:99)

at com.hof.mi.models.report.ReportDefinitionModelReportImpl.isEnableApplicationLevelFilters(ReportDefinitionModelReportImpl.java:1570)

at sun.reflect.GeneratedMethodAccessor384.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.json.JSONObject.populateMap(JSONObject.java:1064)

at org.json.JSONObject.<init>(JSONObject.java:327)

at org.json.JSONObject.<init>(JSONObject.java:298)

at com.hof.jsp.mi_005freport_005foutput_jsp._jspService(mi_005freport_005foutput_jsp.java:158)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

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 org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:747)

at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:485)

at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:410)

at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:337)

at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1083)

at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:396)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:232)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)

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 org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:747)

at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:485)

at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:410)

at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:337)

at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1083)

at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:396)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:232)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)

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.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43)

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:220)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)


ERROR (ThirdPartyResultSetGenerator:generateResultSet) - Error running Third Party report:

Connector: Google Sheets

Report: Google Sheet Report

java.lang.NullPointerException

at com.hof.pool.ThirdPartyConnection.getDatasetFilters(ThirdPartyConnection.java:109)

at com.hof.util.ThirdPartyAction.getDatasetFiltersMap(ThirdPartyAction.java:272)

at com.hof.report.result.ThirdPartyResultSetGenerator.A(ThirdPartyResultSetGenerator.java:462)

at com.hof.report.result.ThirdPartyResultSetGenerator.generateResultSet(ThirdPartyResultSetGenerator.java:96)

at com.hof.mi.process.ReportRunner.J(ReportRunner.java:987)

at com.hof.mi.process.ReportRunner.runReport(ReportRunner.java:297)

at com.hof.mi.util.background.ReportQueueItem.process(ReportQueueItem.java:61)

at com.hof.mi.util.background.ReportQueueItem.process(ReportQueueItem.java:25)

at com.hof.mi.util.background.ExecutionQueue$TaskRunner.call(ExecutionQueue.java:388)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Comments (1)

photo
1

This specific error occurs when the google sheet itself can no longer be found.

So it can happen if the sheet is deleted, or the data source credentials have changed to a user who does not have permissions to see the sheet used.