[Spacewalk-list] SummaryPopulation failing after 1.5 -> 1.7 upgrade

[Daniel Jabbour]

Hey All-

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?

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

com.redhat.rhn.common.db.WrappedSQLException: ORA-01878: specified field not found in datetime or interval

        at com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:82)
        at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42)
        at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:141)
        at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:453)
        at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:430)
        at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:336)
        at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:341)
        at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:281)
        at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:126)
        at com.redhat.rhn.taskomatic.task.SummaryPopulation.orgsWithRecentActions(SummaryPopulation.java:100)
        at com.redhat.rhn.taskomatic.task.SummaryPopulation.execute(SummaryPopulation.java:67)
        at com.redhat.rhn.taskomatic.task.RhnJavaJob.execute(RhnJavaJob.java:80)
        at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:169)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:214)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
Caused by: java.sql.SQLDataException: ORA-01878: specified field not found in datetime or interval

        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661)
        at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:542)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:362)
        at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138)
        ... 12 more
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

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

--
Daniel Jabbour
Senior Agnostic Algorithmatist
Inigral, Inc. | The Social Web For Education
drj at inigral.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120629/0873b18d/attachment.htm>