Eclipse Community Forums: BIRT » Table (id=585)

Home » Archived » BIRT » Table (id=585) - Can not load the report query(Table (id=585) - Can not load the report query)

Table (id=585) - Can not load the report query [message #740615]

Tue, 18 October 2011 14:03

Eclipse User

Hi,

I am brand new to BIRT and am trying to run a report TransactionStatus.rptdesign. I am using CGI's Momentum to run the report. Unfortunately, I cannot copy the error stack trace due to the fact that it is being produced on a classified machine. The error that I am getting looks something like this -

The following items have errors :
Table(id=585):
-Can not load the report query:585.
Error. ReportQueryLoadingError (1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 585.

I was hoping that someone has run into this error before and can provide me with some ideas on where to look or how to fix this issue. Any help is greatly appreciated!

Re: Table (id=585) - Can not load the report query [message #740652 is a reply to message #740615]

Tue, 18 October 2011 14:50

Eclipse User

What data source are you using?

Jason

On 10/18/2011 2:03 PM, sswaine wrote:
> Hi,
>
> I am brand new to BIRT and am trying to run a report
> TransactionStatus.rptdesign. I am using CGI's Momentum to run the
> report. Unfortunately, I cannot copy the error stack trace due to the
> fact that it is being produced on a classified machine. The error that I
> am getting looks something like this -
>
> The following items have errors :
> Table(id=585):
> -Can not load the report query:585.
> Error. ReportQueryLoadingError (1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: Can not
> load the report query: 585.
>
> I was hoping that someone has run into this error before and can provide
> me with some ideas on where to look or how to fix this issue. Any help
> is greatly appreciated!

Re: Table (id=585) - Can not load the report query [message #740663 is a reply to message #740652]

Tue, 18 October 2011 15:04

Eclipse User

What are some examples of data sources? I know we query against oracle databases for our custom reports that report on the same data.

Re: Table (id=585) - Can not load the report query [message #740694 is a reply to message #740663]

Tue, 18 October 2011 15:46

Eclipse User

If you look at the report design the table that is failing will be tied
to a dataset. This dataset will be tied to a datasource like jdbc, flat
file, xml etc. If you are using JDBC, do you have the particular jdbc
driver deployed with the the report engine?

Jason

On 10/18/2011 3:04 PM, sswaine wrote:
> What are some examples of data sources? I know we query against oracle
> databases for our custom reports that report on the same data.

Re: Table (id=585) - Can not load the report query [message #740791 is a reply to message #740694]

Tue, 18 October 2011 18:25

Eclipse User

Ok, the datasource is JDBC. How can I check to make sure that the driver is deployed with the report engine?

Re: Table (id=585) - Can not load the report query [message #741408 is a reply to message #740791]

Wed, 19 October 2011 09:56

Eclipse User

If the version of BIRT you are using is 2.6.2 or earlier you need to
find where the engine is deployed and put the jdbc driver in the
\birt-runtime-version\ReportEngine\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers
directory.

Jason

On 10/18/2011 6:25 PM, sswaine wrote:
> Ok, the datasource is JDBC. How can I check to make sure that the driver
> is deployed with the report engine?

Re: Table (id=585) - Can not load the report query [message #741433 is a reply to message #741408]

Wed, 19 October 2011 10:23

Eclipse User

I found that directory and there are 2 files in the drivers folder - ojdbc6-0.0.jar and readme.txt. Is that all that's supposed to be there?

Re: Table (id=585) - Can not load the report query [message #741450 is a reply to message #741433]

Wed, 19 October 2011 10:47

Eclipse User

It depends on how many different jdbc sources your are using. Is your
report using the ojdbc6-0.0.jar for the driver?

Jason

On 10/19/2011 10:23 AM, sswaine wrote:
> I found that directory and there are 2 files in the drivers folder -
> ojdbc6-0.0.jar and readme.txt. Is that all that's supposed to be there?

Previous Topic:	HMTL to Plain Text Computed column
Next Topic:	use parameterPage tag to run report in same JSP page

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 05:26:39 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter