[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
fromSDKTemplateToObjTemplate: Error while converting SDKTemplate into ObjTemplate.  XML
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Author Message
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

Hi Community,

Tried to create a chart template and populate it on the server. When executing it, I receive the title, the axis and the legend + the error fromSDKTemplateToObjTemplate: Error while converting SDKTemplate into ObjTemplate.

The dataset gives back the data okay.

Is there a guide explaining how to create a chart type document from zero? I would like to be able to create a linkable document.

Thanks alot,

Zsolt
brianjohnson.spw

Newby

Joined: 16/10/2012 09:56:21
Messages: 29
Offline

Hi Zsolt

please can you post your template as well as your query. What kind of chart are you building Highchart,extchart?

Thanks

Brian
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

Hi Brian,

I will try to reproduce the error once more and send you all the thing. Issue is that I had to hack a demo together, and to be able to do that, I created 20+ documents in 3 days :) have no clue which is crashing for what.

Cheers,

Zsolt
brianjohnson.spw

Newby

Joined: 16/10/2012 09:56:21
Messages: 29
Offline

perhaps then it would be easier if we focused our energy to get a specific report running first, what do you have in mind? and then we can follow through on that
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

The biggest issue I have now is the Linkablebar. I created a bar chart which is set to be linkable. Normally when I move the cursor over the bar, I should see the one I am selecting. This is not the case. I am able to call the related report, but not able to pass the variable.

Do you know, by any chances, what are the steps to make this work? Below some code examples:

<HIGHCHART type='linkablebar'>
<CHART type='bar'/>
<TITLE text='Histogram of Expenses'/>
<SUBTITLE text='by Categories' />
<X_AXIS title='Categories' alias='category'/>
<Y_AXIS min='0'>
<TITLE text='Value' align='high' orientation='horizontal'/>
</Y_AXIS>
<LEGEND layout='horizontal'
align='right'
verticalAlign='top'
x='-100'
y='100'
floating='true'
borderWidth='1'
backgroundColor='#FFFFFF'
shadow='true'/>
<PLOT_OPTIONS>
<BAR>
<DATA_LABELS enable='true'/>
</BAR>
</PLOT_OPTIONS>
<SERIES_LIST>
<SERIES name="Budgeted Value" alias="Bvalue" />
<SERIES name="Actual Value" alias="Avalue" />
</SERIES_LIST>
<DRILL document="PFCEAP5_007a">
<PARAM_LIST>
<PARAM name="category" type="RELATIVE" value="category" />
</PARAM_LIST>
</DRILL>
</HIGHCHART>


I would like to call the PFCEAP5_007a report with the value of the selected category and refresh the table with the related data. The report is called upon, but the message is always the:

org.eclipse.birt.report.engine.api.impl.ParameterValidationException: Required parameter Category is not set.
at org.eclipse.birt.report.engine.api.impl.EngineTask.validateAbstractScalarParameter(EngineTask.java:770)
at org.eclipse.birt.report.engine.api.impl.EngineTask.access$0(EngineTask.java:756)
at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterValidationVisitor.visitScalarParameter(EngineTask.java:686)
at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterVisitor.visit(EngineTask.java:1400)
at org.eclipse.birt.report.engine.api.impl.EngineTask.doValidateParameters(EngineTask.java:670)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:94)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at it.eng.spagobi.engines.birt.BirtReportServlet.runReport(BirtReportServlet.java:690)
at it.eng.spagobi.engines.birt.BirtReportServlet.service(BirtReportServlet.java:159)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:193)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:191)
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:845)
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(Thread.java:722)

Your help is greatly appreciated,

Zsolt

ps: I think I am able to manage the rest - well, so far
brianjohnson.spw

Newby

Joined: 16/10/2012 09:56:21
Messages: 29
Offline

OK

<PARAM name="category" type="RELATIVE" value="category" />

is incorrect based on what you are requesting

<PARAM name="Url Name of the parameter in PFCEAP5_007a" type="CATEGORY"/>
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

brianjohnson.spw wrote:OK

<PARAM name="category" type="RELATIVE" value="category" />

is incorrect based on what you are requesting

<PARAM name="Url Name of the parameter in PFCEAP5_007a" type="CATEGORY"/>


Hi Brian,

The parameter I am trying to send over to the other report is called category. Actually it is an expense category.

