|
Re: Some queries not working following move to Juno (i.e.BIRT 4.2) [message #903624 is a reply to message #903592] |
Fri, 24 August 2012 15:08 |
|
If you develop reports in 4.2 they are not going to run on a 3.7.2
deployment. In development by default a parameter file gets created
that is used for subsequent runs. When you run the report do you get
prompted for the parameter?
Jason
On 8/24/2012 9:04 AM, Paul Ramsden wrote:
> Yesterday I moved to eclipse Juno. Previously I was using BIRT 3.7.2 and
> now it is 4.2.0. The deployment still runs with BIRT 3.2.7.
>
> I have a library with about 15 DataSets. I found that 2 of them throw
> the following error when previewing the results:
>
>
> Cannot execute the statement.
> JDBCexception: SQL staement does not return a ResultSet object.
> SQL error #1: Value for parameter number 1 was not set.
>
>
> The first time I got this, it disappeared after I edited the query. I
> believe that I only removed some spaces.
>
> The second time I have not been able to correct the problem.
>
> I checked the deployment and that seems fine. It seems to just be a
> problem in the development environment.
>
> Does anyone know what might be causing this?
|
|
|
|
Re: Some queries not working following move to Juno (i.e.BIRT 4.2) [message #904026 is a reply to message #903880] |
Mon, 27 August 2012 15:29 |
|
Paul,
Look for the same file name with an extension of rptconfig. You should
be able to delete it without any issues.
Jason
On 8/27/2012 1:16 AM, Paul Ramsden wrote:
> At present, I'm only having problems with one query. The error occurs
> when using the Preview Results page of the Data Set wizard as well as
> the Preview tab of the report. If I remove the WHERE clause there is no
> error.
>
> The 3 parameters are defined with default values and there is no prompt
> when I switch to the Preview Results page.
>
> You mention a parameter file. Where is that stored? Can I delete it?
>
> Thanks
> Paul
|
|
|
|
Powered by
FUDForum. Page generated in 0.03590 seconds