SYMPTOM:
Whenever upgrading to Strategy 9.x or above, the user receives the error below
Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. ORA-00972: identifier is too long
CAUSE:
This issue is caused due to an Oracle limit of 30 characters per identifier. The identifier abcdefgIX_USRACCT_UPPER_LDAP_DN exceeds this limit of 30 characters.
ACTION:
In order to assure no create index statements exceed this Oracle limit of 30 characters make sure the schema name does not exceed 6 characters long. (In this instance the schema name abcdefg is 7 characters causing the identifier abcdefgIX_USRACCT_UPPER_LDAP_DN to be 31 characters long)
