[Opensource] HELP - JOBS

[Michael Rimov]

Turgay,

At 04:30 PM 7/3/2002 +0000, you wrote:
>Hi,
>
>I do not know what is wrong with the Jobs. Every now and then I get the 
>following when I start the expresso:
>ConfigManager: Expresso initialization complete
>2002-07-03 12:22:52,138 ERROR [Thread-10] utility.JobHandler 
>(JobHandler.java:73
>5) - JobHandler unable to start correctly
>com.jcorporate.expresso.core.db.DBException: No such field as 'StatusCode' 
>in ob
>ject 'com.jcorporate.expresso.services.dbobj.JobQueue'

I've seen that happen once in a while before, and it turned out for my case 
that the DBException wasn't correct.  If you run in a debugger, I'd highly 
recommend putting a breakpoint at the exception in JobHandler that throws 
that Exception and see what's really going on.  IIRC I fixed that reporting 
problem in my batch to check into CVS.

>Well when I restart it things seem fine. However recently my jobs do not 
>get started any more. What happens is that the status field in the Job 
>table is set to completed when a job is not created. I have dumps in  my 
>job constructor and they do not appear. Suddenly things went back to 
>normal and now again I have the same problem! What could possibly cause that?

I believe there was a bug in JobHandler where if a Job thew a Throwable 
(and I think even an Exception) that stack would wind past the run() and 
the JobHandler would then die.  I've wrapped the Job execution in a 
try/catch(Throwable) block to see if that would help and so far I've had 
lots of buggy jobs die and JobHandler seems to keep on ticking. :)  I 
checked the changelog.xml file and it seems that this fix was in ea-3 so 
you MIGHT want to give it a try [or wait until ea-4]

HTH, and sorry about the trouble you're having with Jobs, it's getting 
slowly but surely tracked down.  And I want to especially thank Eddie Lewis 
for his doc on Jobs and scheduling.  Saves everybody _a lot_ of spelunking 
code!

                                         -Mike