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

[Daniel Jabbour]

Jan, Thank you for your reply!

We are currently using CentOS 6.2. It looks like we are using oracle 10.2. The following is the result of rpm -qa |grep oracle (let me know if there's a better way to get to the version of the driver?):

oracle-instantclient-selinux-11.2.0.1-1.el6.noarch
spacewalk-backend-sql-oracle-1.7.38-1.el6.noarch
oracle-xe-univ-10.2.0.1-1.0.i386
oracle-instantclient11.2-basic-11.2.0.2.0-1.i386
quartz-oracle-1.8.1-3.el6.noarch
spacewalk-java-oracle-1.7.54-1.el6.noarch
spacewalk-oracle-1.7.3-1.el6.noarch
oracle-nofcontext-selinux-0.1.23.32-1.el6.noarch
oracle-instantclient11.2-sqlplus-11.2.0.2.0-1.i386
oracle-instantclient-sqlplus-selinux-11.2.0.1-1.el6.noarch
oracle-lib-compat-11.2.0.6-1.el6.i686

Regards,
Daniel

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

On Jul 3, 2012, at 5:46 AM, Jan Pazdziora wrote:

> On Fri, Jun 29, 2012 at 02:13:21PM -0700, Daniel Jabbour wrote:
>> 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
> 
> What OS version and what version of Oracle JDBC driver do you use?
> 
> -- 
> Jan Pazdziora
> Principal Software Engineer, Satellite Engineering, Red Hat
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list