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

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

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

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

Tue, 18 October 2011 14:03

sswaine
Messages: 4
Registered: October 2011

Junior Member

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!

Report message to a moderator

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

Tue, 18 October 2011 14:50

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

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!

Jason Weathersby

BIRT Exchange

Report message to a moderator

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

Tue, 18 October 2011 15:04

sswaine
Messages: 4
Registered: October 2011

Junior Member

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

Report message to a moderator

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

Tue, 18 October 2011 15:46

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

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.

Jason Weathersby

BIRT Exchange

Report message to a moderator

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

Tue, 18 October 2011 18:25

sswaine
Messages: 4
Registered: October 2011

Junior Member

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

Report message to a moderator

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

Wed, 19 October 2011 09:56

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

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?

Jason Weathersby

BIRT Exchange

Report message to a moderator

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

Wed, 19 October 2011 10:23

sswaine
Messages: 4
Registered: October 2011

Junior Member

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?

Report message to a moderator

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

Wed, 19 October 2011 10:47

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

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?

Jason Weathersby

BIRT Exchange

Report message to a moderator

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 [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 18:00:03 EDT 2013