ReportDesign (id = 1): Error [message #545682] |
Thu, 08 July 2010 15:08 |
|
Hi All,
While running (BIRT2.2.1) rptdesing in html mode i am getting following error. Could any one suggest me.
ReportDesign (id = 1):
- Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-01722: invalid number
Thanks,
JP
Thanks,
JP
|
|
|
|
Re: ReportDesign (id = 1): Error [message #545857 is a reply to message #545682] |
Fri, 09 July 2010 12:37 |
|
Hi
I am able to run report successfully at development (birt), but when i deploy at server i am getting this error and not getting output. i have checked my queries and every thing is fine.
Thanks,
JP
Thanks,
JP
|
|
|
Re: ReportDesign (id = 1): Error [message #545870 is a reply to message #545682] |
Fri, 09 July 2010 13:42 |
|
Are you using a parameter in your dataset? The Invalid Number error from Oracle can occur when you pass a string into a decimal/integer parameter slot (which sometimes works because of implied casting along the way). I had a report in which one table only failed with that error, and only at run time. Also, if your dataset has parameters, check to see what you have set in the dataset parameter list for defaults; an incorrect type there can also generate this error.
Best option for you is to take the dataset itself and put it into another report, then hook in the table, then add any parameters (and check the dataset parameter binding on the table object as well). You may need to essentially rebuild the report piecemeal to find out where the glitch is.
Sorry that I can't be of more specific help.
|
|
|
Re: ReportDesign (id = 1): Error [message #546321 is a reply to message #545870] |
Mon, 12 July 2010 13:17 |
|
Hi Richard,
Thanks for your help, i have done the same and now i am able to get output with out errors in development environment. But while running in server two columns not showing . i am getting the following error java.sql.SQLException: Unsupported feature
Please suggest me.
Thanks,
JP
Thanks,
JP
|
|
|
|
Powered by
FUDForum. Page generated in 0.03518 seconds