[Spacewalk-list] Error displaying package details

[Sajesh Singh]

> 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-