<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hey All-<div><br></div><div>I recently upgraded from Spacewalk 1.5 to Spacewalk 1.7. Everything seems to have gone okay, including the schema upgrade. Yet I'm getting some SQL errors when the SummaryPopulation task runs at night. It looks like this is something internal to the Java code in Spacewalk. Any recommendations?</div><div><br></div><div><div><font class="Apple-style-span" face="'Courier New'">012-06-28 23:00:03,775 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.SummaryPopulation - ORA-01878: specified field not found in datetime or interval</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">com.redhat.rhn.common.db.WrappedSQLException: ORA-01878: specified field not found in datetime or interval</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:82)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:141)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:453)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:430)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:336)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:341)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:281)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:126)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.taskomatic.task.SummaryPopulation.orgsWithRecentActions(SummaryPopulation.java:100)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.taskomatic.task.SummaryPopulation.execute(SummaryPopulation.java:67)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.taskomatic.task.RhnJavaJob.execute(RhnJavaJob.java:80)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:169)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at org.quartz.core.JobRunShell.run(JobRunShell.java:214)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)</font></div><div><font class="Apple-style-span" face="'Courier New'">Caused by: java.sql.SQLDataException: ORA-01878: specified field not found in datetime or interval</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'"> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:542)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:362)</font></div><div><font class="Apple-style-span" face="'Courier New'"> at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138)</font></div><div><font class="Apple-style-span" face="'Courier New'"> ... 12 more</font></div><div><font class="Apple-style-span" face="'Courier New'">2012-06-28 23:00:03,778 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.SummaryPopulation - com.redhat.rhn.common.db.WrappedSQLException: ORA-01878: specified field not found in datetime or interval</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">2012-06-28 23:00:03,778 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.SummaryPopulation - com.redhat.rhn.common.db.WrappedSQLException: ORA-01878: specified field not found in datetime or interval</font></div></div><div><br><div> <div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>--</div><div><div>Daniel Jabbour</div><div>Senior Agnostic Algorithmatist</div><div>Inigral, Inc. | The Social Web For Education</div><div><a href="mailto:drj@inigral.com">drj@inigral.com</a></div></div></div> </div> <br></div></body></html>