Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » BIRT 4.2.0(Error while generating report )

Show: Today's Messages :: Show Polls :: Message Navigator

BIRT 4.2.0 [message #899564]

Wed, 01 August 2012 13:04

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.

Report message to a moderator

Re: BIRT 4.2.0 [message #899644 is a reply to message #899564]

Wed, 01 August 2012 16:08

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.
>

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 29 09:22:22 GMT 2023

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter