Nilesh Patil's blog

http://forums.pentaho.com/showthread.php?26490-Getting-Help  Understanding that those of us at Pentaho are volunteering our time to help users get started with the platform, if you reach a point where reading the provided documentation and looking through the forums can't solve your problem, here's a quick best-practices way to get the most out of the forum. Start Here: http://community.pentaho.org/faq/forum_assistance.php Post information about your environment, operating system, whether you're using the Preconfigured Install (PCI), what application server you're running in, what jdbc driver you're using, what version of the platform you have, what version of the client tool you're running, etc. If you're using Tomcat for example, we need to know the exact version of Tomcat you're running. We also need to know the JDK version. Without all this information, we just have to turn around and ask you what you're running. This wastes...

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

In case you get this error Failed to obtain DB connection from data source ‘myDS’: java.sql.SQLException: Could not retrieve datasource via JNDI url ‘java:comp/env/jdbc/Quartz’ Solution :-  delete the following file toncat/conf/Catalina/localhost/pentaho.xml and try again.