[Spacewalk-list] Database Schema Update Issue - 1.2 to 1.3 Upgrade

[Speagle, Andy]

Hi all...

I'm having an issue with the upgrade from v1.2 to v1.3 ... when I run the spacewalk-schema-upgrade script... it just simply returns:

No existing schema version info found in rhnVersionInfo.

I can make a simple connection via sqlplus.. so I know the database is running and available.  Looking at the schema upgrade script... I find the query that it runs to check the schema version:

select rhnPackageName.name || '-' || (PE.evr).version || '-' || (PE.evr).release
        from rhnVersionInfo, rhnPackageName, rhnPackageEVR PE
        where rhnVersionInfo.label = 'schema'
        and rhnVersionInfo.name_id = rhnPackageName.id
        and rhnVersionInfo.evr_id = PE.id;

And when I run that manually via sqlplus .. I get no rows returned.

Has anyone seen this issue?

Andy Speagle
System & Storage Administrator
UCATS - Wichita State University

P: 316.978.3869
C: 316.617.2431

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110413/371600d7/attachment.htm>