search

phamtuanchip / myschedule

Automatically exported from code.google.com/p/myschedule
0 stars 1 forks source link

Couldn't acquire next trigger: ORA-00904: "SCHED_TIME": invalid identifier #131

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Deploy the myschedule.war in tomcat webapps folder
2. Run tomcat
3. Open the GUI and configure the oracle data source
4. Save a new template and create an oracle scheduler 
5. In the tomcat logs you will see the below stack trace

ERROR OracleDatabaseScheduler_QuartzSchedulerThread An error occurred while scan
ning for the next triggers to fire.
org.quartz.JobPersistenceException: Couldn't acquire next trigger: ORA-00904: 
"SCHED_TIME": invalid identifier
 [See nested exception: java.sql.SQLSyntaxErrorException: ORA-00904: "SCHED_TIME
": invalid identifier
]

What is the expected output? What do you see instead?

Please use labels and text to provide additional information.

Original issue reported on code.google.com by 09.tus...@gmail.com on 22 Jul 2014 at 7:27

Attachments:

GoogleCodeExporter commented 9 years ago 
Hi,

That sure seems like a strange error. I don't see "SCHED_TIME" anywhere in our 
code. Can you print the full stacktrace?

Thanks,
Zemian

Original comment by saltnlight5 on 31 Jul 2014 at 2:18

GoogleCodeExporter commented 9 years ago 
It looks like SCHED_TIME column is part of qrtz_fired_triggers table from 
quartz scheduler,
I had added SCHED_TIME NUMBER(13) in the table and now it seems to work fine.

Original comment by 09.tus...@gmail.com on 31 Jul 2014 at 2:29

GoogleCodeExporter commented 9 years ago 
Ah, that's good to hear. Thanks for letting me know!

Original comment by saltnlight5 on 1 Aug 2014 at 2:26