Eclipse Community Forums: BIRT » "ANY" type error message.

Home » Archived » BIRT » "ANY" type error message.

"ANY" type error message. [message #247223]

Tue, 10 July 2007 13:07

Eclipse User

Originally posted by: mdavis.pashllc.com

For numeric types, I noticed for XML data types that returning null
(empty) in the mapping, then I get the following "ANY" type.

a. Is this a known issue?
b. Should I report the issue?
c. It seems like the XML data source should not fail on empty entries.

ReportDesign (id = 1):
- An error happen during population of data. This might be caused by
including data of mixed type in a column of "ANY" type.
-
- detail : org.eclipse.birt.data.engine.core.DataException: An error
happen during population of data. This might be caused by including
data of mixed type in a column of "ANY" type.
at
org.eclipse.birt.data.engine.impl.ComputedColumnHelperInstan ce.process(ComputedColumnHelper.java:396)
at
org.eclipse.birt.data.engine.impl.ComputedColumnHelper.proce ss(ComputedColumnHelper.java:109)
at
org.eclipse.birt.data.engine.executor.cache.RowResultSet.pro cessFetchEvent(RowResultSet.java:132)
at
org.eclipse.birt.data.engine.executor.cache.RowResultSet.nex t(RowResultSet.java:96)
at
org.eclipse.birt.data.engine.executor.cache.ExpandableRowRes ultSet.next(ExpandableRowResultSet.java:62)
at
org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .populateData(SmartCacheHelper.java:268)
at
org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .initInstance(SmartCacheHelper.java:241)
at
org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .getResultSetCache(SmartCacheHelper.java:204)
at
org.eclipse.birt.data.engine.executor.cache.SmartCache.<init >(SmartCache.java:68)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.populateOdiResultSet(PassUtil.java:145)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.pass(PassUtil.java:66)
at
org.eclipse.birt.data.engine.executor.transform.pass.ResultS etProcessUtil.populateTempComputedColumns(ResultSetProcessUt il.java:214)
at
org.eclipse.birt.data.engine.executor.transform.pass.ResultS etProcessUtil.populateResultSet(ResultSetProcessUtil.java:10 2)
at
org.eclipse.birt.data.engine.executor.transform.pass.ResultS etProcessUtil.doPopulate(ResultSetProcessUtil.java:84)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.doPopulation(PassManager.java:289)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.doMultiPass(PassManager.java:230)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.pass(PassManager.java:94)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.populateResultSet(PassManager.java:72)
at
org.eclipse.birt.data.engine.executor.transform.ResultSetPop ulator.populateResultSet(ResultSetPopulator.java:208)
at
org.eclipse.birt.data.engine.executor.transform.CachedResult Set. <init>(CachedResultSet.java:77)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.execut e(DataSourceQuery.java:510)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:338)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:761)
at
org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:216)
at
org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:152)
at
org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init >(QueryResultSet.java:83)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:155)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:115)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:178)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1678)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:82)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:61)
at
org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 5)
at
org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:42)
at
org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 5)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:33)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:126)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:84)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:90)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:148)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:71)

- Malcolm

Re: "ANY" type error message. [message #247244 is a reply to message #247223]

Tue, 10 July 2007 14:56

Eclipse User

Originally posted by: mdavis.pashllc.com

This is an issue in 2.2 and 2.2.1 nightly.

I have reported the problem in Bugzilla.

malcolm davis wrote:
> For numeric types, I noticed for XML data types that returning null
> (empty) in the mapping, then I get the following "ANY" type.
>
> a. Is this a known issue?
> b. Should I report the issue?
> c. It seems like the XML data source should not fail on empty entries.
>
>
> ReportDesign (id = 1):
> - An error happen during population of data. This might be caused by
> including data of mixed type in a column of "ANY" type.
> -
> - detail : org.eclipse.birt.data.engine.core.DataException: An error
> happen during population of data. This might be caused by including data
> of mixed type in a column of "ANY" type.
> at
> org.eclipse.birt.data.engine.impl.ComputedColumnHelperInstan ce.process(ComputedColumnHelper.java:396)
>
> at
> org.eclipse.birt.data.engine.impl.ComputedColumnHelper.proce ss(ComputedColumnHelper.java:109)
>
> at
> org.eclipse.birt.data.engine.executor.cache.RowResultSet.pro cessFetchEvent(RowResultSet.java:132)
>
> at
> org.eclipse.birt.data.engine.executor.cache.RowResultSet.nex t(RowResultSet.java:96)
>
> at
> org.eclipse.birt.data.engine.executor.cache.ExpandableRowRes ultSet.next(ExpandableRowResultSet.java:62)
>
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .populateData(SmartCacheHelper.java:268)
>
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .initInstance(SmartCacheHelper.java:241)
>
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .getResultSetCache(SmartCacheHelper.java:204)
>
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCache.<init >(SmartCache.java:68)
>
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.populateOdiResultSet(PassUtil.java:145)
>
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.pass(PassUtil.java:66)
>
> at
> org.eclipse.birt.data.engine.executor.transform.pass.ResultS etProcessUtil.populateTempComputedColumns(ResultSetProcessUt il.java:214)
>
> at
> org.eclipse.birt.data.engine.executor.transform.pass.ResultS etProcessUtil.populateResultSet(ResultSetProcessUtil.java:10 2)
>
> at
> org.eclipse.birt.data.engine.executor.transform.pass.ResultS etProcessUtil.doPopulate(ResultSetProcessUtil.java:84)
>
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.doPopulation(PassManager.java:289)
>
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.doMultiPass(PassManager.java:230)
>
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.pass(PassManager.java:94)
>
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.populateResultSet(PassManager.java:72)
>
> at
> org.eclipse.birt.data.engine.executor.transform.ResultSetPop ulator.populateResultSet(ResultSetPopulator.java:208)
>
> at
> org.eclipse.birt.data.engine.executor.transform.CachedResult Set. <init>(CachedResultSet.java:77)
>
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.execut e(DataSourceQuery.java:510)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:338)
>
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:761)
>
> at
> org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:216)
>
> at
> org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:152)
>
> at
> org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init >(QueryResultSet.java:83)
>
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:155)
>
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:115)
>
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:178)
>
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1678)
>
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:82)
>
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:61)
>
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 5)
>
> at
> org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:42)
>
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 5)
>
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:33)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:126)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:84)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:90)
>
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:148)
>
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:71)
>
>
>
>
> - Malcolm

Previous Topic:	Multiple Data Sets and Type Mapping
Next Topic:	Drawing Table grid

Goto Forum:

-=] Back to Top [=-

Current Time: Thu May 01 10:00:52 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter