Agile 9.3.2: Agile9_check.sql Reports SUBS_MAP_MDO_ID Index Missing (Doc ID 1519979.1)

Last updated on FEBRUARY 08, 2013

Applies to:

Oracle Agile PLM Framework - Version 9.3.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 9.3.2 version, get errors while running agile9_check.sql

EXPECTED BEHAVIOR
-----------------------
Expect no error in agile9_check log

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute agile9_check.sql
2. Get errors
Validation is in process and errors will be reported if any.

ERROR: Missing or INVALID index (columns) SUBS_MAP_MDO_ID on table SUBSTANCE_MAP.
ERROR: Missing or INVALID index (columns) SUBS_MAP_PARENT_ID on table SUBSTANCE_MAP.
ERROR: Missing or INVALID index (columns) ROLLUP_COMPOSITION_IDX on table ROLLUP_COMPOSITION.
ERROR: Missing or INVALID index (columns) SPECIFICATION_SUBSTANCES_IDX on table SPECIFICATION_SUBSTANCES.
ERROR: Missing or INVALID index (columns) SUBS_MAP_ID on table SUBSTANCE_MAP.
ERROR: Missing or INVALID index (columns) SUBS_MAP_OBJID_OBJCLASS on table SUBSTANCE_MAP.
ERROR: Missing or INVALID index (columns) SUBS_MAP_COMP_ID on table SUBSTANCE_MAP.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms