Thursday, June 27, 2013

Field ‘PRIORITY’ doesn’t have a default value BI 4.8.0

ERROR [org.quartz.core.ErrorLogger] An error occured while scanning for the next trigger to fire.org.quartz.JobPersistenceException: Couldn’t acquire next trigger: Field ‘PRIORITY’ doesn’t have a default value
[See nested exception: java.sql.SQLException: Field 'PRIORITY' doesn't have a default value]


Solution :-


Simply to set the DEFAULT of the column to 0 in following tables

QRTZ_TRIGGERS

                 COLUMN         PRIORITY          set default value 0

QRTZ_FIRED_TRIGGERS

                 COLUMN         PRIORITY          set default value 0

No comments:

Post a Comment

Create MongoDB service in Windows OS

1) Open Command Prompt 2) Create directory for Database and Logs                    mkdir c:\data\db                     mkdir c:\...