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

[GoogleCodeExporter]

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 [email protected] on 22 Jul 2014 at 7:27

Attachments:

• OracleDBError.JPG

[GoogleCodeExporter]

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]

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 [email protected] on 31 Jul 2014 at 2:29

[GoogleCodeExporter]

Ah, that's good to hear. Thanks for letting me know!

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

• Changed state: Answered
• Added labels: Type-Question
• Removed labels: Type-Defect