Hello,
I am working with knowage community edition and i keep getting the error in one of my cockpits : unable to load dataset. Even though the daaset is present and i can preview the data in dataset => preview and the query seems to be ok. All the other cockpits using data from the same data source are ok.
In the file knowageCockpitEngine.log i have the following output. Do you have an idea to what might be the problem ? :
used by: it.eng.spagobi.utilities.exceptions.SpagoBIServiceException: An unexpected error occured while executing service: JsonChartTemplateService.getJSONChartTemplateForCockpit
at it.eng.spagobi.engine.chart.api.JsonChartTemplateService.getJSONChartTemplateForCockpit(JsonChartTemplateService.java:159)
at it.eng.spagobi.engine.chart.api.JsonChartTemplateService.getDataAndConf(JsonChartTemplateService.java:393)
... 77 more
Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'roundTo' in class java.lang.Class threw exception java.lang.NumberFormatException: empty String at /chart/templates/chartJs/bar_chart_chartJs.vm[line 244, column 51]
at org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:243)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:187)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280)
at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:369)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:420)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:420)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
at org.apache.velocity.Template.merge(Template.java:356)
at org.apache.velocity.Template.merge(Template.java:260)
at it.eng.spagobi.engine.chart.util.ChartEngineUtil.applyTemplate(ChartEngineUtil.java:335)
at it.eng.spagobi.engine.chart.api.JsonChartTemplateService.getJSONChartTemplateForCockpit(JsonChartTemplateService.java:151)
... 78 more
Caused by: java.lang.NumberFormatException: empty String
Thank you in advance !
