This kind of error typically indicates there is some database corruption. Typically I have seen this indicate that even though the definition for an attribute came across in the upgrade, the table or column did not get actually get created. If you run this SQL statement it will give you an idea if you have this problem:
select * from METAATTRIBUTES where ATTRNAME not in (select name from syscolumns)
This will show you attributes that do not exist. If you have some, depending on what they are, you may want to just delete them from the database. Then rerun coredbutil to make sure all the default attributes still exist.
What does "depending on what they are" mean? TCP.ADDRESS sounds kinda important, but if something is corrupt, is there a better way to fix things, or is the quickest/simplest/fastest to shut down inventory, delete the values and let coredbutil recreate them?
I forwarded this to the Oracle DBA, and got this response:
I cannot run the SQL as it stands. They need to rewrite it with the schema owner as LANDESK. I have attempted to do so and I get the following errors.
select * from LANDESK.METAATTRIBUTES where ATTRNAME not in
(select name from LANDESK.syscolumns);
(select name from LANDESK.syscolumns)
ERROR at line 2:
ORA-00942: table or view does not exist
Any thoughts on how to ask this in Oracle-speak?
I've also opened an "official" case on this...