BIRT 4.2.0

Hello everyone,

Actually i used to develop BIRT report using BIRT 3.7.0. All was well, meaning that the reports were generated succesfully without any errors.
I just downloaded "eclipse-reporting-juno-win32" to develop BIRT report .
whereby i started using BIRT 4.2.0. On generating the existing Reports, i get the following errors :
-Failed to prepare the query execution for the data set:
and
- There are errors evaluating script "dimension["Date_CR"]["Month"]<=BirtDateTime.month(new Date(),1) && measure["Total_Amnt"]!=0":
null

The same reports are generated without errors when using BIRT 3.7.0.
I have recreated the report identically but the errors persists
Can anyone please help me on this because this is very important ?

Comments

  • mwilliamsmwilliams BIRT Guru
    edited December 1969
    Can you create a report in 3.7 that shows the issue you're talking about when you run it in 4.2, using the sample database, so I can run it and test? Thanks!

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: mwilliams.silanis@gmail.com

  • edited December 1969
    Hello thanks for replying,

    well i recreated a sample report using BIRT 3.7 which consist of a dataset month and a datacube month only. I copied the same report on birt 4.2.0, well i worked fine.The database used is DB2 ,I am sorry i am not authorised to use any other tables other than this found in the database.

    As a matter of fact i will try my best to explain to you the problems in much details as possible.
    I really don't know where this error is coming from and is it that i have t o recreate the report once again using BIRT 4.2.0 to solve this issue (There are over 15 reports each consisting of around 4-5 datacubes).Recreating all these again will be very very time consuming.
    Thanks again for the reply and i hope you understand me for not being able to recreate a report generating the errors.
    One more thing, when i modify a report or the dataLibrary i get the alert message also (see attachment).


    On running the reports on BIRT 4.2.0 , i get the following errors on each reports created on BIRT 3.7:


    >>>>>>>>>>>>>>>>>
    The following items have errors:

    ReportDesign (id = 1):
    - An exception occurred during processing. Please see the following message for details:
    exception.error
    Error happens when create hierarchy:MMOIS.NewTabularHierarchy40.
    Failed to prepare the query execution for the data set: LIBRARY_DATA.Mois
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    Failed to prepare the query execution for the data set: LIBRARY_DATA.Mois
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection. (Element ID:1)

    exception.error ( 1 time(s) )
    detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
    exception.error
    Error happens when create hierarchy:MMOIS.NewTabularHierarchy40.
    Failed to prepare the query execution for the data set: LIBRARY_DATA.Mois
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    Failed to prepare the query execution for the data set: LIBRARY_DATA.Mois
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection. (Element ID:1)
    at org.eclipse.birt.report.engine.executor.ExecutorManager$ExecutorContext.executeQuery(ExecutorManager.java:451)
    at org.eclipse.birt.report.item.crosstab.core.re.executor.BaseCrosstabExecutor.executeQuery(BaseCrosstabExecutor.java:122)
    at org.eclipse.birt.report.item.crosstab.core.re.executor.CrosstabReportItemExecutor.execute(CrosstabReportItemExecutor.java:102)
    at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:62)
    at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
    at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
    at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
    at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
    at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)
    at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)
    at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
    at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
    at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
    at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132)
    at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
    at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
    at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
    at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
    at org.eclipse.birt.report.engine.layout.html.HTMLListLM.layoutChildren(HTMLListLM.java:72)
    at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
    at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
    at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
    at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
    at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
    at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:937)
    at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)
    at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(BirtRunAndRenderActionHandler.java:76)
    at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
    at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(EngineFragment.java:318)
    at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(AbstractBaseFragment.java:76)
    at org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(BirtEngineServlet.java:120)
    at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(BaseReportEngineServlet.java:185)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
    at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
    at org.eclipse.birt.report.servlet.BaseReportEngineServlet.service(BaseReportEngineServlet.java:116)
    at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
    at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
    at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128)
    at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
    at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:384)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:598)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:486)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1065)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:413)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:192)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:999)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)
    at org.eclipse.jetty.server.Server.handle(Server.java:350)
    at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:454)
    at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:890)
    at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:944)
    at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:630)
    at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:230)
    at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:77)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:606)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:46)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:603)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:538)
    at java.lang.Thread.run(Unknown Source)
    Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
    exception.error
    Error happens when create hierarchy:MMOIS.NewTabularHierarchy40.
    Failed to prepare the query execution for the data set: LIBRARY_DATA.Mois
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    Failed to prepare the query execution for the data set: LIBRARY_DATA.Mois
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)
    at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteCube(DteDataEngine.java:240)
    at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:272)
    at org.eclipse.birt.report.engine.executor.ExecutorManager$ExecutorContext.executeQuery(ExecutorManager.java:441)
    ... 68 more
    Caused by: org.eclipse.birt.data.engine.core.DataException: exception.error
    Error happens when create hierarchy:MMOIS.NewTabularHierarchy40.
    Failed to prepare the query execution for the data set: LIBRARY_DATA.Mois
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    Failed to prepare the query execution for the data set: LIBRARY_DATA.Mois
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.materializeCube(DataRequestSessionImpl.java:773)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:633)
    ... 71 more
    Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: Error happens when create hierarchy:MMOIS.NewTabularHierarchy40.
    Failed to prepare the query execution for the data set: LIBRARY_DATA.Mois
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    Failed to prepare the query execution for the data set: LIBRARY_DATA.Mois
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.populateDimension(DataRequestSessionImpl.java:1466)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.populateDimensions(DataRequestSessionImpl.java:1325)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.createCube(DataRequestSessionImpl.java:824)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.materializeCube(DataRequestSessionImpl.java:758)
    ... 72 more
    Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: Failed to prepare the query execution for the data set: LIBRARY_DATA.Mois
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    Failed to prepare the query execution for the data set: LIBRARY_DATA.Mois
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    at org.eclipse.birt.report.data.adapter.impl.DataSetIterator.executeQuery(DataSetIterator.java:88)
    at org.eclipse.birt.report.data.adapter.impl.DataSetIterator.<init>(DataSetIterator.java:121)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.populateDimension(DataRequestSessionImpl.java:1451)
    ... 75 more
    Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to prepare the query execution for the data set: LIBRARY_DATA.Mois
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:345)
    at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
    at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:159)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:142)
    at org.eclipse.birt.report.data.adapter.impl.DataSetIterator.executeQuery(DataSetIterator.java:84)
    ... 77 more
    Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
    [select SCHEMA_DATA.MOIS.NUM_MOIS, SCHEMA_DATA.MOIS.YEAR
    from SCHEMA_DATA.MOIS]
    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:54)
    at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)
    at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareOdaQuery(Connection.java:298)
    at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareStatement(Connection.java:197)
    at org.eclipse.birt.data.engine.executor.DataSource.prepareStatement(DataSource.java:302)
    at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:281)
    at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:442)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:341)
    ... 84 more
    Caused by: org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaObject.newOdaException(OdaObject.java:548)
    at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.newQuery(OdaConnection.java:565)
    at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareOdaQuery(Connection.java:285)
    ... 89 more



    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    However
  • edited July 2012
    Hello ,

    well i am able to post the xml codes for a birt Report which runs succesfully on BIRT 3.7 (created on 3.7) but yields an error when previewed on BIRT 4.2.0. I hope it is more clear to you to understand it more clearer. What i am not able to figure out out is whether the problem lies now sir

    A) XML source Code
    B) Errors

    A) - XML source code
    <?xml version="1.0" encoding="UTF-8"?>
    <report xmlns="http://www.eclipse.org/birt/2005/design"; version="3.2.22" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 3.7.0.v20110602 Build &lt;3.7.0.v20110607-1526></property>
    <list-property name="userProperties">
    <structure>
    <property name="name">POSE.POSE.x</property>
    <property name="type">integer</property>
    <property name="isVisible">false</property>
    </structure>
    <structure>
    <property name="name">POSE.POSE.y</property>
    <property name="type">integer</property>
    <property name="isVisible">false</property>
    </structure>
    <structure>
    <property name="name">POSE.ID_EQUIPE.NewTabularHierarchy109.x</property>
    <property name="type">integer</property>
    <property name="isVisible">false</property>
    </structure>
    <structure>
    <property name="name">POSE.ID_EQUIPE.NewTabularHierarchy109.y</property>
    <property name="type">integer</property>
    <property name="isVisible">false</property>
    </structure>
    <structure>
    <property name="name">POSE.ID_EQUIPE.NewTabularHierarchy109.width</property>
    <property name="type">integer</property>
    <property name="isVisible">false</property>
    </structure>
    <structure>
    <property name="name">POSE.ID_EQUIPE.NewTabularHierarchy109.height</property>
    <property name="type">integer</property>
    <property name="isVisible">false</property>
    </structure>
    <structure>
    <property name="name">POSE.ID_EQUIPE.NewTabularHierarchy753.x</property>
    <property name="type">integer</property>
    <property name="isVisible">false</property>
    </structure>
    <structure>
    <property name="name">POSE.ID_EQUIPE.NewTabularHierarchy753.y</property>
    <property name="type">integer</property>
    <property name="isVisible">false</property>
    </structure>
    <structure>
    <property name="name">POSE.ID_EQUIPE.NewTabularHierarchy753.width</property>
    <property name="type">integer</property>
    <property name="isVisible">false</property>
    </structure>
    <structure>
    <property name="name">POSE.ID_EQUIPE.NewTabularHierarchy753.height</property>
    <property name="type">integer</property>
    <property name="isVisible">false</property>
    </structure>
    </list-property>
    <property name="POSE.POSE.x">135</property>
    <property name="POSE.POSE.y">80</property>
    <property name="POSE.ID_EQUIPE.NewTabularHierarchy109.x">363</property>
    <property name="POSE.ID_EQUIPE.NewTabularHierarchy109.y">43</property>
    <property name="POSE.ID_EQUIPE.NewTabularHierarchy109.width">150</property>
    <property name="POSE.ID_EQUIPE.NewTabularHierarchy109.height">200</property>
    <property name="POSE.ID_EQUIPE.NewTabularHierarchy753.x">331</property>
    <property name="POSE.ID_EQUIPE.NewTabularHierarchy753.y">50</property>
    <property name="POSE.ID_EQUIPE.NewTabularHierarchy753.width">150</property>
    <property name="POSE.ID_EQUIPE.NewTabularHierarchy753.height">200</property>
    <property name="units">in</property>
    <property name="theme">cssStyleLibrary.Entete_Bleu</property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">96</property>
    <list-property name="libraries">
    <structure>
    <property name="fileName">CFIRST_DATA.rptlibrary</property>
    <property name="namespace">CFIRST_DATA</property>
    </structure>
    <structure>
    <property name="fileName">cssStyleLibrary.rptlibrary</property>
    <property name="namespace">cssStyleLibrary</property>
    </structure>
    </list-property>
    <parameters>
    <scalar-parameter name="IdEntite" id="9" extends="CFIRST_DATA.IdEntite"/>
    </parameters>
    <data-sets>
    <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="SUIVI_DES_POSES_ET_SAV_EQUIPE" id="7"
    extends="CFIRST_DATA.SUIVI_DES_POSES_ET_SAV_EQUIPE">
    <list-property name="filter">
    <structure>
    <property name="operator">eq</property>
    <expression name="expr" type="javascript">row["RANG"]</expression>
    <simple-property-list name="value1">
    <value>2</value>
    </simple-property-list>
    </structure>
    </list-property>
    </oda-data-set>
    <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="POSE" id="8"
    extends="CFIRST_DATA.POSE"/>
    </data-sets>
    <cubes>
    <tabular-cube name="POSE" id="10" extends="CFIRST_DATA.POSE">
    <overridden-values>
    <ref-entry baseId="5442" name="DATE_PREV3" id="5442">
    <property name="defaultHierarchy">NewTabularHierarchy74</property>
    </ref-entry>
    <ref-entry baseId="5443" name="NewTabularHierarchy74" id="5443"/>
    <ref-entry baseId="5444" name="Year" id="5444"/>
    <ref-entry baseId="5445" name="Month" id="5445"/>
    <ref-entry baseId="5451" name="DATE_CLOTURE" id="5451">
    <property name="defaultHierarchy">NewTabularHierarchy763</property>
    </ref-entry>
    <ref-entry baseId="5452" name="NewTabularHierarchy763" id="5452"/>
    <ref-entry baseId="5453" name="Year" id="5453"/>
    <ref-entry baseId="5454" name="Month" id="5454"/>
    <ref-entry baseId="5840" name="ID_EQUIPE" id="5840">
    <property name="defaultHierarchy">NewTabularHierarchy753</property>
    </ref-entry>
    <ref-entry baseId="5841" name="NewTabularHierarchy753" id="5841"/>
    <ref-entry baseId="5842" name="ID_EQUIPE" id="5842"/>
    <ref-entry baseId="5446" name="Summary Field26" id="5446"/>
    <ref-entry baseId="5447" name="ID_TRAVAIL" id="5447"/>
    <ref-entry baseId="5457" name="Summary Field273" id="5457"/>
    <ref-entry baseId="5458" name="NB_POSE_PREVUE_REALISE" id="5458"/>
    </overridden-values>
    </tabular-cube>
    <tabular-cube name="MOIS" id="5448" extends="CFIRST_DATA.MOIS">
    <overridden-values>
    <ref-entry baseId="1713" name="MMOIS" id="1713">
    <property name="defaultHierarchy">NewTabularHierarchy40</property>
    </ref-entry>
    <ref-entry baseId="1714" name="NewTabularHierarchy40" id="1714"/>
    <ref-entry baseId="1715" name="NUM_MOIS" id="1715"/>
    <ref-entry baseId="1716" name="MYEAR" id="1716">
    <property name="defaultHierarchy">NewTabularHierarchy44</property>
    </ref-entry>
    <ref-entry baseId="1717" name="NewTabularHierarchy44" id="1717"/>
    <ref-entry baseId="1718" name="YEAR" id="1718"/>
    <ref-entry baseId="1719" name="Summary Field17" id="1719"/>
    <ref-entry baseId="1720" name="NUM_MOIS" id="1720"/>
    </overridden-values>
    </tabular-cube>
    </cubes>
    <styles>
    <style name="report" id="4">
    <property name="fontFamily">sans-serif</property>
    <property name="fontSize">10pt</property>
    </style>
    </styles>
    <page-setup>
    <simple-master-page name="Simple MasterPage" id="2">
    <property name="type">a4</property>
    <property name="orientation">landscape</property>
    <page-footer>
    <grid id="3828">
    <property name="fontSize">8pt</property>
    <property name="textAlign">center</property>
    <property name="width">10.958333333333334in</property>
    <column id="3829">
    <property name="width">5.895833333333333in</property>
    </column>
    <column id="3830">
    <property name="width">0.22916666666666666in</property>
    </column>
    <column id="3831">
    <property name="width">4.833333333333333in</property>
    </column>
    <row id="3832">
    <cell id="3833">
    <property name="verticalAlign">middle</property>
    <auto-text id="3834">
    <property name="marginLeft">400pt</property>
    <property name="type">page-number</property>
    </auto-text>
    </cell>
    <cell id="3835">
    <text id="3836">
    <property name="contentType">plain</property>
    <text-property name="content"><![CDATA[/]]></text-property>
    </text>
    </cell>
    <cell id="3837">
    <property name="verticalAlign">middle</property>
    <auto-text id="3838">
    <property name="marginLeft">0pt</property>
    <property name="marginRight">330pt</property>
    <property name="type">total-page</property>
    </auto-text>
    </cell>
    </row>
    </grid>
    </page-footer>
    </simple-master-page>
    </page-setup>
    <body>
    <list id="5449">
    <property name="dataSet">SUIVI_DES_POSES_ET_SAV_EQUIPE</property>
    <list-property name="boundDataColumns">
    <structure>
    <property name="name">RANG</property>
    <text-property name="displayName">RANG</text-property>
    <expression name="expression" type="javascript">dataSetRow["RANG"]</expression>
    <property name="dataType">decimal</property>
    </structure>
    <structure>
    <property name="name">ID_EQUIPE</property>
    <text-property name="displayName">ID_EQUIPE</text-property>
    <expression name="expression" type="javascript">dataSetRow["ID_EQUIPE"]</expression>
    <property name="dataType">integer</property>
    </structure>
    <structure>
    <property name="name">LIBELLE</property>
    <text-property name="displayName">LIBELLE</text-property>
    <expression name="expression" type="javascript">dataSetRow["LIBELLE"]</expression>
    <property name="dataType">string</property>
    </structure>
    <structure>
    <property name="name">ID_ENTITE</property>
    <text-property name="displayName">ID_ENTITE</text-property>
    <expression name="expression" type="javascript">dataSetRow["ID_ENTITE"]</expression>
    <property name="dataType">integer</property>
    </structure>
    <structure>
    <property name="name">LIBELLEENTITE</property>
    <text-property name="displayName">LIBELLEENTITE</text-property>
    <expression name="expression" type="javascript">dataSetRow["LIBELLEENTITE"]</expression>
    <property name="dataType">string</property>
    </structure>
    <structure>
    <property name="name">Column Binding</property>
    <expression name="expression" type="javascript">"SUIVI DU TAUX DE RESPECT DE POSE "+row["LIBELLEENTITE"]+" PAR EQUIPE (en %)"</expression>
    <property name="dataType">string</property>
    </structure>
    <structure>
    <property name="name">AnneeAffCom</property>
    <text-property name="displayName">AnneeAffCom</text-property>
    <expression name="expression" type="javascript">row["Count CTCom"]
    if(BirtMath.mod((row["Count CTCom"]-1),3)==0){
    'Aff'
    }</expression>
    <property name="dataType">string</property>
    </structure>
    <structure>
    <property name="name">Count CTCom</property>
    <text-property name="displayName">Count CTCom</text-property>
    <expression name="expression" type="javascript">CountCTComA= reportContext.getPersistentGlobalVariable("CountCTComA_"+row["ID_EQUIPE"])

    if(CountCTComA==null || CountCTComA==''){
    CountCTComA=0
    }
    CountCTComA=parseInt(CountCTComA)+1</expression>
    <property name="dataType">integer</property>
    </structure>
    <structure>
    <property name="name">Count CT</property>
    <text-property name="displayName">Count CT</text-property>
    <expression name="expression" type="javascript">CountCT= reportContext.getPersistentGlobalVariable("CountCT")

    if(CountCT==null || CountCT==''){
    CountCT=0
    }
    CountCT=parseInt(CountCT)+1</expression>
    <property name="dataType">integer</property>
    </structure>
    <structure>
    <property name="name">AnneeAff</property>
    <text-property name="displayName">AnneeAff</text-property>
    <expression name="expression" type="javascript">row["Count CT"]
    if(BirtMath.mod((row["Count CT"]-1),4)==0){
    'Aff'
    }</expression>
    <property name="dataType">string</property>
    </structure>
    <structure>
    <property name="name">LibelleTotal</property>
    <text-property name="displayName">LibelleTotal</text-property>
    <expression name="expression" type="javascript">"Total "+row["LIBELLEENTITE"]</expression>
    <property name="dataType">string</property>
    </structure>
    </list-property>
    <detail>
    <grid id="5672">
    <property name="width">7.541666666666667in</property>
    <column id="8549">
    <property name="width">2.3645833333333335in</property>
    </column>
    <column id="8485">
    <property name="width">2.3645833333333335in</property>
    </column>
    <column id="5673">
    <property name="width">2.8125in</property>
    </column>
    <row id="5684">
    <cell id="8545"/>
    <cell id="8481"/>
    <cell id="5685">
    <label id="5687">
    <property name="fontWeight">bold</property>
    <property name="textAlign">center</property>
    <text-property name="text">Nb de pose prevue en M</text-property>
    </label>
    </cell>
    </row>
    <row id="5675">
    <cell id="8546">
    <extended-item extensionName="Crosstab" extensionVersion="2.5.0" id="8550">
    <property name="cube">POSE</property>
    <property name="measures">
    <extended-item extensionName="MeasureView" id="8551">
    <property name="measure">ID_TRAVAIL</property>
    <property name="detail">
    <extended-item extensionName="AggregationCell" id="8552">
    <property name="aggregationOnRow">DATE_PREV3/Month</property>
    <property name="aggregationOnColumn">ID_EQUIPE/ID_EQUIPE</property>
    <property name="content">
    <data id="8553">
    <property name="resultSetColumn">ID_TRAVAIL_DATE_PREV3/Month_ID_EQUIPE/ID_EQUIPE</property>
    </data>
    <data id="8554">
    <property name="borderBottomColor">#FF0000</property>
    <property name="borderBottomStyle">solid</property>
    <property name="borderLeftColor">#FF0000</property>
    <property name="borderLeftStyle">solid</property>
    <property name="borderRightColor">#FF0000</property>
    <property name="borderRightStyle">solid</property>
    <property name="borderTopColor">#FF0000</property>
    <property name="borderTopStyle">solid</property>
    <property name="resultSetColumn">SetGlobalNbPosesPrevues</property>
    </data>
    </property>
    <property name="width">67px</property>
    </extended-item>
    </property>
    <property name="aggregations">
    <extended-item extensionName="AggregationCell" id="8555">
    <property name="aggregationOnColumn">ID_EQUIPE/ID_EQUIPE</property>
    <property name="content">
    <data id="8556">
    <property name="resultSetColumn">ID_TRAVAIL_ID_EQUIPE/ID_EQUIPE</property>
    </data>
    <data id="8557">
    <property name="borderBottomColor">#FF8080</property>
    <property name="borderBottomStyle">solid</property>
    <property name="borderLeftColor">#FF8080</property>
    <property name="borderLeftStyle">solid</property>
    <property name="borderRightColor">#FF8080</property>
    <property name="borderRightStyle">solid</property>
    <property name="borderTopColor">#FF8080</property>
    <property name="borderTopStyle">solid</property>
    <property name="resultSetColumn">SetGlobalTotalNbPosesPrevues</property>
    </data>
    </property>
    </extended-item>
    </property>
    <property name="header">
    <extended-item extensionName="CrosstabCell" id="8558"/>
    </property>
    </extended-item>
    </property>
    <property name="rows">
    <extended-item extensionName="CrosstabView" id="8559">
    <property name="grandTotal">
    <extended-item extensionName="CrosstabCell" id="8560">
    <property name="content">
    <label id="8561">
    <text-property name="text">Grand Total</text-property>
    </label>
    </property>
    </extended-item>
    </property>
    <property name="views">
    <extended-item extensionName="DimensionView" id="8562">
    <property name="dimension">DATE_PREV3</property>
    <property name="levels">
    <extended-item extensionName="LevelView" name="NewLevel View62" id="8563">
    <property name="level">DATE_PREV3/Year</property>
    <property name="filter">
    <filter-condition-element>
    <expression name="expr" type="javascript">data["Year"]</expression>
    <property name="operator">eq</property>
    <simple-property-list name="value1">
    <value type="javascript">BirtDateTime.year(new Date())-1</value>
    </simple-property-list>
    </filter-condition-element>
    </property>
    <property name="member">
    <extended-item extensionName="CrosstabCell" id="8564">
    <property name="content">
    <data name="Year21" id="8565">
    <property name="resultSetColumn">Year</property>
    </data>
    </property>
    <property name="width">67px</property>
    </extended-item>
    </property>
    </extended-item>
    <extended-item extensionName="LevelView" name="NewLevel View121" id="8566">
    <property name="level">DATE_PREV3/Month</property>
    <property name="member">
    <extended-item extensionName="CrosstabCell" id="8567">
    <property name="content">
    <data name="Month21" id="8568">
    <property name="resultSetColumn">Month</property>
    </data>
    </property>
    <property name="width">67px</property>
    </extended-item>
    </property>
    </extended-item>
    </property>
    </extended-item>
    </property>
    <property name="mirrorStartingLevel">DATE_PREV3/Month</property>
    <property name="grandTotalLocation">after</property>
    </extended-item>
    </property>
    <property name="columns">
    <extended-item extensionName="CrosstabView" id="8569">
    <property name="views">
    <extended-item extensionName="DimensionView" id="8570">
    <property name="dimension">ID_EQUIPE</property>
    <property name="levels">
    <extended-item extensionName="LevelView" name="NewLevel View211" id="8571">
    <property name="level">ID_EQUIPE/ID_EQUIPE</property>
    <property name="filter">
    <filter-condition-element>
    <expression name="expr" type="javascript">data["ID_EQUIPE"]</expression>
    <property name="operator">eq</property>
    <simple-property-list name="value1">
    <value type="javascript">row._outer["ID_EQUIPE"]</value>
    </simple-property-list>
    </filter-condition-element>
    </property>
    <property name="member">
    <extended-item extensionName="CrosstabCell" id="8572">
    <property name="content">
    <data name="ID_EQUIPE21" id="8573">
    <property name="resultSetColumn">ID_EQUIPE</property>
    </data>
    </property>
    </extended-item>
    </property>
    </extended-item>
    </property>
    </extended-item>
    </property>
    <property name="grandTotalLocation">after</property>
    </extended-item>
    </property>
    <property name="header">
    <extended-item extensionName="CrosstabCell" id="8574">
    <property name="content">
    <label id="8575">
    <text-property name="text">Cumul Annee Precedent</text-property>
    </label>
    </property>
    </extended-item>
    </property>
    <property name="fontSize">7pt</property>
    <property name="borderTopStyle">solid</property>
    <property name="borderTopWidth">medium</property>
    <property name="borderTopColor">#80FFFF</property>
    <property name="borderLeftStyle">solid</property>
    <property name="borderLeftWidth">medium</property>
    <property name="borderLeftColor">#80FFFF</property>
    <property name="borderBottomStyle">solid</property>
    <property name="borderBottomWidth">medium</property>
    <property name="borderBottomColor">#80FFFF</property>
    <property name="borderRightStyle">solid</property>
    <property name="borderRightWidth">medium</property>
    <property name="borderRightColor">#80FFFF</property>
    <list-property name="boundDataColumns">
    <structure>
    <property name="name">Year</property>
    <expression name="expression">dimension["DATE_PREV3"]["Year"]</expression>
    <property name="dataType">integer</property>
    </structure>
    <structure>
    <property name="name">Month</property>
    <expression name="expression">dimension["DATE_PREV3"]["Month"]</expression>
    <property name="dataType">integer</property>
    </structure>
    <structure>
    <property name="name">ID_EQUIPE</property>
    <expression name="expression">dimension["ID_EQUIPE"]["ID_EQUIPE"]</expression>
    <property name="dataType">integer</property>
    </structure>
    <structure>
    <property name="name">ID_TRAVAIL_DATE_PREV3/Month_ID_EQUIPE/ID_EQUIPE</property>
    <expression name="expression">measure["ID_TRAVAIL"]</expression>
    <property name="dataType">integer</property>
    <simple-property-list name="aggregateOn">
    <value>DATE_PREV3/Month</value>
    <value>ID_EQUIPE/ID_EQUIPE</value>
    </simple-property-list>
    <property name="aggregateFunction">SUM</property>
    </structure>
    <structure>
    <property name="name">ID_TRAVAIL_ID_EQUIPE/ID_EQUIPE</property>
    <expression name="expression">measure["ID_TRAVAIL"]</expression>
    <property name="dataType">float</property>
    <simple-property-list name="aggregateOn">
    <value>ID_EQUIPE/ID_EQUIPE</value>
    </simple-property-list>
    <property name="aggregateFunction">SUM</property>
    </structure>
    <structure>
    <property name="name">SetGlobalNbPosesPrevues</property>
    <text-property name="displayName">SetGlobalNbPosesPrevues</text-property>
    <expression name="expression" type="javascript">var NbPosesPrevuesPMTotal=data["ID_TRAVAIL_DATE_PREV3/Month_ID_EQUIPE/ID_EQUIPE"]
    if(NbPosesPrevuesPMTotal!=null)
    {
    reportContext.setPersistentGlobalVariable("NbPosesPrevuesPMTotal_"+data["ID_EQUIPE"]+"_"+(BirtDateTime.year(new Date())-1)+"_"+data["Month"],NbPosesPrevuesPMTotal.toString());
    reportContext.getPersistentGlobalVariable("NbPosesPrevuesPMTotal_"+data["ID_EQUIPE"]+"_"+(BirtDateTime.year(new Date())-1)+"_"+data["Month"]);
    }
    else
    {
    "0"
    }</expression>
    <property name="dataType">string</property>
    </structure>
    <structure>
    <property name="name">SetGlobalTotalNbPosesPrevues</property>
    <text-property name="displayName">SetGlobalTotalNbPosesPrevues</text-property>
    <expression name="expression" type="javascript">var TotalNbPosesPrevuesPMTotal =data["ID_TRAVAIL_ID_EQUIPE/ID_EQUIPE"]
    if(TotalNbPosesPrevuesPMTotal !=null)
    {
    reportContext.setPersistentGlobalVariable("TotalNbPosesPrevuesPMTotal _"+data["ID_EQUIPE"]+"_"+(BirtDateTime.year(new Date())-1),TotalNbPosesPrevuesPMTotal.toString());
    reportContext.getPersistentGlobalVariable("TotalNbPosesPrevuesPMTotal _"+data["ID_EQUIPE"]+"_"+(BirtDateTime.year(new Date())-1));
    }
    else
    {
    "0"
    }</expression>
    <property name="dataType">string</property>
    </structure>
    </list-property>
    </extended-item>
    </cell>
    <cell id="8482"/>
    <cell id="5676"/>
    </row>
    <row id="5678">
    <cell id="8548"/>
    <cell id="8484"/>
    <cell id="5679"/>
    </row>
    </grid>
    </detail>
    </list>
    </body>
    </report>





    >>>> Errors

    The following items have errors:

    ReportDesign (id = 1):
    + An exception occurred during processing. Please see the following message for details:
    exception.error
    Error happens when create hierarchy:ID_EQUIPE.NewTabularHierarchy753.
    Failed to prepare the query execution for the data set: CFIRST_DATA.SUIVI_DES_POSES_ET_SAV_EQUIPE
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).?
    [select?
    ??? ROW_NUMBER() over (order by SCHEMAPOSE.EQUIPE.LIBELLE) as rang,?
    ??? SCHEMAPOSE.EQUIPE.ID_EQUIPE,
    ??? SCHEMAPOSE.EQUIPE.LIBELLE,
    ??? SCHEMAPOSE.EQUIPE.ID_ENTITE,
    ??? SCHEMACRM.ENTITE.LIBELLE as LIBELLEENTITE
    from SCHEMAPOSE.EQUIPE, SCHEMACRM.ENTITE

    where SCHEMAPOSE.EQUIPE.VALIDE=1
    and SCHEMACRM.ENTITE.VALIDE = 1
    and SCHEMACRM.ENTITE.ID_ENTITE = SCHEMAPOSE.EQUIPE.ID_ENTITE
    -- Ajout MRO le 13/01/2012
    and SCHEMAPOSE.EQUIPE.ID_ENTITE = ?

    order by rang asc

    ]
    ??? org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.
    Failed to prepare the query execution for the data set: CFIRST_DATA.SUIVI_DES_POSES_ET_SAV_EQUIPE
    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).?
    [select?
    ??? ROW_NUMBER() over (order by SCHEMAPOSE.EQUIPE.LIBELLE) as rang,?
    ??? SCHEMAPOSE.EQUIPE.ID_EQUIPE,
    ??? SCHEMAPOSE.EQUIPE.LIBELLE,
    ??? SCHEMAPOSE.EQUIPE.ID_ENTITE,
    ??? SCHEMACRM.ENTITE.LIBELLE as LIBELLEENTITE
    from SCHEMAPOSE.EQUIPE, SCHEMACRM.ENTITE

    where SCHEMAPOSE.EQUIPE.VALIDE=1
    and SCHEMACRM.ENTITE.VALIDE = 1
    and SCHEMACRM.ENTITE.ID_ENTITE = SCHEMAPOSE.EQUIPE.ID_ENTITE
    -- Ajout MRO le 13/01/2012
    and SCHEMAPOSE.EQUIPE.ID_ENTITE = ?

    order by rang asc

    ]
    ??? org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection. (Element ID:1)
  • mwilliamsmwilliams BIRT Guru
    edited December 1969
    According to your error, you're reaching the maximum number of concurrent statements for your connection. You might take a look at this page to see if you can up the number of allowable statements for a connection:

    http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.inst/djvtipe.htm

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: mwilliams.silanis@gmail.com

  • mwilliamsmwilliams BIRT Guru
    edited December 1969
    As for the warning you get when you change a library or design, that is normal. It wants to let you know that the design will upgrade to the newest version, if you change it and will not be compatible backwards.

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: mwilliams.silanis@gmail.com

  • edited December 1969
    Well thanks a lot fr the reply,
    There are some queries yet again ,
    -i observed that the design do change when working on BIRT 4.2.0 by considering the number of lines (XML-format)

    - The real issue for me is how to make the report run successfully under BIRT 4.2.0? Actually i am running BIRT reports under DB2 using the following driver (datasource):
    com.ibm.db2.jcc.DB2Driver ( v3.62)
  • mwilliamsmwilliams BIRT Guru
    edited December 1969
    Did you look at the link I posted above? Or is this a new issue? I would think if you were having a driver issue, you'd be getting a different error. If you design a simple report using your db2 database, without a cube, do you still get an error? Let me know.

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: mwilliams.silanis@gmail.com

  • edited August 2012
    hello again sir, sory for being late ...

    well you mean to design a simple report in BIRT 3.7.1 and opening it using BIRT 4.2.0?
    i tried one using a list and within the list(list's detail part) , i inserted a crosstab in BIRT 3.7.0.
    I used this method to create some report concisting of different datasets respectively .
    well, for some reports i found that, there was not a single error when i run the report using BIRT 4.2.0 is the error comming from datasets?

    I also checked the link but to be true i didn't understand too much.Again, any hint for the problems faced.

    Thanks again for your help sir.
    I am just too confused of how to find the solution when the root of the problem itself is not clear. I hope you understand what i mean.
  • edited December 1969
    Hi,

    I have the same issue with big crosstable since our upgrade to birt 4.2. I have the following message.

    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection. Do someone have an idea how to solve it?



    Regards,

    Patrick VALLET






    hello again sir, sory for being late ...



    well you mean to design a simple report in BIRT 3.7.1 and opening it using BIRT 4.2.0?

    i tried one using a list and within the list(list's detail part) , i inserted a crosstab in BIRT 3.7.0.

    I used this method to create some report concisting of different datasets respectively .

    well, for some reports i found that, there was not a single error when i run the report using BIRT 4.2.0 is the error comming from datasets?



    I also checked the link but to be true i didn't understand too much.Again, any hint for the problems faced.



    Thanks again for your help sir.

    I am just too confused of how to find the solution when the root of the problem itself is not clear. I hope you understand what i mean.

  • mwilliamsmwilliams BIRT Guru
    edited December 1969
    Are you also using DB2?

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: mwilliams.silanis@gmail.com

  • edited December 1969


    Are you also using DB2?




    I am getting the same error. Upgraded from 3.7 where joined datasets worked fine, now i am getting the same error as the DB2 error.

    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.



    This error is intermittent. One dataset on the report is joined to another. The second dataset tries to fire before the master dataset. I don't know how to get around this. It is a major issue to us.
  • mwilliamsmwilliams BIRT Guru
    edited December 1969
    You can make sure a dataSet fires before another by placing a text box bound to the first dataSet that needs to run, at the top of the report, or at least prior to the main dataSet.

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: mwilliams.silanis@gmail.com

  • edited September 2015
    Hi,

    I'm having a problem since I upgrade to birt 4.2. I have the following message:

    org.eclipse.birt.report.engine.api.EngineException:

    'An exception occurred during processing. Please see the following message for details: Failed to prepare the query execution for the data set:. xxxx

    Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet)...

     

    org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection.'

    Do someone have an idea how to solve it?

    i'm using sql server 

     


    When i use Birt 2.5, the report works normally 

  • Is it possible to attach your report design?

    What JDBC driver are you using?


    Does this happen with multiple reports are just the one report?


    If you create a new report, can you build data sets from the same data source using the same JDBC driver successfully?


    Regards,

     

    Jesse Freeman

    Solution Consultant

    OpenText Corporation

    http://www.actuate.com | http://www.opentext.com

     

  • Is it possible to attach your report design?

    Sorry, I can't attach. There are some confidential informations

     

    What JDBC driver are you using?

    I'm using jdbc:jtds:sqlserver

     

    Does this happen with multiple reports are just the one report?

    Only with that report.

    It happens only when i use some complex parameters, but when I use others less complexes, the chart appears without errors

     

    If you create a new report, can you build data sets from the same data source using the same JDBC driver successfully?

    Yes, normally

     

     

    tks

  • If you recreate the data sets/cubes from that report in a new report, does it end up getting the same error?


     


    Can you examine the connections from the SQL Server side to obtain more detailed information about how many connections are coming in before the error occurs?


    Regards,

     

    Jesse Freeman

    Solution Consultant

    OpenText Corporation

    http://www.actuate.com | http://www.opentext.com

     

Sign In or Register to comment.