> 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-
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
