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
[email protected]
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
