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

Comments

Popular posts from this blog

Changing the Java VM Memory Limits in Pentaho BI

error in pentaho 5.0.1 - authentication via url parameters for iframe

CAS with Pentaho Community Edition