[Spacewalk-list] question about upgrade 0.4 - 0.5 : Oracle schema upgrade failure

[Milan Zazrivec]

On Tuesday 12 May 2009 13:45:15 Michiel van Es wrote:
> The upgrade logfile from 0.3-0.4 (a couple of months old):
[...]
> SQL> alter TABLE rhnPackage MODIFY (compat number(1));
> alter TABLE rhnPackage MODIFY (compat number(1))
>                                *
> ERROR at line 1:
> ORA-01440: column to be modified must be empty to decrease precision or
> scale

Please look into 20090119-165316-script.sql somewhere at the very
end of the file, there should be an insert statement like this:

insert into rhnVersionInfo
        ( label, name_id, evr_id, created, modified )
...
commit;

Connect to your spacewalk database via sqlplus and run this whole insert
+ commit statement manually.

Given that you have manually updated rhnPackage table, this is one final
step you have to do to make it look like a "successful" upgrade :-)

-Milan