Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT 2.2.1 report error
BIRT 2.2.1 report error [message #513276] Tue, 09 February 2010 15:51 Go to next message
pablo quezada roman is currently offline pablo quezada roman
Messages: 3
Registered: February 2010
Junior Member
Hi, i'm trying to make reports with birt 2.2.1 and when i make the preview i receive this error

The following items have errors:

ReportDesign (id = 1):
- A BIRT exception occurred: org.eclipse.birt.core. See next exception for more information.
org.eclipse.birt.core
data.engine.BirtException ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: org.eclipse.birt.core. See next exception for more information.
org.eclipse.birt.core
at org.eclipse.birt.data.engine.core.DataException.wrap(DataExc eption.java:118)
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUt il.populateColumnList(ExpressionCompilerUtil.java:537)
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUt il.extractDataSetColumnExpression(ExpressionCompilerUtil.jav a:284)
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUt il.extractDataSetColumnExpression(ExpressionCompilerUtil.jav a:201)
at org.eclipse.birt.data.engine.impl.ResultIterator.validateMan ualBindingExpressions(ResultIterator.java:267)
at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:145)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:180)
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:157)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:117)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:182)
at org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1683)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:76)
at org.eclipse.birt.report.engine.executor.DataItemExecutor.exe cute(DataItemExecutor.java:74)
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.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:63)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:85)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:106)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:140)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:68)
at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportCom ponent.generateReport(BIRTReportComponent.java:489)
at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportCom ponent.executeAction(BIRTReportComponent.java:303)
at org.pentaho.platform.engine.services.solution.ComponentBase. execute(ComponentBase.java:463)
at org.pentaho.platform.engine.services.runtime.RuntimeContext. executeComponent(RuntimeContext.java:1331)
at org.pentaho.platform.engine.services.runtime.RuntimeContext. executeAction(RuntimeContext.java:1298)
at org.pentaho.platform.engine.services.runtime.RuntimeContext. performActions(RuntimeContext.java:1216)
at org.pentaho.platform.engine.services.runtime.RuntimeContext. executeLoop(RuntimeContext.java:1165)
at org.pentaho.platform.engine.services.runtime.RuntimeContext. executeSequence(RuntimeContext.java:1045)
at org.pentaho.platform.engine.services.runtime.RuntimeContext. executeSequence(RuntimeContext.java:938)
at org.pentaho.platform.engine.services.solution.SolutionEngine .executeInternal(SolutionEngine.java:413)
at org.pentaho.platform.engine.services.solution.SolutionEngine .execute(SolutionEngine.java:316)
at org.pentaho.platform.engine.services.solution.SolutionEngine .execute(SolutionEngine.java:192)
at org.pentaho.platform.engine.services.BaseRequestHandler.hand leActionRequest(BaseRequestHandler.java:159)
at org.pentaho.platform.web.servlet.ViewAction.handleActionRequ est(ViewAction.java:148)
at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction .java:275)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:188)
at org.springframework.security.util.FilterChainProxy$VirtualFi lterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.intercept.web.FilterSecurityInt erceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.intercept.web.FilterSecurityInt erceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy$VirtualFi lterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.ExceptionTranslationFilter.d oFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilte r(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFi lterChain.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.SecurityStartupFilter .doFilter(SecurityStartupFilter.java:85)
at org.springframework.security.util.FilterChainProxy$VirtualFi lterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.providers.anonymous.AnonymousPr ocessingFilter.doFilterHttp(AnonymousProcessingFilter.java:1 05)
at org.springframework.security.ui.SpringSecurityFilter.doFilte r(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFi lterChain.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.RequestParameterAuthe nticationFilter.doFilter(RequestParameterAuthenticationFilte r.java:169)
at org.springframework.security.util.FilterChainProxy$VirtualFi lterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.basicauth.BasicProcessingFil ter.doFilterHttp(BasicProcessingFilter.java:174)
at org.springframework.security.ui.SpringSecurityFilter.doFilte r(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFi lterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.AbstractProcessingFilter.doF ilterHttp(AbstractProcessingFilter.java:278)
at org.springframework.security.ui.SpringSecurityFilter.doFilte r(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFi lterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.logout.LogoutFilter.doFilter Http(LogoutFilter.java:89)
at org.springframework.security.ui.SpringSecurityFilter.doFilte r(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFi lterChain.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.HttpSessionReuseDetec tionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134 )
at org.springframework.security.util.FilterChainProxy$VirtualFi lterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.context.HttpSessionContextInteg rationFilter.doFilterHttp(HttpSessionContextIntegrationFilte r.java:235)
at org.springframework.security.ui.SpringSecurityFilter.doFilte r(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFi lterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.wrapper.SecurityContextHolderAw areRequestFilter.doFilterHttp(SecurityContextHolderAwareRequ estFilter.java:91)
at org.springframework.security.ui.SpringSecurityFilter.doFilte r(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFi lterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.util.FilterChainProxy.doFilter( FilterChainProxy.java:175)
at org.springframework.security.util.FilterToBeanProxy.doFilter (FilterToBeanProxy.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:188)
at org.pentaho.platform.web.http.filters.SystemStatusFilter.doF ilter(SystemStatusFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:188)
at org.pentaho.platform.web.http.filters.SetCharacterEncodingFi lter.doFilter(SetCharacterEncodingFilter.java:113)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(A uthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
Caused by: org.eclipse.birt.core.exception.CoreException: org.eclipse.birt.core
at org.eclipse.birt.core.data.ExpressionParserUtility.compileCo lumnExpression(ExpressionParserUtility.java:90)
at org.eclipse.birt.core.data.ExpressionUtil.extractColumnExpre ssions(ExpressionUtil.java:231)
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUt il.populateColumnList(ExpressionCompilerUtil.java:532)
... 93 more
Caused by: org.eclipse.birt.core.exception.CoreException: org.eclipse.birt.core
at org.eclipse.birt.core.data.ExpressionParserUtility.CompiledE xprFromTree(ExpressionParserUtility.java:164)
at org.eclipse.birt.core.data.ExpressionParserUtility.compileCo lumnExpression(ExpressionParserUtility.java:83)
... 95 more



also in tomcat appears a lot of times:

09-02-2010 12:36:02 PM org.eclipse.birt.report.engine.api.impl.ReportEngine openReportDesign
FINA: ReportEngine.openReportDesign: designStream=java.io.ByteArrayInputStream@86db7
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice in
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice integer
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice string
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice integer
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ElementRefPropertyTyp e validateValue
FINA: Validate the value of the element reference property as a string: macropanel
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice integer
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice string
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice integer
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
FINA: The validated color property value 13421772
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice solid
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
FINA: return dimension value with user defined unit 1pt
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
FINA: The validated color property value 13421772
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice solid
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
FINA: return dimension value with user defined unit 1pt
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
FINA: The validated color property value 13421772
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice solid
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
FINA: return dimension value with user defined unit 1pt
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
FINA: The validated color property value 13421772
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice solid
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
FINA: return dimension value with user defined unit 1pt
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
FINA: The validated color property value 13421772
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice solid
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
FINA: return dimension value with user defined unit 1pt
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
FINA: The validated color property value 13421772
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice solid
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
FINA: return dimension value with user defined unit 1pt
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
FINA: The validated color property value 13421772
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice solid
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
FINA: return dimension value with user defined unit 1pt
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
FINA: The validated color property value 13421772
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice solid
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
FINA: return dimension value with user defined unit 1pt
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice html
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice auto
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ElementRefPropertyTyp e validateValue
FINA: Validate the value of the element reference property as a string: query_comun
09-02-2010 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
FINA: return internal name for choice string
09-02-2010 12:36:02 PM org.eclipse.birt.report.engine.api.impl.ReportEngine createGetParameterDefinitionTask
FINA: ReportEngine.createGetParameterDefinitionTask: reportRunnable=org.eclipse.birt.report.engine.api.impl.ReportRunnable@86e1f
09-02-2010 12:36:02 PM org.eclipse.birt.report.engine.api.impl.EngineTask setAppContext
FINA: EngineTask.setAppContext: context=
09-02-2010 12:36:02 PM org.eclipse.birt.report.engine.api.impl.ReportEngine createRunAndRenderTask
FINA: ReportEngine.createRunAndRenderTask: reportRunnable=org.eclipse.birt.report.engine.api.impl.ReportRunnable@86e1f
09-02-2010 12:36:02 PM org.eclipse.birt.report.engine.api.impl.EngineTask setAppContext
FINA: EngineTask.setAppContext: context=
09-02-2010 12:36:02 PM org.eclipse.birt.report.engine.api.impl.EngineTask setLocale
FINA: EngineTask.setLocale: locale=español (España)
09-02-2010 12:36:02 PM org.eclipse.birt.report.engine.api.impl.EngineTask setAppContext
FINA: EngineTask.setAppContext: context=HTML_RENDER_CONTEXT=org.eclipse.birt.report.engine.api.HTMLRenderContext@6fef4d;
09-02-2010 12:36:02 PM org.eclipse.birt.report.engine.api.impl.EngineTask loggerParamters
FINA: Running the report with paramters:
09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.DataEngineImpl <init>
INFO: Data Engine starts up
09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSource
FINA: DataEngine.defineDataSource: OdaDataSourceDesign(Name : macropanel
ExtensionID : org.eclipse.birt.report.data.oda.jdbc
PrivateProperties : {}
PulicProperties : odaPassword=***;OdaPropertyConfigId=org.eclipse.birt.report. data.oda.jdbc_macropanel;odaDriverClass=org.postgresql.Drive r;odaURL=jdbc:postgresql://localhost:5432/macropanel;odaUser=postgres;
)
09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSet
FINA: DataEngine.defineDataSet: OdaDataSetDesign(Name : query_comun
DataSourceName : macropanel
ResultSetHints : org.eclipse.birt.data.engine.api.querydefn.ColumnDefinition@189f114,
org.eclipse.birt.data.engine.api.querydefn.ColumnDefinition@1327bb6,
org.eclipse.birt.data.engine.api.querydefn.ColumnDefinition@1581c9b
ExtensionID : org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet
QueryText : select *
from dim_comuna
PrivateProperties : {}
PublicProperties : {queryTimeOut=null}
)
09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.DataEngineImpl prepare
FINA: Start to prepare query: QueryDefinition(DataSetName : query_comun
ResultSetExpressions : {glosa_comuna=org.eclipse.birt.data.engine.api.querydefn.Binding@14202bb}
MaxRows : 0

09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.PreparedQuery PreparedQuery
FINA: PreparedQuery starts up.
09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.PreparedQuery <init>
FINA: Start to prepare a PreparedQuery.
09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.PreparedQuery <init>
FINA: Finished preparing the PreparedQuery.
09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.DataEngineImpl prepare
FINA: Finished preparing query.
09-02-2010 12:36:02 PM org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitte r start
FINA: [HTMLReportEmitter] Start emitter.
09-02-2010 12:36:02 PM org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitte r startText
FINA: [HTMLReportEmitter] Start text
09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.odaconsumer.ConnectionManager addProfileProviderService( Map )
INFO: Added default property service: org.eclipse.datatools.connectivity.oda.profile.connectionPro pertyService
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.OdaJdbcDriver getConnection
FINA: JDBCConnectionFactory.getConnection( ) connectionClassName=org.eclipse.birt.report.data.oda.jdbc
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Connection open
FINA: Connection.open(Properties). connProperties = OdaPropertyConfigId=org.eclipse.birt.report.data.oda.jdbc_ma cropanel;odaDriverClass=org.postgresql.Driver;odaURL=jdbc:postgresql://localhost:5432/macropanel;odaPassword=***;odaUser=postgres;
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Connection close
FINA: Connection closed.
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager getConnection
FINA: Request JDBC Connection: driverClass=org.postgresql.Driver; url=jdbc:postgresql://localhost:5432/macropanel; jndi name url=null
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Connection createStatement
FINA: Connection.createStatement(org.eclipse.birt.report.data.oda. jdbc.JdbcSelectDataSet)
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Statement prepare
FINA: Statement.prepare( "select *
from dim_comuna" )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Statement getMetaData
FINA: Statement.getMetaData( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnCount
FINA: ResultSetMetaData.getColumnCount( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnName
FINA: ResultSetMetaData.getColumnName( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnLabel
FINA: ResultSetMetaData.getColumnLabel( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnType
FINA: ResultSetMetaData.getColumnType( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnTypeName
FINA: ResultSetMetaData.getColumnTypeName( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnName
FINA: ResultSetMetaData.getColumnName( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnLabel
FINA: ResultSetMetaData.getColumnLabel( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnType
FINA: ResultSetMetaData.getColumnType( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnTypeName
FINA: ResultSetMetaData.getColumnTypeName( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnName
FINA: ResultSetMetaData.getColumnName( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnLabel
FINA: ResultSetMetaData.getColumnLabel( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnType
FINA: ResultSetMetaData.getColumnType( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnTypeName
FINA: ResultSetMetaData.getColumnTypeName( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Statement setMaxRows
FINA: Statement.setMaxRows( 0 )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Statement executeQuery
FINA: Statement.executeQuery( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
FINA: ResultSet.next( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
FINA: ResultSet.next( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
FINA: ResultSet.next( )
09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )

.....

09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
FINA: ResultSet.next( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
FINA: ResultSet.next( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
FINA: ResultSet.next( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet getMetaData
FINA: ResultSet.wasNull( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
FINA: ResultSet.next( )
09-02-2010 12:36:04 PM org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper populateData
FINA: MemoryCache is used
09-02-2010 12:36:04 PM org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper populateData
FINA: Time consumed by cache is: 1 second
09-02-2010 12:36:04 PM org.eclipse.birt.report.engine.data.dte.DteDataEngine doExecuteQuery
GRAVE: A BIRT exception occurred: org.eclipse.birt.core. See next exception for more information.
org.eclipse.birt.core
09-02-2010 12:36:04 PM org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitte r startText
FINA: [HTMLReportEmitter] Start text
09-02-2010 12:36:04 PM org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitte r endPage
FINA: [HTMLReportEmitter] End page.
09-02-2010 12:36:04 PM org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitte r startForeign
FINA: [HTMLReportEmitter] Start foreign
09-02-2010 12:36:04 PM org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitte r end
FINA: [HTMLReportEmitter] End body.
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.Statement close
FINA: Statement.close( )
09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.Connection close
FINA: Connection closed.
09-02-2010 12:36:04 PM org.eclipse.birt.data.engine.impl.DataEngineImpl shutdown
INFO: Data engine shuts down




the report is very simple.... a select * from a_table.

i hope you can help me... i havent found anithing yet...

thanks...
Re: BIRT 2.2.1 report error [message #513330 is a reply to message #513276] Tue, 09 February 2010 19:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you post the report?

Jason

pablo quezada roman wrote:
> Hi, i'm trying to make reports with birt 2.2.1 and when i make the
> preview i receive this error
>
> The following items have errors:
>
> ReportDesign (id = 1):
> - A BIRT exception occurred: org.eclipse.birt.core. See next exception
> for more information.
> org.eclipse.birt.core
> data.engine.BirtException ( 1 time(s) )
> detail : org.eclipse.birt.data.engine.core.DataException: A BIRT
> exception occurred: org.eclipse.birt.core. See next exception for more
> information.
> org.eclipse.birt.core
> at org.eclipse.birt.data.engine.core.DataException.wrap(DataExc
> eption.java:118)
> at org.eclipse.birt.data.engine.expression.ExpressionCompilerUt
> il.populateColumnList(ExpressionCompilerUtil.java:537)
> at org.eclipse.birt.data.engine.expression.ExpressionCompilerUt
> il.extractDataSetColumnExpression(ExpressionCompilerUtil.jav a:284)
> at org.eclipse.birt.data.engine.expression.ExpressionCompilerUt
> il.extractDataSetColumnExpression(ExpressionCompilerUtil.jav a:201)
> at org.eclipse.birt.data.engine.impl.ResultIterator.validateMan
> ualBindingExpressions(ResultIterator.java:267)
> at
> org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:145)
>
> at org.eclipse.birt.data.engine.impl.QueryResults.getResultIter
> ator(QueryResults.java:180)
> 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:157)
> at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec
> uteQuery(DteDataEngine.java:117)
> at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e
> xecute(AbstractDataEngine.java:182)
> at org.eclipse.birt.report.engine.executor.ExecutionContext.exe
> cuteQuery(ExecutionContext.java:1683)
> at org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex
> ecuteQuery(QueryItemExecutor.java:76)
> at org.eclipse.birt.report.engine.executor.DataItemExecutor.exe
> cute(DataItemExecutor.java:74)
> 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.HTMLBlockStacking
> LM.layoutNodes(HTMLBlockStackingLM.java:63)
> at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout
> (HTMLPageLM.java:85)
> at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE
> ngine.layout(HTMLReportLayoutEngine.java:106)
> at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR
> un(RunAndRenderTask.java:140)
> at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run
> (RunAndRenderTask.java:68)
> at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportCom
> ponent.generateReport(BIRTReportComponent.java:489)
> at org.pentaho.platform.plugin.action.eclipsebirt.BIRTReportCom
> ponent.executeAction(BIRTReportComponent.java:303)
> at org.pentaho.platform.engine.services.solution.ComponentBase.
> execute(ComponentBase.java:463)
> at org.pentaho.platform.engine.services.runtime.RuntimeContext.
> executeComponent(RuntimeContext.java:1331)
> at org.pentaho.platform.engine.services.runtime.RuntimeContext.
> executeAction(RuntimeContext.java:1298)
> at org.pentaho.platform.engine.services.runtime.RuntimeContext.
> performActions(RuntimeContext.java:1216)
> at org.pentaho.platform.engine.services.runtime.RuntimeContext.
> executeLoop(RuntimeContext.java:1165)
> at org.pentaho.platform.engine.services.runtime.RuntimeContext.
> executeSequence(RuntimeContext.java:1045)
> at org.pentaho.platform.engine.services.runtime.RuntimeContext.
> executeSequence(RuntimeContext.java:938)
> at org.pentaho.platform.engine.services.solution.SolutionEngine
> .executeInternal(SolutionEngine.java:413)
> at org.pentaho.platform.engine.services.solution.SolutionEngine
> .execute(SolutionEngine.java:316)
> at org.pentaho.platform.engine.services.solution.SolutionEngine
> .execute(SolutionEngine.java:192)
> at org.pentaho.platform.engine.services.BaseRequestHandler.hand
> leActionRequest(BaseRequestHandler.java:159)
> at org.pentaho.platform.web.servlet.ViewAction.handleActionRequ
> est(ViewAction.java:148)
> at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction .java:275)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
> lter(ApplicationFilterChain.java:269)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
> licationFilterChain.java:188)
> at org.springframework.security.util.FilterChainProxy$VirtualFi
> lterChain.doFilter(FilterChainProxy.java:378)
> at org.springframework.security.intercept.web.FilterSecurityInt
> erceptor.invoke(FilterSecurityInterceptor.java:109)
> at org.springframework.security.intercept.web.FilterSecurityInt
> erceptor.doFilter(FilterSecurityInterceptor.java:83)
> at org.springframework.security.util.FilterChainProxy$VirtualFi
> lterChain.doFilter(FilterChainProxy.java:390)
> at org.springframework.security.ui.ExceptionTranslationFilter.d
> oFilterHttp(ExceptionTranslationFilter.java:101)
> at org.springframework.security.ui.SpringSecurityFilter.doFilte
> r(SpringSecurityFilter.java:53)
> at org.springframework.security.util.FilterChainProxy$VirtualFi
> lterChain.doFilter(FilterChainProxy.java:390)
> at org.pentaho.platform.web.http.security.SecurityStartupFilter
> .doFilter(SecurityStartupFilter.java:85)
> at org.springframework.security.util.FilterChainProxy$VirtualFi
> lterChain.doFilter(FilterChainProxy.java:390)
> at org.springframework.security.providers.anonymous.AnonymousPr
> ocessingFilter.doFilterHttp(AnonymousProcessingFilter.java:1 05)
> at org.springframework.security.ui.SpringSecurityFilter.doFilte
> r(SpringSecurityFilter.java:53)
> at org.springframework.security.util.FilterChainProxy$VirtualFi
> lterChain.doFilter(FilterChainProxy.java:390)
> at org.pentaho.platform.web.http.security.RequestParameterAuthe
> nticationFilter.doFilter(RequestParameterAuthenticationFilte r.java:169)
> at org.springframework.security.util.FilterChainProxy$VirtualFi
> lterChain.doFilter(FilterChainProxy.java:390)
> at org.springframework.security.ui.basicauth.BasicProcessingFil
> ter.doFilterHttp(BasicProcessingFilter.java:174)
> at org.springframework.security.ui.SpringSecurityFilter.doFilte
> r(SpringSecurityFilter.java:53)
> at org.springframework.security.util.FilterChainProxy$VirtualFi
> lterChain.doFilter(FilterChainProxy.java:390)
> at org.springframework.security.ui.AbstractProcessingFilter.doF
> ilterHttp(AbstractProcessingFilter.java:278)
> at org.springframework.security.ui.SpringSecurityFilter.doFilte
> r(SpringSecurityFilter.java:53)
> at org.springframework.security.util.FilterChainProxy$VirtualFi
> lterChain.doFilter(FilterChainProxy.java:390)
> at org.springframework.security.ui.logout.LogoutFilter.doFilter
> Http(LogoutFilter.java:89)
> at org.springframework.security.ui.SpringSecurityFilter.doFilte
> r(SpringSecurityFilter.java:53)
> at org.springframework.security.util.FilterChainProxy$VirtualFi
> lterChain.doFilter(FilterChainProxy.java:390)
> at org.pentaho.platform.web.http.security.HttpSessionReuseDetec
> tionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134 )
> at org.springframework.security.util.FilterChainProxy$VirtualFi
> lterChain.doFilter(FilterChainProxy.java:390)
> at org.springframework.security.context.HttpSessionContextInteg
> rationFilter.doFilterHttp(HttpSessionContextIntegrationFilte r.java:235)
> at org.springframework.security.ui.SpringSecurityFilter.doFilte
> r(SpringSecurityFilter.java:53)
> at org.springframework.security.util.FilterChainProxy$VirtualFi
> lterChain.doFilter(FilterChainProxy.java:390)
> at org.springframework.security.wrapper.SecurityContextHolderAw
> areRequestFilter.doFilterHttp(SecurityContextHolderAwareRequ
> estFilter.java:91)
> at org.springframework.security.ui.SpringSecurityFilter.doFilte
> r(SpringSecurityFilter.java:53)
> at org.springframework.security.util.FilterChainProxy$VirtualFi
> lterChain.doFilter(FilterChainProxy.java:390)
> at org.springframework.security.util.FilterChainProxy.doFilter(
> FilterChainProxy.java:175)
> at org.springframework.security.util.FilterToBeanProxy.doFilter
> (FilterToBeanProxy.java:99)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
> lter(ApplicationFilterChain.java:215)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
> licationFilterChain.java:188)
> at org.pentaho.platform.web.http.filters.SystemStatusFilter.doF
> ilter(SystemStatusFilter.java:60)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
> lter(ApplicationFilterChain.java:215)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
> licationFilterChain.java:188)
> at org.pentaho.platform.web.http.filters.SetCharacterEncodingFi
> lter.doFilter(SetCharacterEncodingFilter.java:113)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
> lter(ApplicationFilterChain.java:215)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
> licationFilterChain.java:188)
> at org.apache.catalina.core.StandardWrapperValve.invoke(Standar
> dWrapperValve.java:213)
> at org.apache.catalina.core.StandardContextValve.invoke(Standar
> dContextValve.java:174)
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(A
> uthenticatorBase.java:433)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHo
> stValve.java:127)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo
> rtValve.java:117)
> at org.apache.catalina.core.StandardEngineValve.invoke(Standard
> EngineValve.java:108)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd
> apter.java:174)
> at org.apache.coyote.http11.Http11Processor.process(Http11Proce
> ssor.java:874)
> at org.apache.coyote.http11.Http11BaseProtocol$Http11Connection
> Handler.processConnection(Http11BaseProtocol.java:665)
> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo
> lTcpEndpoint.java:528)
> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:81)
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru
> n(ThreadPool.java:689)
> at java.lang.Thread.run(Unknown Source)
> Caused by: org.eclipse.birt.core.exception.CoreException:
> org.eclipse.birt.core
> at org.eclipse.birt.core.data.ExpressionParserUtility.compileCo
> lumnExpression(ExpressionParserUtility.java:90)
> at org.eclipse.birt.core.data.ExpressionUtil.extractColumnExpre
> ssions(ExpressionUtil.java:231)
> at org.eclipse.birt.data.engine.expression.ExpressionCompilerUt
> il.populateColumnList(ExpressionCompilerUtil.java:532)
> ... 93 more
> Caused by: org.eclipse.birt.core.exception.CoreException:
> org.eclipse.birt.core
> at org.eclipse.birt.core.data.ExpressionParserUtility.CompiledE
> xprFromTree(ExpressionParserUtility.java:164)
> at org.eclipse.birt.core.data.ExpressionParserUtility.compileCo
> lumnExpression(ExpressionParserUtility.java:83)
> ... 95 more
>
>
>
> also in tomcat appears a lot of times:
>
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.engine.api.impl.ReportEngine openReportDesign
> FINA: ReportEngine.openReportDesign:
> designStream=mailto:java.io.ByteArrayInputStream@86db7 09-02-2010
> 12:36:02 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType
> validateXml
> FINA: return internal name for choice in
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice integer
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice string
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice integer
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ElementRefPropertyTyp e
> validateValue
> FINA: Validate the value of the element reference property as a string:
> macropanel
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice integer
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice string
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice integer
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
> FINA: The validated color property value 13421772
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice solid
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
> FINA: return dimension value with user defined unit 1pt
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
> FINA: The validated color property value 13421772
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice solid
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
> FINA: return dimension value with user defined unit 1pt
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
> FINA: The validated color property value 13421772
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice solid
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
> FINA: return dimension value with user defined unit 1pt
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
> FINA: The validated color property value 13421772
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice solid
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
> FINA: return dimension value with user defined unit 1pt
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
> FINA: The validated color property value 13421772
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice solid
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
> FINA: return dimension value with user defined unit 1pt
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
> FINA: The validated color property value 13421772
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice solid
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
> FINA: return dimension value with user defined unit 1pt
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
> FINA: The validated color property value 13421772
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice solid
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
> FINA: return dimension value with user defined unit 1pt
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ColorPropertyType validateXml
> FINA: The validated color property value 13421772
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice solid
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.DimensionPropertyType validateXml
> FINA: return dimension value with user defined unit 1pt
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice html
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice auto
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ElementRefPropertyTyp e
> validateValue
> FINA: Validate the value of the element reference property as a string:
> query_comun
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
> FINA: return internal name for choice string
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.engine.api.impl.ReportEngine
> createGetParameterDefinitionTask
> FINA: ReportEngine.createGetParameterDefinitionTask:
> reportRunnable=mailto:org.eclipse.birt.report.engine.api.impl.ReportRunnable@86e1f
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.engine.api.impl.EngineTask setAppContext
> FINA: EngineTask.setAppContext: context=
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.engine.api.impl.ReportEngine createRunAndRenderTask
> FINA: ReportEngine.createRunAndRenderTask:
> reportRunnable=mailto:org.eclipse.birt.report.engine.api.impl.ReportRunnable@86e1f
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.engine.api.impl.EngineTask setAppContext
> FINA: EngineTask.setAppContext: context=
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.engine.api.impl.EngineTask setLocale
> FINA: EngineTask.setLocale: locale=español (España)
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.engine.api.impl.EngineTask setAppContext
> FINA: EngineTask.setAppContext:
> context=HTML_RENDER_CONTEXT=mailto:org.eclipse.birt.report.engine.api.HTMLRenderContext@6fef4d;
>
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.engine.api.impl.EngineTask loggerParamters
> FINA: Running the report with paramters: 09-02-2010 12:36:02 PM
> org.eclipse.birt.data.engine.impl.DataEngineImpl <init>
> INFO: Data Engine starts up
> 09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.DataEngineImpl
> defineDataSource
> FINA: DataEngine.defineDataSource: OdaDataSourceDesign(Name : macropanel
> ExtensionID : org.eclipse.birt.report.data.oda.jdbc
> PrivateProperties : {}
> PulicProperties :
> odaPassword=***;OdaPropertyConfigId=org.eclipse.birt.report.
> data.oda.jdbc_macropanel;odaDriverClass=org.postgresql.Drive
> r;odaURL=jdbc:postgresql://localhost:5432/macropanel;odaUser=postgres;
> )
> 09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.DataEngineImpl
> defineDataSet
> FINA: DataEngine.defineDataSet: OdaDataSetDesign(Name : query_comun
> DataSourceName : macropanel
> ResultSetHints :
> mailto:org.eclipse.birt.data.engine.api.querydefn.ColumnDefinition@189f114,
> mailto:org.eclipse.birt.data.engine.api.querydefn.ColumnDefinition@1327bb6,
> mailto:org.eclipse.birt.data.engine.api.querydefn.ColumnDefinition@1581c9b
>
> ExtensionID : org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet
> QueryText : select * from dim_comuna
> PrivateProperties : {}
> PublicProperties : {queryTimeOut=null}
> )
> 09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.DataEngineImpl
> prepare
> FINA: Start to prepare query: QueryDefinition(DataSetName : query_comun
> ResultSetExpressions :
> {glosa_comuna=mailto:org.eclipse.birt.data.engine.api.querydefn.Binding@14202bb}
>
> MaxRows : 0
>
> 09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.PreparedQuery
> PreparedQuery
> FINA: PreparedQuery starts up.
> 09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.PreparedQuery
> <init>
> FINA: Start to prepare a PreparedQuery.
> 09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.PreparedQuery
> <init>
> FINA: Finished preparing the PreparedQuery.
> 09-02-2010 12:36:02 PM org.eclipse.birt.data.engine.impl.DataEngineImpl
> prepare
> FINA: Finished preparing query.
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitte r start
> FINA: [HTMLReportEmitter] Start emitter.
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitte r startText
> FINA: [HTMLReportEmitter] Start text
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager
> addProfileProviderService( Map )
> INFO: Added default property service:
> org.eclipse.datatools.connectivity.oda.profile.connectionPro pertyService
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.OdaJdbcDriver getConnection
> FINA: JDBCConnectionFactory.getConnection( )
> connectionClassName=org.eclipse.birt.report.data.oda.jdbc
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Connection
> open
> FINA: Connection.open(Properties). connProperties =
> OdaPropertyConfigId=org.eclipse.birt.report.data.oda.jdbc_ma
> cropanel;odaDriverClass=org.postgresql.Driver;odaURL=jdbc:postgresql://localhost:5432/macropanel;odaPassword=***;odaUser=postgres;
>
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Connection
> close
> FINA: Connection closed.
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager getConnection
> FINA: Request JDBC Connection: driverClass=org.postgresql.Driver;
> url=jdbc:postgresql://localhost:5432/macropanel; jndi name url=null
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Connection
> createStatement
> FINA: Connection.createStatement(org.eclipse.birt.report.data.oda.
> jdbc.JdbcSelectDataSet)
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Statement
> prepare
> FINA: Statement.prepare( "select * from dim_comuna" )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Statement
> getMetaData
> FINA: Statement.getMetaData( )
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnCount
> FINA: ResultSetMetaData.getColumnCount( )
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnName
> FINA: ResultSetMetaData.getColumnName( )
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnLabel
> FINA: ResultSetMetaData.getColumnLabel( )
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnType
> FINA: ResultSetMetaData.getColumnType( )
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnTypeName
> FINA: ResultSetMetaData.getColumnTypeName( )
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnName
> FINA: ResultSetMetaData.getColumnName( )
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnLabel
> FINA: ResultSetMetaData.getColumnLabel( )
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnType
> FINA: ResultSetMetaData.getColumnType( )
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnTypeName
> FINA: ResultSetMetaData.getColumnTypeName( )
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnName
> FINA: ResultSetMetaData.getColumnName( )
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnLabel
> FINA: ResultSetMetaData.getColumnLabel( )
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnType
> FINA: ResultSetMetaData.getColumnType( )
> 09-02-2010 12:36:02 PM
> org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData getColumnTypeName
> FINA: ResultSetMetaData.getColumnTypeName( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Statement
> setMaxRows
> FINA: Statement.setMaxRows( 0 )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.Statement
> executeQuery
> FINA: Statement.executeQuery( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
> FINA: ResultSet.next( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
> FINA: ResultSet.next( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
> FINA: ResultSet.next( )
> 09-02-2010 12:36:02 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
>
> ....
>
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
> FINA: ResultSet.next( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
> FINA: ResultSet.next( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
> FINA: ResultSet.next( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet
> getMetaData
> FINA: ResultSet.wasNull( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.ResultSet next
> FINA: ResultSet.next( )
> 09-02-2010 12:36:04 PM
> org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper populateData
> FINA: MemoryCache is used
> 09-02-2010 12:36:04 PM
> org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper populateData
> FINA: Time consumed by cache is: 1 second
> 09-02-2010 12:36:04 PM
> org.eclipse.birt.report.engine.data.dte.DteDataEngine doExecuteQuery
> GRAVE: A BIRT exception occurred: org.eclipse.birt.core. See next
> exception for more information.
> org.eclipse.birt.core
> 09-02-2010 12:36:04 PM
> org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitte r startText
> FINA: [HTMLReportEmitter] Start text
> 09-02-2010 12:36:04 PM
> org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitte r endPage
> FINA: [HTMLReportEmitter] End page.
> 09-02-2010 12:36:04 PM
> org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitte r startForeign
> FINA: [HTMLReportEmitter] Start foreign
> 09-02-2010 12:36:04 PM
> org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitte r end
> FINA: [HTMLReportEmitter] End body.
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.Statement
> close
> FINA: Statement.close( )
> 09-02-2010 12:36:04 PM org.eclipse.birt.report.data.oda.jdbc.Connection
> close
> FINA: Connection closed.
> 09-02-2010 12:36:04 PM org.eclipse.birt.data.engine.impl.DataEngineImpl
> shutdown
> INFO: Data engine shuts down
>
>
>
>
> the report is very simple.... a select * from a_table.
>
> i hope you can help me... i havent found anithing yet...
>
> thanks...
Re: BIRT 2.2.1 report error [message #513352 is a reply to message #513276] Tue, 09 February 2010 20:14 Go to previous messageGo to next message
pablo quezada roman is currently offline pablo quezada roman
Messages: 3
Registered: February 2010
Junior Member
thanks for helping me.... here is my report

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 &lt;&lt;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="macropanel" id="7">
<property name="odaDriverClass">org.postgresql.Driver</property>
<property name="odaURL">jdbc:postgresql://localhost:5432/macropanel</property>
<property name="odaUser">postgres</property>
<encrypted-property name="odaPassword" encryptionID="base64">cHF6YWRh</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="query_comun" id="8">
<list-property name="columnHints">
<structure>
<property name="columnName">id_comuna</property>
<property name="displayName">id_comuna</property>
</structure>
<structure>
<property name="columnName">glosa_comuna</property>
<property name="displayName">glosa_comuna</property>
</structure>
<structure>
<property name="columnName">id_ciudad</property>
<property name="displayName">id_ciudad</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">id_comuna</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">glosa_comuna</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">id_ciudad</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">macropanel</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">id_comuna</property>
<property name="nativeName">id_comuna</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">glosa_comuna</property>
<property name="nativeName">glosa_comuna</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">id_ciudad</property>
<property name="nativeName">id_ciudad</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
</list-property>
<property name="queryText">select *
from dim_comuna</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>
<text id="6">
<property name="contentType">auto</property>
<text-property name="content"><![CDATA[Este reporte debe mostrar al menos una ciudad que se encuentra en
<H1>
dim_ciudad
</H1>
]]></text-property>
</text>
<data id="9">
<property name="dataSet">query_comun</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">glosa_comuna</property>
<expression name="expression">dataSetRow["glosa_comuna"]</expression >
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">glosa_comuna</property>
</data>
</body>
</report>

[Updated on: Tue, 09 February 2010 20:17]

Report message to a moderator

Re: BIRT 2.2.1 report error [message #513626 is a reply to message #513352] Wed, 10 February 2010 17:36 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you set the text item type from auto to HTML?

Jason

pablo quezada roman wrote:
> first... thanks for helping. this is my report
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.2.1.r221_v20070924 Build <2.2.0.v20070924-1550></property>
> <property name="units">in</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="macropanel"
> id="7">
> <property name="odaDriverClass">org.postgresql.Driver</property>
> <property
> name="odaURL">jdbc:postgresql://localhost:5432/macropanel</property>
> <property name="odaUser">postgres</property>
> <encrypted-property name="odaPassword"
> encryptionID="base64">cHF6YWRh</encrypted-property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="query_comun" id="8">
> <structure name="cachedMetaData"/>
> <property name="dataSource">macropanel</property>
> <property name="queryText">select * from dim_comuna22</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>
> <text id="6">
> <property name="contentType">auto</property>
> <text-property name="content"><![CDATA[Este reporte debe
> mostrar al menos una ciudad que se encuentra en
> <H1>
> dim_ciudad
> </H1>
> ]]></text-property>
> </text>
> </body>
> </report>
>
Re: BIRT 2.2.1 report error [message #513832 is a reply to message #513276] Thu, 11 February 2010 12:54 Go to previous messageGo to next message
pablo quezada roman is currently offline pablo quezada roman
Messages: 3
Registered: February 2010
Junior Member
no change...

same error.... do you thik that it could be a versions incompatibiliyty problem???
Re: BIRT 2.2.1 report error [message #513891 is a reply to message #513832] Thu, 11 February 2010 15:30 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

I just tried this in 2.2.1 and had no issue. I took the version and
comment out. The modified report is attached:

Jason

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007</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="macropanel"
id="7">
<property
name="odaDriverClass">org.postgresql.Driver</property>
<property
name="odaURL">jdbc:postgresql://localhost:5432/macropanel</property>
<property name="odaUser">postgres</property>
<encrypted-property name="odaPassword"
encryptionID="base64">cHF6YWRh</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="query_comun" id="8">
<structure name="cachedMetaData"/>
<property name="dataSource">macropanel</property>
<property name="queryText">select * from
dim_comuna22</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>
<text id="6">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[Este reporte debe
mostrar al menos una ciudad que se encuentra en
<H1>
dim_ciudad
</H1>
]]></text-property>
</text>
</body>
</report>


pablo quezada roman wrote:
> no change...
>
> same error.... do you thik that it could be a versions incompatibiliyty
> problem???
Previous Topic:BIRT API, html output format, images output as custom1, custom2, etc. - change?
Next Topic:Table bindings in birt 2.5.1
Goto Forum:
  


Current Time: Tue Sep 30 12:00:25 GMT 2014

Powered by FUDForum. Page generated in 0.10390 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software