[error importing jasperserver 3.1 data into 3.5 (looking to upgrade to 4.5)]

 Hi, Josh,

Migrating from 3.1 to 4.5 can be huge challenge. 

1. download from 3.1 and upload to 4.5 using ireport 4.5

To me ...trackling one by one rather than a bunch of 400 problems.

Once you have noticed the workaround, the rest ll be smooth.

May sound crazy ...its work fine with me.

 

Chen

[Cannot upload JRXML file in repository]

 LK,

Since your jrxml contains an image, what is your image expression ? 

It must not contains any local path otherwise JS invalidate your jrxml.

You need to upload the image separately.

Hope this works !

Chen

[Cannot upload JRXML file in repository]

Interesting ..... Error 5321 ...looks your harddisk space running out ? 

 How do you create your jrxml file ? 

If you are using ireport ....what is your version ? Best choice is iReport 4.5 on JS4.5

Is the user permission to database correctly set ? I assume you are using postgresql !

What is the JVM settings ?

can u upload your jrxml ? 

 

 

[Cannot upload JRXML file in repository]

 LK,

 You did not indicate that you are unable to upload jrxml file via website. 

Yr JS should report any error unless you have disabled the logging.

As you have said that there is no error in JS, then you try to degrade your iReport.

If your JS is v4.0, have you try the iReport 4.0.2, 4,1  or even 3.7.6 or below?

If your JS is 3.1, any major release of iReport other than ir3.0  may not work. 

have you uninstall, delete all residual files and re-install as NEW ?

My experience is that I can download and cannot update or upload. Classpath, JVM Settings needs to be checked and corrected in the iReport. Otherwise ...hold on the working version.  

 

Chen

 

Post Edited by chenny at 02/29/2012 01:21

[Cannot upload JRXML file in repository]

 My jrxml is more 100kb ..... 

I currently used  the latest jasperserver 4.5 and  Jaspersoft iReport Designer 4.5.0.

My experience was JS 4.0.1 was problematic and so moved back to js3.7 

Now testing  JS4.5 !

 

Post Edited by chenny at 02/28/2012 13:06

[error importing jasperserver 3.1 data into 3.5 (looking to upgrade to 4.5)]

Well, I guess you can copy the user data from js31 database

[Cannot upload JRXML file in repository]

Did you try to upload via web browser ?  What was the error given in the server log file ?

 

 

 

[Cannot upload JRXML file in repository]

 It is more likely the installation of JS 4.5 database is corrupted or incompleted. Try to delete the database and re-installed.

[Having two JS installation at the same time.]

 All you need to do ....you are manually insert war into tomcat6 after you manually edited all required settings to run as jasperserver2.

 

[error importing jasperserver 3.1 data into 3.5 (looking to upgrade to 4.5)]

I do encounter the same problem. There is a huge compatibility problems from 3.1 to 4.5 in particular of your jrxml files.

I do recommend you to install as new,  maintain the existing 3.1 and transfering  your jrxml files. 

[Multi selection query $X{IN, param1, param2} BUG!]

 Hi,

 

I am glad to see the great improvement on the functionality of $X{IN, param1, param2}. 

However I am unable to get things work. 

case 1.

<parameter name="CountryList" class="java.util.List"/>

<queryString><![CDATA[

SELECT * FROM Orders WHERE $X{IN, ShipCountryid, CountryList}

]]></queryString>

 

case 2.

 

<parameter name="CountryList" class="java.util.Collection"/>

<queryString><![CDATA[

SELECT * FROM Orders WHERE $X{IN, ShipCountryid, CountryList}

]]></queryString>

 

 

I got an error in both cases. The error is 

 

 org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying.

Then I noticed that param1 must be a character varying. 

 

Please guide me ...

 

David
 

 

 

 

 

 

Post Edited by chenny at 02/27/2012 06:48

[Strange date error]

Suggest to check on FAQ.

Most of us is defaultly set db server to localtime and JVM's timezone is defaulted to CET (unawared).

You need to change these parameters to GMT as well in jasperserver otherwise it won't work correctly.

The best solution is to convert your date/timestamp into text in SQL..... then In your reports convert text back into date. 

rgds

 

 

[More queries in the same report?]

Andrea,

Just modify your sql query into query within query.

Rgds

[Incorrect date results]

Hi,

I am using iReport 3.0.0 and JasperServer 3.0.0 with Postgresql 8.3. My report query is

 

select rapiderp.findstartperiod($P{periodID}) , rapiderp.findendperiod($P!{periodID})::date as aging_run_date, ar.customerid as aging_customerid, cu.name as customers_name,cu.name_ch as name_chinese,  cu.agentgroupid as customers_agentgroupid, ag.groupname,
sum(case when ar.period_id<$P{periodID} then ar.amount else 0.00 end) as aging_openingbalance,
sum(case when ar.period_id<=$P{periodID} then ar.amount else 0.00 end) as aging_closingbalance,
sum(case when ar.period_id=$P{periodID} and ar.sourcetype='IN' and iv.invoice_balance is not null then iv.totalamount-coalesce(
(select sum(rd.amount) from rapiderp.receiptdetails rd, rapiderp.receipts rr where rr.receiptid=rd.receiptid and rd.sourceidapplied=iv.invoiceno
    and rr.period_id<=$P{periodID}),0.00)::numeric else 0.00 end)...........

 

 

IF the periodID is 152 ....it should result in the rapiderp.findendperiod($P{periodID}) as '2008-07-31'::date. But it always display as

2007-07-30 in the reports.

or perodID=153 ..-> 2008-08-31 .....print out as "2008-08-30".

 

Please assist ..

 

Regards

 

David