[DATA-3] ACT Metadata index names too long for Oracle

[jklann]

During the load data task for newinstall for act, the index creation on the tables is failing for oracle because the index names are too long. Oracle character names are limited to 30. Below is a sample of the error, it continues for many other index names below that.

  [sql] Executing resource: /docker-entrypoint.d/workspace/master/NewInstall/Metadata/act/scripts/oracle/zz_create_i2b2metadata_index.sql
  [sql] Failed to execute:
  [sql] CREATE INDEX META_FULLNAME_ACT_MED_ALPHA_IDX ON ACT_MED_ALPHA_V2_092818(C_FULLNAME)
  [sql] java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
  [sql] Failed to execute:
  [sql] CREATE INDEX META_APPLIED_PATH_ACT_MED_ALPHA_IDX ON ACT_MED_ALPHA_V2_092818(M_APPLIED_PATH)
  [sql] java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
  [sql] Failed to execute:
  [sql] CREATE INDEX META_EXCLUSION_ACT_MED_ALPHA_IDX ON ACT_MED_ALPHA_V2_092818(M_EXCLUSION_CD)
  [sql] java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
  [sql] Failed to execute:
  [sql] CREATE INDEX META_APPLIED_PATH_ACT_MED_VA_IDX ON ACT_MED_VA_V2_092818(M_APPLIED_PATH)
  [sql] java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
  [sql] Failed to execute:
  [sql] CREATE INDEX META_FULLNAME_ACT_LOINC_LAB_IDX ON ACT_LOINC_LAB_2018AA(C_FULLNAME)
  [sql] java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
  [sql] Failed to execute:
  [sql] CREATE INDEX META_APPLIED_PATH_ACT_LOINC_LAB_IDX ON ACT_LOINC_LAB_2018AA(M_APPLIED_PATH)
  [sql] java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long

.
.
.

---

Imported from Jira

• Key: DATA-3
• ID: 10782
• Type: Bug
• Priority: Minor
• Status: To Do
• Reporter: Former user
• Created: 09/Jan/20 12:04 PM
• Updated: 09/Jan/20 12:04 PM
• Project: DATA—i2b2 Data
• Environment: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production