[SOLVED]Scheduler send 2 mails ?

[azpyrine]

Hello,

 

Since migration to Jasperserver 4.0, some of my reports schedules send two mails.

Are you any idea?

 

Thank you for your help

 

Cédric

Post Edited by azpyrine at 03/17/2011 07:18

[azpyrine]

Hi,

 

After uninstall/install jaspersever and mysql, i have the same problem.

Quartz/Jasper send 2 notifications for one schedule !

 

Why ?

 

Thanks

[brooneyx1]

Same here, I have Jasper Server Pro - Looks to me like there is a timeout (3 minutes in my case). happening and a new report is kicked off.This will cause an exception if you do not have the overwrite checkbox checked, since it uses the same timestamp for report # 2.

 

[ramnik]

This is side effect of new cluster job scheduler in JS Pro 4.0

But YOU can EASILY FIX it

Details:-

1. Go to {JS_INSTALL_DIR}/tomcat/webapp/jasperserver_pro/WEB_INF

2. edit the file - js.quartz.base.properties

3. change org.quarts.jobStore.clusterCheckinInterval = 900 000 msec

Description:-

increase the org.quartz.jobStore.clusterCheckinInterval to 900 000 msec=15 min.
This value sets the interval(from start time of executing job) at the end of
which the recover job will fire. It is very import in the case of clustering:If
job will failed on the one cluster node(For example in the case of application
stopped on the node) then it will be successfully recovered on the other
node(per clusterCheckinInterval).
I increased this value to 15 min because for complex report(time executing is
big) time of job executing will be able more than 10 min and then recovering
job will result the problems (such as in bugs#22057, 22045, 22058).

In addition
"..When you have smaller or bigger executing report time than 15 you will
decrease or increase appropriately this value for correct job recovering
work.."

 

It will surely solve the issue and this setting has been tested and verified internally ..

Ramnik Kaur

Senior QA Engineer

[azpyrine]

Thanks very much.

 

Yesterday i change this configuration in js.quartz.base.properties :

# org.quartz.scheduler.instanceId = AUTO

# org.quartz.jobStore.isClustered = true

# org.quartz.jobStore.clusterCheckinInterval = 900000

 

This morning the problem is solved.

 

If i understand, it is possible to simply increase the "org.quartz.jobStore.clusterCheckinInterval" ?

 

Thanks.

 

Cédric

 

 

 

 

[ramnik]

For next release, the default value for the Interval has been increased ..to avoid error

Ramnik Kaur

Senior QA Engineer

[shivani.pal]

Hi,

my jasper version is --> 6.1

i have made all possible changes in my \WEB-INF\js.quartz.base.properties file , but nothing works for me

my recent configuration :

org.quartz.scheduler.instanceName=JasperServerScheduler

org.quartz.scheduler.instanceId = AUTO
org.quartz.jobStore.isClustered = true
org.quartz.jobStore.clusterCheckinInterval = 900000

org.quartz.threadPool.threadCount=2
org.quartz.threadPool.threadPriority=3

org.quartz.jobStore.misfireThreshold=180000

 i have increased my clusterCheckinInterval  time as well upto 35 minutes and threshold too , but nothing gets work for me . my reports  max take 15 min for execution .

kinldy , provide any solution.