Step 5. Verifying the installation - HxGN EAM - 12.0.1 - Installation & Upgrade - Hexagon

HxGN EAM Oracle Database Installation & Upgrade

Language
English
Product
HxGN EAM
Search by Category
Installation & Upgrade
HxGN EAM Version
12.0.1

Open SQL Plus and execute the following scripts to verify the installation:

Script

Function

71testdb.sql

Shows objects that are missing compared to a default and complete installation. The information reported by this script is also contained in the end of the 80ed117i.sql file, which runs the following queries:

PROMPT Base HxGN EAM columns missing in the current HxGN EAM build:
SELECT r.utc_tablename, r.utc_columnname, r.utc_datatype
FROM r5usertabcolumns r
WHERE r.utc_database = 'ORACLE' AND NOT EXISTS (
SELECT NULL FROM user_tab_columns u
WHERE u.table_name = r.utc_tablename
AND u.column_name = r.utc_columnname )
/

PROMPT Base HxGN EAM Database objects missing in the current HxGN EAM build:
SELECT r.uob_objectname, r.uob_objecttype
FROM r5userobjects r
WHERE r.uob_database = 'ORACLE'
AND r.uob_objecttype <> 'CONSTRAINT'
AND NOT EXISTS (
SELECT NULL FROM user_objects u
WHERE u.object_name = r.uob_objectname
AND u.object_type = r.uob_objecttype )
/

PROMPT Base HxGN EAM Database constraints missing in the current HxGN EAM build:
SELECT r.uob_objectname, r.uob_objecttype
FROM r5userobjects r
WHERE r.uob_database = 'ORACLE'
AND r.uob_objecttype = 'CONSTRAINT'
AND NOT EXISTS (
SELECT NULL FROM user_constraints c
WHERE c.constraint_name = r.uob_objectname )
/

After running this script, compare the information generated with the information contained in the following tables to verify the installation: R5USERTABCOLUMNS and R5USEROBJECTS.

All database objects should be valid. Run the 7icomp.sql script to compile and list remaining invalid objects.