[Scheduller Broken]

I scheduled job for 6:30am. Job works fine, its just not visible from Jasper UI interface.

[Scheduller Broken]

Job run fine although not listed in Jasper UI. I can see job clearly in postgres jasperserver.jireportjob table and all related jasperserver.jireport* tables.

DDoes anyone have idea why I am not seeing those schedules in Jasper UI?

 

 

[Scheduller Broken]

I should probably mention that I did edit js.quartz.properties and set accrodingly.

 

 

[Scheduller Broken]

Looks like I have broken report scheduller on Jasper Server 5.5.

I tried to setup first schedule for report, I got through all steps (Schedule, Output, Notofication) and clicked on "Save" at the end. Nothing happened, I stayed on the same page. I clicked on "Save" couple of times but still nothing. I went back to Library and to my surprise report shows "clock" next to it as if schedule is there. Yet when I tried to edit, there was nothing to edit, shedeller page was empty.

Any ideas?

Jasper Server 5.5

Centos 6.5 x64

 

 

[Scheduller doesn't work after upgrade from 3.5.0 to 3.7.1]

Where is Jasper server scheduller log? Maybe there is something overthere ...

[Scheduller doesn't work after upgrade from 3.5.0 to 3.7.1]

Ok, 404 error part solved ... wrong permissions.

 

Post Edited by mishomor at 01/24/2011 18:49

[Scheduller doesn't work after upgrade from 3.5.0 to 3.7.1]

uups it's getting worse now. When browsing to http://localhost:8080/jasperserver/ I am getting

HTTP STATUS 404 - /jasperserver/

Requested resource is not available

 

... but app is there. 

/opt/jasperserver/apache-tomcat/webapps/jasperserver

 

 

[Scheduller doesn't work after upgrade from 3.5.0 to 3.7.1]

bump.

anybody idea .. docs or where to look for help?

[Scheduller doesn't work after upgrade from 3.5.0 to 3.7.1]

Unfortunatelly I can't say yes or no since as I saw "successful" at the end I assumed everything went fine.

Inital installation was done by binary installer so I am guessing jasperadmin might be the case, but now I don't know how to fix it.

 

Post Edited by mishomor at 01/20/2011 19:57

[Scheduller doesn't work after upgrade from 3.5.0 to 3.7.1]

Followed Jasper Server 3.7.1 isntallation manual and upgaded from 3.5 according to docs. Whole process went smoothly but once login I found few issues. Most important one is that my shedules do not work anymore, nor they work if re-created.

Any idea?

Linux x86

 

Post Edited by mishomor at 01/20/2011 19:26

[Timestamp Pattern]

thanks Lucian

 

[sp OUT param into $P{parameter} or $V{var}?]

I have stored procedure with 3 OUT parameters. How to store value of those paramaters into iReport parameter $P{A},$P{B},$P{C} or Variables $V{A} ... and so on?

MySQL 5

 

 

 

Post Edited by mishomor at 01/14/2010 23:00

[Timestamp Pattern]

When defining timestamp pattern is there a way to derive that out of some function or ... similar.

Each morning I am doing sales report (as of yesterday) and want to automate delivery to users so that report they receive as attachmnet will have YESTERDAY's date in the name of the file. Currently if I put MMM_dd_yyyy it will always show current system date. 

 

 

 

 

 

Post Edited by mishomor at 01/19/2010 17:33

[Input Control casts date wrong?]

sjongenelen
Wrote:

read the forums :) set the data source timezone to blank

It works .... thanks sjongenelen!!

[Input Control casts date wrong?]

Hi,

I have date input control in my report. So if I pick a let's say 01-04-2010 it will show in my report as Sun Jan 03 16:00:00 PST 2010

and of course sql will return wrong data based on Jan-03-2010. It doens't matter what time I choose date it will always cast as one day before at 16:00:00.

I checked date, time and timezone on myserver and they are correct (Mon Jan 11 10:39:19 PST 2010). Also timezone of my Data Source is also correct America/Vancouver - Pacific Standard Time.

Any idea why my date input control date is wrong?

thanks!

Post Edited by mishomor at 01/11/2010 18:29

[Expressions how to??]

I have a hard time making any function.

I need something like 

(($F{b} - $F{a}) * 100) / $F{a}

... but it doensn't work for me like this.

 

 

 

 

[How to export ETL job to JasperServer 3.5?]

I exported java job as autonomous job and run it withoug problem through command line. Now I would like to have it  managed by JasperServer if it's possible but can't figure out how to prepare it for JasperServer. I tried exporting as .war but JasperServer didn't like it when importing and it spit out error messages. When importing resources within JasperServer I only have option to upload JAR but now WAR files. I am using JasperServer 3.5 community edition.

Any idea?

[DATE format ("DatePattern") giving wrong output]

TOS 3.2.1

I got resultset from database containing list of dates pulled in format "MM-dd-yyyy" which are then passed to InformixInput control as arguments of select statement. Thing is ... ones passed InformixInput will give me error.

java.sql.SQLException: Invalid year in date

so ... instead of sending parameters to InformixInput I sent them to myself in email body to see how date looks like and it striked me that date came back as

Tue Jan 05 00:00:00 PST 2010

... and that's definitely not what I want.

 

So my question is ... why date didn't come out in "MM-dd-yyyy" format as expected and how to fix it?

 

 

 

 

 

 

[Crosstab issues]

 

kchaudry, thanks for the quick reply!!

Thing is I would need two row groupings, but one of them should have subtotal (Division). Then I would need one column grouping (STORE) but three detail fields. Two from database (TY, LT) and third calculated between two "%". Then there is summary column (STORES TOTAL) with same fields and finally at the end not shown here should be totals for all columns. I hope inserted picture can help you.

/uploads/projects/ireport/image/daily_sales.jpg

 

 

Post Edited by mishomor at 01/07/2010 17:22

[Crosstab issues]

Can't figure out how to use crosstab. Wizard is too limited and no documentation around to learn more.

Anyone had idea where to look for more info?

 

 

 

Post Edited by mishomor at 01/07/2010 00:53