[Spacewalk-list] Error displaying package details

[Tomas Lestach]

> > Caused by: java.sql.SQLSyntaxErrorException: ORA-00904:
> > "PUBLISHEDE1_"."ERRATA_FROM": invalid identifier
> 
> What does
> # echo "desc rhnErrata" | spacewalk-sql -i return?
> 
> 
> The service has been restarted several times. The spacewalk-sql -i
> command returns the following:
> 
> SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 22 15:55:48 2013
> 
> Copyright (c) 1982, 2011, Oracle.  All rights reserved.
> 
> 
> Connected to:
> Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
> 
> SQL>  Name                                         Null?    Type
>  ----------------------------------------- --------
>  ----------------------------
>  ID                                        NOT NULL NUMBER
>  ADVISORY                                  NOT NULL VARCHAR2(37)
>  ADVISORY_TYPE                             NOT NULL VARCHAR2(32)
>  ADVISORY_NAME                             NOT NULL VARCHAR2(32)
>  ADVISORY_REL                              NOT NULL NUMBER
>  PRODUCT                                   NOT NULL VARCHAR2(64)
>  DESCRIPTION                                        VARCHAR2(4000)
>  SYNOPSIS                                  NOT NULL VARCHAR2(4000)
>  TOPIC                                              VARCHAR2(4000)
>  SOLUTION                                  NOT NULL VARCHAR2(4000)
>  ISSUE_DATE                                NOT NULL TIMESTAMP(6) WITH
>  LOCAL TIME
>                                                      ZONE
>  UPDATE_DATE                               NOT NULL TIMESTAMP(6) WITH
>  LOCAL TIME
>                                                      ZONE
>  REFERS_TO                                          VARCHAR2(4000)
>  NOTES                                              VARCHAR2(4000)
>  ORG_ID                                             NUMBER
>  LOCALLY_MODIFIED                                   CHAR(1)
>  CREATED                                   NOT NULL TIMESTAMP(6) WITH
>  LOCAL TIME
>                                                      ZONE
>  MODIFIED                                  NOT NULL TIMESTAMP(6) WITH
>  LOCAL TIME
>                                                      ZONE
>  LAST_MODIFIED                             NOT NULL TIMESTAMP(6) WITH
>  LOCAL TIME
>                                                      ZONE
>  SEVERITY_ID                                        NUMBER
> 
> SQL> Disconnected from Oracle Database 11g Release 11.2.0.1.0 - 64bit
> Production
> 
> -Sajesh Singh-

Hello Sajesh,

it seems you're missing 'ERRATA_FROM' column in the rhnErrata table.
The java stack expects the column to be there, but it's missing.

The errata_from column was added to schema back in 2010 and was included
already in Spacewalk 1.4.

I'm not sure, if you upgraded from a Spacewalk older than 1.4 and the upgrade
failed, or how you ended up in this state.
Your database schema definitely does not correspond to Spacewalk 2.0.

Did you follow the upgrade instructions?
https://fedorahosted.org/spacewalk/wiki/HowToUpgrade

What everything went wrong?

Regards,
--
Tomas Lestach
Red Hat Satellite Engineering, Red Hat