Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT 4.2.0(Error while generating report )
BIRT 4.2.0 [message #899564] Wed, 01 August 2012 13:04 Go to next message
Mohammad subdurally is currently offline Mohammad subdurally
Messages: 4
Registered: August 2012
Junior Member
Hello everyone,

Previously i used to develop BIRT report using BIRT 3.7.0 using DB2. I have recently

I have recently downloaded "eclipse-reporting-juno-win32" to develop BIRT report .
whereby i started using BIRT 4.2.0.


Generating The report created on the previous version of birt (BIRT 3.7.0) gives the following errors:


The following items have errors:

ReportDesign (id = 1):
+ The following visibility expression does not evaluate to a legal boolean value: null. (Element 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_CM.MOIS.NUM_MOIS, SCHEMA_CM.MOIS.YEAR
from SCHEMA_CM.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_CM.MOIS.NUM_MOIS, SCHEMA_CM.MOIS.YEAR
from SCHEMA_CM.MOIS]
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Maximum active concurrent statements reached for this connection. (Element ID:1)














In addition to this when i am creating a brand new report using BIRT 4.2.0, i am still obtaining the above error.


I am using the following jars in my datasource:

db2jcc
db2jcc-
db2jcc_license_cu
db2jcc_license_cu-
sqljdbc-1.2




I don't know exactly where the error comes from though i have searched a lot but to no avail, can anyone please help me solve this issue, It is really very urgent.

Thanks in advance.
Re: BIRT 4.2.0 [message #899644 is a reply to message #899564] Wed, 01 August 2012 16:08 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you post the report?

Jason

On 8/1/2012 9:04 AM, Mohammad subdurally wrote:
> Hello everyone,
>
> Previously i used to develop BIRT report using BIRT 3.7.0 using DB2. I
> have recently
> I have recently downloaded "eclipse-reporting-juno-win32" to develop
> BIRT report .
> whereby i started using BIRT 4.2.0.
>
>
> Generating The report created on the previous version of birt (BIRT
> 3.7.0) gives the following errors:
>
>
> The following items have errors:
>
> ReportDesign (id = 1):
> + The following visibility expression does not evaluate to a legal
> boolean value: null. (Element 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_CM.MOIS.NUM_MOIS, SCHEMA_CM.MOIS.YEAR
> from SCHEMA_CM.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_CM.MOIS.NUM_MOIS, SCHEMA_CM.MOIS.YEAR
> from SCHEMA_CM.MOIS]
>
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException:
> Maximum active concurrent statements reached for this connection.
> (Element ID:1)
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> In addition to this when i am creating a brand new report using BIRT
> 4.2.0, i am still obtaining the above error.
>
>
> I am using the following jars in my datasource:
>
> db2jcc
> db2jcc-
> db2jcc_license_cu
> db2jcc_license_cu-
> sqljdbc-1.2
>
>
>
>
> I don't know exactly where the error comes from though i have searched a
> lot but to no avail, can anyone please help me solve this issue, It is
> really very urgent.
>
> Thanks in advance.
>
Previous Topic:My report is PAGE BROKEN on SOME pages although I didn't use PAGE BREAK
Next Topic:BIRT 3.7.2 Report Viewer on designer doesn't load the reports
Goto Forum:
  


Current Time: Sat Oct 25 14:41:11 GMT 2014

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

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