PM59500: Build Forge bfschema -R on Oracle does not remove BF_LOGS index under primary key PK_BF_STEPLOG

APAR status

• Closed as program error.

Error description

• db do failed: ORA-00955: name is already used by an existing
  object (DBD ERROR: OCIStmtExecute) [for Statement 'alter table
  bf_logs add constraint PK_BF_STEPLOG PRIMARY KEY (bf_result_id,
  bf_seq)'] at (eval 73) line 1.
  
  Workaround
  
  Run the queries used by the bfschema -R command manually with
  the updated query.
  
  alter table bf_logs drop constraint PK_BF_STEPLOG including
  indexes;
  
  alter table bf_logs modify bf_result_id VARCHAR2(64) NOT NULL
  drop index IDX_BF_LOGS
  alter table bf_logs add constraint PK_BF_STEPLOG PRIMARY KEY
  (bf_result_id, bf_seq)
  create unique index idx_bf_logs on bf_logs (bf_id)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Oracle's syntax for deleting indexes has changed over time,
  so the changes were added to the schema tool.
  

Problem conclusion

• Fixed in BuildForge 7.1.3.3 release
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  BUILD FORGE EE

• Fixed component ID

  5724S2702

Applicable component levels

• R712 PSN

     UP