| Column Binding error [message #256957] |
Wed, 03 October 2007 15:33  |
Eclipse User |
|
|
|
Originally posted by: tom.oc.com
I generated a simple Birt report that does a simple query with a join to
get the count of rows in a table and the sum of values in another table
that works fine in the Birt Viewer during design time but gets the
following error when I deploy to tomcat environment with Birt 2.2.0
runtime.
SEVERE: Column binding "count(*)" has referred to a data set column
"count(*)" w
hich is not exist.
I also get the same error for sum as well . Anyone have any ideas why it
would work in the Design Tool but not work in runtime environment.
|
|
|
|
|
|
| Re: Column Binding error [message #257126 is a reply to message #257108] |
Thu, 04 October 2007 15:27  |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Tom,
On the binding tab for the element that contains
sum(captured_session.csDestinationPort)
can you try to name it something else? Leave the expression as is.
Jason
Tom Butts wrote:
> Attached are the column binding error messages from birt runtime when
> running the report that I posted earlier.
>
> Oct 4, 2007 11:23:02 AM
> org.eclipse.birt.report.engine.data.dte.DataGenerationEn
> gine doExecuteQuery
> SEVERE: Column binding "sum(captured_session.csDestinationPort)" has
> referred to
> a data set column "sum(captured_session.csDestinationPort)" which does
> not exis
> t.
> Oct 4, 2007 11:23:02 AM
> org.eclipse.birt.report.engine.data.dte.DataGenerationEn
> gine doExecuteQuery
> SEVERE: Column binding "count(*)" has referred to a data set column
> "count(*)" w
> hich does not exist.
> Oct 4, 2007 11:23:02 AM
> org.eclipse.birt.report.engine.data.dte.DataGenerationEn
> gine doExecuteQuery
> SEVERE: Column binding "prid" has referred to a data set column "prid"
> which doe
> s not exist.
> Oct 4, 2007 11:23:02 AM
> org.eclipse.birt.report.engine.data.dte.DataGenerationEn
> gine doExecuteQuery
> SEVERE: Column binding "prid" has referred to a data set column "prid"
> which doe
> s not exist.
> Oct 4, 2007 11:23:02 AM
> org.eclipse.birt.report.engine.data.dte.DataPresentation
> Engine doExecuteQuery
> SEVERE: Can't load the report query
> Oct 4, 2007 11:23:02 AM
> org.eclipse.birt.report.engine.data.dte.DataPresentation
> Engine doExecuteQuery
> SEVERE: Can't load the report query
> Oct 4, 2007 11:23:02 AM
> org.eclipse.birt.report.engine.data.dte.DataPresentation
> Engine doExecuteQuery
> SEVERE: Can't load the report query
> Oct 4, 2007 11:23:02 AM
> org.eclipse.birt.report.engine.data.dte.DataPresentation
> Engine doExecuteQuery
> SEVERE: Can't load the report query
>
>
|
|
|
|
| Re: Column Binding error [message #257215 is a reply to message #257192] |
Thu, 04 October 2007 18:16 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Tom,
This may be a compatibility issue. Can you try removing the field and
using the new aggregation element?
Jason
Tom Butts wrote:
> Here is post of the change the name of sum(.....) to fred, but I still
> get the error that says fred refers to sum(....) that does not exist and
> fails.
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.14"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 1.0.1 Build
> <20051130-1157></property>
> <property name="units">in</property>
> <property name="comments">Copyright (c) 2007 <<Your Company
> Name here>></property>
> <html-property name="description">Creates a listing report with
> fields from the data source.</html-property>
> <text-property name="displayName">Simple Listing</text-property>
> <property name="iconFile">/templates/simple_listing.gif</property>
> <property
> name="cheatSheet"> org.eclipse.birt.report.designer.ui.cheatsheet.simplelisting </property>
>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="26">
> <text-property name="displayName"></text-property>
> <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
> <property
> name="odaURL">jdbc:mysql://chimera:3306/cmpe_2007</property>
> <property name="odaUser">report</property>
> <encrypted-property name="odaPassword">T0NT</encrypted-property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set 1" id="27">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">count(*)</property>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">count(*)</property>
> <property name="nativeName">count(*)</property>
> <property name="dataType">decimal</property>
> <property name="nativeDataType">-5</property>
> </structure>
> </list-property>
> <property name="queryText">select count(*) from
> captured_session</property>
> <xml-property name="designerValues"><![CDATA[<?xml
> version="1.0" encoding="UTF-8"?>
> <model:DesignValues
> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
> <Version>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>count(*)</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
> <design:precision>21</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>count(*)</design:label>
> <design:formattingHints>
> <design:displaySize>21</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>
> ]]></xml-property>
> </oda-data-set>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set 2" id="30">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">fred</property>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">fred</property>
> <property name="nativeName">fred</property>
> <property name="dataType">decimal</property>
> <property name="nativeDataType">3</property>
> </structure>
> </list-property>
> <property name="queryText">select
> sum(captured_session.csDestinationPort)
> from captured_session</property>
> <xml-property name="designerValues"><![CDATA[<?xml
> version="1.0" encoding="UTF-8"?>
> <model:DesignValues
> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
> <Version>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
>
> <design:name>sum(captured_session.csDestinationPort)</design:name >
> <design:position>1</design:position>
> <design:nativeDataTypeCode>3</design:nativeDataTypeCode>
> <design:precision>32</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> </design:attributes>
> <design:usageHints>
>
> <design:label>sum(captured_session.csDestinationPort)</design:label >
> <design:formattingHints>
> <design:displaySize>33</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>
> ]]></xml-property>
> </oda-data-set>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set 3" id="32">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">prid</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">peUserTime</property>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> </structure>
> <property name="rowFetchLimit">15</property>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">prid</property>
> <property name="nativeName">prid</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">peUserTime</property>
> <property name="nativeName">peUserTime</property>
> <property name="dataType">decimal</property>
> <property name="nativeDataType">-5</property>
> </structure>
> </list-property>
> <property name="queryText">SELECT p.prid,p.peUserTime FROM
> process_event p left join cmpe_2007.process q on q.prID=p.prID;
> </property>
> <xml-property name="designerValues"><![CDATA[<?xml
> version="1.0" encoding="UTF-8"?>
> <model:DesignValues
> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
> <Version>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>prid</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>prid</design:label>
> <design:formattingHints>
> <design:displaySize>10</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>peUserTime</design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
> <design:precision>20</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>peUserTime</design:label>
> <design:formattingHints>
> <design:displaySize>20</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>
> ]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="crosstab" id="24">
> <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-cell" id="25">
> <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>
> <data id="31">
> <property name="dataSet">Data Set 2</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">fred</property>
> <expression
> name="expression">dataSetRow["sum(captured_session.csDestinationPort) "]</expression>
>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> <property name="resultSetColumn">fred</property>
> </data>
> <table id="4">
> <property name="width">100%</property>
> <property name="dataSet">Data Set 1</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">count(*)</property>
> <expression
> name="expression">dataSetRow["count(*)"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> <column id="20"/>
> <column id="21"/>
> <column id="22"/>
> <column id="23"/>
> <header>
> <row id="5">
> <cell id="6"/>
> <cell id="7">
> <label id="28">
> <text-property
> name="text">count(*)</text-property>
> </label>
> </cell>
> <cell id="8"/>
> <cell id="9"/>
> </row>
> </header>
> <detail>
> <row id="10">
> <cell id="11"/>
> <cell id="12">
> <data id="29">
> <property
> name="resultSetColumn">count(*)</property>
> </data>
> </cell>
> <cell id="13"/>
> <cell id="14"/>
> </row>
> </detail>
> <footer>
> <row id="15">
> <cell id="16"/>
> <cell id="17"/>
> <cell id="18"/>
> <cell id="19"/>
> </row>
> </footer>
> </table>
> <data id="33">
> <property name="dataSet">Data Set 3</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">prid</property>
> <expression
> name="expression">dataSetRow["prid"]</expression>
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> <property name="resultSetColumn">prid</property>
> </data>
> <list id="35">
> <property name="dataSet">Data Set 3</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">prid</property>
> <expression
> name="expression">dataSetRow["prid"]</expression>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">peUserTime</property>
> <expression
> name="expression">dataSetRow["peUserTime"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> <detail>
> <data id="34">
> <property name="dataSet">Data Set 3</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">peUserTime</property>
> <expression
> name="expression">dataSetRow["peUserTime"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> <property name="resultSetColumn">peUserTime</property>
> </data>
> </detail>
> </list>
> </body>
> </report>
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.04848 seconds
Home