Zsolt
brianjohnson.spw

Newby

Joined: 16/10/2012 09:56:21
Messages: 29
Offline

Just check for me what you have set as the Url name for category, if it is category

then it should look as follows

<PARAM name="category" type="CATEGORY"/>
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

It was like that, I will set it back to this in few moment, just finishing something else. On the other report, I have the query like ...where category=?, created a parameter called param_1 and assigned it to a report parameter called category. When I try it in Studio it works, when I try it on the server it does not.

Zsolt
brianjohnson.spw

Newby

Joined: 16/10/2012 09:56:21
Messages: 29
Offline

from your last post you had type set to "RELATIVE" and not "CATEGORY". Please can you post the template for your other report
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.6.2.r262_v20110209 Build <2.6.2.v20110214-1523></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<parameters>
<scalar-parameter name="Category" id="35">
<property name="hidden">false</property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="PFCEAP5_007a" id="7">
<list-property name="privateDriverProperties">
<ex-property>
<name>disabledMetadataBidiFormatStr</name>
</ex-property>
<ex-property>
<name>disabledContentBidiFormatStr</name>
</ex-property>
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
</list-property>
<property name="odaDriverClass">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="odaURL">jdbc:sqlserver://localhost\sqlexpress:1433;databaseName=ceasp</property>
<property name="odaUser">sa</property>
<encrypted-property name="odaPassword" encryptionID="base64">UHJpbWExMjNWZXJh</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="PFCEAP5_007a" id="8">
<list-property name="columnHints">
<structure>
<property name="columnName">bvalue</property>
<text-property name="displayName">bvalue</text-property>
<text-property name="heading">bvalue</text-property>
</structure>
<structure>
<property name="columnName">avalue</property>
<text-property name="displayName">avalue</text-property>
<text-property name="heading">avalue</text-property>
</structure>
<structure>
<property name="columnName">category</property>
<text-property name="displayName">category</text-property>
<text-property name="heading">category</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">Category</property>
<property name="dataType">string</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">bvalue</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">avalue</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">category</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">PFCEAP5_007a</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">bvalue</property>
<property name="nativeName">bvalue</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">avalue</property>
<property name="nativeName">avalue</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">category</property>
<property name="nativeName">category</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select dbo.PFCEAP5_007.bvalue, dbo.PFCEAP5_007.avalue, dbo.PFCEAP5_007.category
from dbo.PFCEAP5_007
where dbo.PFCEAP5_007.category = ?]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab" id="6">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<label id="9">
<property name="fontSize">14pt</property>
<property name="color">#FF0000</property>
<property name="textAlign">center</property>
<text-property name="text">Expense Category Details</text-property>
</label>
<label id="10"/>
<text id="11">
<property name="contentType">auto</property>
<text-property name="content"><![CDATA[This document shows the details of the selected expense category]]></text-property>
</text>
<table id="12">
<property name="dataSet">PFCEAP5_007a</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">bvalue</property>
<text-property name="displayName">bvalue</text-property>
<expression name="expression" type="javascript">dataSetRow["bvalue"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">avalue</property>
<text-property name="displayName">avalue</text-property>
<expression name="expression" type="javascript">dataSetRow["avalue"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">category</property>
<text-property name="displayName">category</text-property>
<expression name="expression" type="javascript">dataSetRow["category"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="31"/>
<column id="32"/>
<column id="33"/>
<header>
<row id="13">
<cell id="14">
<label id="15">
<text-property name="text">bvalue</text-property>
</label>
</cell>
<cell id="16">
<label id="17">
<text-property name="text">avalue</text-property>
</label>
</cell>
<cell id="18">
<label id="19">
<text-property name="text">category</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="20">
<cell id="21">
<data id="22">
<property name="whiteSpace">nowrap</property>
<property name="resultSetColumn">bvalue</property>
</data>
</cell>
<cell id="23">
<data id="24">
<property name="whiteSpace">nowrap</property>
<property name="resultSetColumn">avalue</property>
</data>
</cell>
<cell id="25">
<data id="26">
<property name="whiteSpace">nowrap</property>
<property name="resultSetColumn">category</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="27">
<cell id="28"/>
<cell id="29"/>
<cell id="30"/>
</row>
</footer>
</table>
</body>
</report>
 
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Go to:   
Powered by JForum 2.1.9 © JForum Team