Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

cockpit dataset error chart datasource installer datasets installation widget parameters business-model olap knowage knowage_7_1 integration login knowage_7_1-ce report-designer cross-navigation analyticaldriver

Error to "show sub totals" in "Static Pivot Table" (CrossTab) Widget

0 votes
1 view

Ok, let me explain better.

The problem is in "Static Pivot Table".  When I made the structure like (parent column -> child column -> Value)  the information show me well, but when check "Show Sub-totals" on column section then show a pop up windows with the error message:

(selected option)

Image1

Error popup:

Image2

it.eng.knowage.engine.cockpit.api.crosstable.CrosstabResource.getSortedCrosstabUpdated(CrosstabResource.java:201)
    sun.reflect.GeneratedMethodAccessor1350.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:498)
    org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
    org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
    org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
    org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
    org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
    org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
    org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
    org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
    org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
    org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

root cause

it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An unexpecte error occured while genereting cross tab html
    it.eng.knowage.engine.cockpit.api.crosstable.CrosstabBuilder.createCrossTable(CrosstabBuilder.java:116)
    it.eng.knowage.engine.cockpit.api.crosstable.CrosstabBuilder.getSortedCrosstab(CrosstabBuilder.java:76)
    it.eng.knowage.engine.cockpit.api.crosstable.CrosstabResource.getSortedCrosstabUpdated(CrosstabResource.java:196)
    sun.reflect.GeneratedMethodAccessor1350.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:498)
    org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
    org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
    org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
    org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
    org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
    org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
    org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
    org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
    org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
    org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

root cause

it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Error while serializing crossTab
    it.eng.knowage.engine.cockpit.api.crosstable.CrossTabHTMLSerializer.serialize(CrossTabHTMLSerializer.java:98)
    it.eng.knowage.engine.cockpit.api.crosstable.CrossTab.getHTMLCrossTab(CrossTab.java:2509)
    it.eng.knowage.engine.cockpit.api.crosstable.CrosstabBuilder.createCrossTable(CrosstabBuilder.java:111)
    it.eng.knowage.engine.cockpit.api.crosstable.CrosstabBuilder.getSortedCrosstab(CrosstabBuilder.java:76)
    it.eng.knowage.engine.cockpit.api.crosstable.CrosstabResource.getSortedCrosstabUpdated(CrosstabResource.java:196)
    sun.reflect.GeneratedMethodAccessor1350.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:498)
    org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
    org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
    org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
    org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
    org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
    org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
    org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
    org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)

in Cockpit, Dashboard and Console by (180 points)
edited by

1 Answer

0 votes
Hi,

sorry but we need more information, just to understand :

Are you showing measures on columns or on rows?

Have you actived subtotals both on columns and on rows?

Can you try to active only one of them (just to check who gives the error) ?

If you active only the Total visualization it work ?

Thank you.
by (4.4k points)
Thanks Antonella, I re-maked the question.
by (180 points)
Powered by Question2Answer
...