Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 18:03 Go to next message
sswaine is currently offline 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!
Re: Table (id=585) - Can not load the report query [message #740652 is a reply to message #740615] Tue, 18 October 2011 18:50 Go to previous messageGo to next message
Jason Weathersby is currently offline 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!
Re: Table (id=585) - Can not load the report query [message #740663 is a reply to message #740652] Tue, 18 October 2011 19:04 Go to previous messageGo to next message
sswaine is currently offline 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.
Re: Table (id=585) - Can not load the report query [message #740694 is a reply to message #740663] Tue, 18 October 2011 19:46 Go to previous messageGo to next message
Jason Weathersby is currently offline 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.
Re: Table (id=585) - Can not load the report query [message #740791 is a reply to message #740694] Tue, 18 October 2011 22:25 Go to previous messageGo to next message
sswaine is currently offline 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?
Re: Table (id=585) - Can not load the report query [message #741408 is a reply to message #740791] Wed, 19 October 2011 13:56 Go to previous messageGo to next message
Jason Weathersby is currently offline 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?
Re: Table (id=585) - Can not load the report query [message #741433 is a reply to message #741408] Wed, 19 October 2011 14:23 Go to previous messageGo to next message
sswaine is currently offline 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?
Re: Table (id=585) - Can not load the report query [message #741450 is a reply to message #741433] Wed, 19 October 2011 14:47 Go to previous message
Jason Weathersby is currently offline 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?
Previous Topic:HMTL to Plain Text Computed column
Next Topic:use parameterPage tag to run report in same JSP page
Goto Forum:
  


Current Time: Tue Sep 16 17:43:05 GMT 2014

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

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