| Infinite or NaN Error with Parameterised Query [message #165595] |
Tue, 30 May 2006 09:12  |
Eclipse User |
|
|
|
Originally posted by: iain.morrison.saic.com
Hi,
I've just started looking at BIRT and I'm having a problem with a
parameterised query when using the IDE:
select sum(volume) volume, sum(mass) mass, sum(energy) energy
from well_allocation wa, well_completions wc, wells wl
where wa.product_code = 'OIL'
and wa.disposition = 'TXT'
and wa.from_dateTime >= ?
and wa.from_dateTime < dateadd(dd, -1, dateadd(mm, 1, ?))
and wa.well_id = wc.well_id
and wa.completion_id = wc.completion_id
and wa.well_id = wl.well_id
and wl.field_id = ?
The query works fine when there's data to return, but if I set one of the
parameters so that it will return no records, when I preview the results
in the dataset, I get the following error:
An unexpected internal exception occurred.Please see log for detail.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Designer UI
Plug-in ID:org.eclipse.birt.report.designer.ui
Version:2.0.1
Error Code:Error.GUIException.invokedByUnexpectedException
Error Message:Infinite or NaN
The same query does not throw the error if I replace the parameters with
hard-coded values.
I'm running the 2.0.1 framework with Eclipse 3.1.2 and the database is SQL
Server.
Can anyone tell me if I'm doing anything wrong?
Thanks
Iain
|
|
|
| Re: Infinite or NaN Error with Parameterised Query [message #165641 is a reply to message #165595] |
Tue, 30 May 2006 10:08  |
| Eclipse User |
|
|
|
Originally posted by: iain.morrison.saic.com
I've discovered my problem, I had forgotten I'd created a calculated
column which was performing a division using data returned by the query,
thus when nothing came back, I got an error. I've worked around it with
an if statement.
How dumb do I feel answering my own question!
Sorry for taking up your time.
Iain
|
|
|
Powered by
FUDForum. Page generated in 0.07535 seconds
Home