SQL Power Software Forum

Hi There,

My KPI drill down screen currently has 3 dates dimensions (Dec 2007, Jan 2008, Feb 200

.

When i drill down on Dec 2007 or Jan 2008, the Dashboard works fine. But when i drill down on Feb 2008, i get this error:

"The application has experienced an internal inconsistency. Please contact SQLPower Support."

Not sure what's different about this date dimension than the others. Also, i did not have this problem before. I dont remember doing any major changes to the KPI.

Please help!
thanks

Ooops, here, i forgot to include the html source for that error.

I believe this is the main part you need but i also included the entire source page.

<div class="error">The application has experienced an internal inconsistency. Please contact SQLPower Support.</div>
<!-- Details:
java.lang.IllegalStateException: row has 28 elements, but oldColCount is 37
at ca.sqlpower.dashboard.DashboardCachedRowSet.addDerivedColumn(DashboardCachedRowSet.java:371)
at ca.sqlpower.dashboard.DrillDownResultChunk.remap(DrillDownResultChunk.java:364)
at ca.sqlpower.dashboard.DrillDownResultChunk.execute(DrillDownResultChunk.java:306)
at ca.sqlpower.dashboard.DrillDownResultChunk.execute(DrillDownResultChunk.java:295)
at ca.sqlpower.dashboard.DrillDownResultChunk.<init>(DrillDownResultChunk.java:71)
at ca.sqlpower.dashboard.DrillDownResultSet.next(DrillDownResultSet.java:121)
at ca.sqlpower.dashboard.html.KpiDrillDownHTMLFormatter.formatToStream(KpiDrillDownHTMLFormatter.java:145)
at ca.sqlpower.dashboard.html.KpiDrillDownHTMLFormatter.formatToStream(KpiDrillDownHTMLFormatter.java:101)
at ca.sqlpower.dashboard.html.KpiResultHTMLFormatter.formatToStream(KpiResultHTMLFormatter.java:106)
at ca.sqlpower.sql.WebResultFormatter.formatToStream(WebResultFormatter.java:367)
at org.apache.jsp.kpi_005fdrill_005fdown_jsp._jspService(kpi_005fdrill_005fdown_jsp.java:1082)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:105

at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:451)
at org.apache.struts.action.RequestProcessor.processActionForward(RequestProcessor.java:401)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1420)
at ca.sqlpower.dashboard.servlets.DashboardActionServlet.process(DashboardActionServlet.java:54)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:502)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:12

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

-->

Does it help if you flush the cache?

As an administrative user, click the "Admin" link at the top of the page, then "Data Cache Stats," and finally "Flush Entire Cache Now."

If flushing the cache does help, we'll have to do more work to fix this bug. It will help if you have a good memory about everything that has happened to your data and KPIs in the last while... something that happened recently will have caused this problem.

If flushing the cache doesn't help, it's probably just a configuration problem. This should be relatively easy to track down and fix.

-Jonathan

Hi Jonathan,

I flushed the cache and the problem is solved. I can drill down on that date without getting any errors.

If it happens again, i will try to remember what steps led to it.

Thanks for the temporary solution!