| Column binding "xxx" has referred to a data set column "xxx" which does not exis [message #242674] |
Mon, 10 December 2007 11:52  |
Eclipse User |
|
|
|
I am having a basic error on the BIRT Reporter, but can't figure out how
to debug it or what is causing it.
Column binding "xxx" has referred to a data set column "xxx" which does
not exist.
I have been running into this error on some of my reports on the server.
I do NOT get the error on the preview pane when running my reports. It
happens on some of my reports, but not others, and I am at a loss to
determine why.
For all intents and purposes, the reports are as simple as they can be
for a report. A single data connection, a single query and a single
table, dropped directly onto the report. The field names are all simple,
with no spaces, strange characters or long names. The only thing that
seems to happen is that usually the column name identified is a field
alias from the query. But not for other queries with just as many
aliased columns and not for other columns in the same query. And BIRT
shouldn't care about the fact that it is an aliased column, that should
all happen back in the database.
Anyway, here is a copy of exactly what the logs say:
Dec 3, 2007 8:57:43 PM
org.eclipse.birt.report.engine.data.dte.DataGenerationEngine doExecuteQuery
SEVERE: Column binding "completed_time" has referred to a data set
column "completed_time" which does not exist.
Dec 3, 2007 8:57:43 PM
org.eclipse.birt.report.engine.data.dte.DataPresentationEngi ne
doExecuteQuery
SEVERE: Can't load the report query
And here is a copy of the report:
<?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
2.2.0.v20070620 Build <2.2.0.v20070626-1003></property>
<property name="units">in</property>
<text-property name="title">Unreconciled Transactions</text-property>
<property name="comments">Copyright (c) 2007 <<Your Company
Name here>></property>
<html-property name="description">Creates a blank report with no
predefined content.</html-property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="PLC_Newfound"
id="248">
<property
name="odaDriverClass">com.mysql.jdbc.Driver</property>
<property
name="odaURL"> jdbc:mysql://111.111.111.111:3306/gps?zeroDateTimeBehavior=c onvertToNull</property>
<property name="odaUser">birtreport</property>
<encrypted-property
name="odaPassword">111111111</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Unreconciled_Transactions" id="249">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">plc_id</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">transaction_id</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Defendant</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">sales_initials</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">completed_time</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">paid_datetime</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">payment_amount</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">addl_fee_amt_1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">addl_fee_amt_2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">addl_fee_amt_3</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">PLC_Newfound</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">plc_id</property>
<property name="nativeName">plc_id</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">transaction_id</property>
<property name="nativeName">transaction_id</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">-5</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Defendant</property>
<property name="nativeName">Defendant</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">name</property>
<property name="nativeName">name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">sales_initials</property>
<property name="nativeName">sales_initials</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">completed_time</property>
<property name="nativeName">completed_time</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">93</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">paid_datetime</property>
<property name="nativeName">paid_datetime</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">93</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">payment_amount</property>
<property name="nativeName">payment_amount</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">addl_fee_amt_1</property>
<property name="nativeName">addl_fee_amt_1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">addl_fee_amt_2</property>
<property name="nativeName">addl_fee_amt_2</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">addl_fee_amt_3</property>
<property name="nativeName">addl_fee_amt_3</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select t.plc_id, t.transaction_id,
CONCAT(
(SELECT COALESCE(v.value, '') FROM transaction_fields f INNER JOIN
transaction_field_values v ON v.transaction_field_id = f.id WHERE
f.transaction_id = t.transaction_id AND v.attribute = 'first' ORDER BY
f.field_id LIMIT 0,1), ' ',
(SELECT COALESCE(v.value, '') FROM transaction_fields f INNER JOIN
transaction_field_values v ON v.transaction_field_id = f.id WHERE
f.transaction_id = t.transaction_id AND v.attribute = 'middle' ORDER BY
f.field_id LIMIT 0,1), ' ',
(SELECT COALESCE(v.value, '') FROM transaction_fields f INNER JOIN
transaction_field_values v ON v.transaction_field_id = f.id WHERE
f.transaction_id = t.transaction_id AND v.attribute = 'last' ORDER BY
f.field_id LIMIT 0,1)
)AS Defendant,
p.name, p.sales_initials,
t.end_time as completed_time, t.paid_datetime,
t.plc_charge_amount_1 as payment_amount, t.plc_charge_amount_2 as
addl_fee_amt_1, t.plc_charge_amount_3 as addl_fee_amt_2,
t.plc_charge_amount_4 as addl_fee_amt_3
from transactions t
INNER JOIN plcs p ON t.plc_id = p.plc_id
where end_time is not null
and end_time < DATE_FORMAT(ADDDATE(NOW(), -2), '%Y-%m-%d')
and conf_accept_datetime is null
and conf_denied_datetime = '0000-00-00 00:00:00'
and paid_datetime is null
ORDER BY t.plc_id, t.transaction_id</property>
</oda-data-set>
</data-sets>
<styles>
<style name="crosstab-cell" id="4">
<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="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>
</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="12">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<property name="textUnderline">underline</property>
<property name="textAlign">center</property>
<text-property name="text">Unreconciled Transactions (At
least 3 days old)</text-property>
</label>
<table id="320">
<property name="width">100%</property>
<property name="dataSet">Unreconciled_Transactions</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">plc_id</property>
<expression
name="expression">dataSetRow["plc_id"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">transaction_id</property>
<expression
name="expression">dataSetRow["transaction_id"]</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">Defendant</property>
<expression
name="expression">dataSetRow["Defendant"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">name</property>
<expression
name="expression">dataSetRow["name"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">sales_initials</property>
<expression
name="expression">dataSetRow["sales_initials"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">completed_time</property>
<expression
name="expression">dataSetRow["completed_time"]</expression >
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">paid_datetime</property>
<expression
name="expression">dataSetRow["paid_datetime"]</expression >
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">payment_amount</property>
<expression
name="expression">dataSetRow["payment_amount"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">addl_fee_amt_1</property>
<expression
name="expression">dataSetRow["addl_fee_amt_1"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">addl_fee_amt_2</property>
<expression
name="expression">dataSetRow["addl_fee_amt_2"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">addl_fee_amt_3</property>
<expression
name="expression">dataSetRow["addl_fee_amt_3"]</expression >
<property name="dataType">string</property>
</structure>
</list-property>
<column id="379"/>
<column id="380"/>
<column id="381"/>
<column id="382"/>
<column id="383"/>
<column id="384"/>
<column id="385"/>
<column id="386"/>
<column id="387"/>
<column id="388"/>
<column id="389"/>
<header>
<row id="321">
<cell id="322">
<label id="323">
<text-property
name="text">plc_id</text-property>
</label>
</cell>
<cell id="324">
<label id="325">
<text-property
name="text">transaction_id</text-property>
</label>
</cell>
<cell id="326">
<label id="327">
<text-property
name="text">Defendant</text-property>
</label>
</cell>
<cell id="328">
<label id="329">
<text-property name="text">name</text-property>
</label>
</cell>
<cell id="330">
<label id="331">
<text-property
name="text">sales_initials</text-property>
</label>
</cell>
<cell id="332">
<label id="333">
<text-property
name="text">completed_time</text-property>
</label>
</cell>
<cell id="334">
<label id="335">
<text-property
name="text">paid_datetime</text-property>
</label>
</cell>
<cell id="336">
<label id="337">
<text-property
name="text">payment_amount</text-property>
</label>
</cell>
<cell id="338">
<label id="339">
<text-property
name="text">addl_fee_amt_1</text-property>
</label>
</cell>
<cell id="340">
<label id="341">
<text-property
name="text">addl_fee_amt_2</text-property>
</label>
</cell>
<cell id="342">
<label id="343">
<text-property
name="text">addl_fee_amt_3</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="344">
<cell id="345">
<data id="346">
<property
name="resultSetColumn">plc_id</property>
</data>
</cell>
<cell id="347">
<data id="348">
<property
name="resultSetColumn">transaction_id</property>
</data>
</cell>
<cell id="349">
<data id="350">
<property
name="resultSetColumn">Defendant</property>
</data>
</cell>
<cell id="351">
<data id="352">
<property
name="resultSetColumn">name</property>
</data>
</cell>
<cell id="353">
<data id="354">
<property
name="resultSetColumn">sales_initials</property>
</data>
</cell>
<cell id="355">
<data id="356">
<property
name="resultSetColumn">completed_time</property>
</data>
</cell>
<cell id="357">
<data id="358">
<property
name="resultSetColumn">paid_datetime</property>
</data>
</cell>
<cell id="359">
<data id="360">
<structure name="numberFormat">
<property
name="category">Currency</property>
<property
name="pattern">#,##0.00</property>
</structure>
<property
name="resultSetColumn">payment_amount</property>
</data>
</cell>
<cell id="361">
<data id="362">
<structure name="numberFormat">
<property
name="category">Currency</property>
<property
name="pattern">#,##0.00</property>
</structure>
<property
name="resultSetColumn">addl_fee_amt_1</property>
</data>
</cell>
<cell id="363">
<data id="364">
<structure name="numberFormat">
<property
name="category">Currency</property>
<property
name="pattern">#,##0.00</property>
</structure>
<property
name="resultSetColumn">addl_fee_amt_2</property>
</data>
</cell>
<cell id="365">
<data id="366">
<structure name="numberFormat">
<property
name="category">Currency</property>
<property
name="pattern">#,##0.00</property>
</structure>
<property
name="resultSetColumn">addl_fee_amt_3</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="367">
<cell id="368"/>
<cell id="369"/>
<cell id="370"/>
<cell id="371"/>
<cell id="372"/>
<cell id="373"/>
<cell id="374"/>
<cell id="375"/>
<cell id="376"/>
<cell id="377"/>
<cell id="378"/>
</row>
</footer>
</table>
</body>
</report>
|
|
|
|
Powered by
FUDForum. Page generated in 0.09155 seconds
Home