PH48063: Using 'view output logs' in a generic process in UrbanCode Deploy, it takes a long time to get the result

APAR status

• Closed as program error.

Error description

• When you 'view output logs' in a generic process, it takes a
  long time to get the output.  Previous releases of UrbanCode
  Deploy produced the output quickly.
  

Local fix

• These indexes should be added:
  create index rt_apr_xaprvl on
  rt_app_process_request(external_approval_trace_id);
  create index rt_cpr_xaprvl on
  rt_comp_process_request(external_approval_trace_id);
  
  Important note: Later when upgrading to IBM UrbanCode Deploy
  7.3.0.0 or newer the two manually added indexes should be
  removed in order for the upgrade script to recreate the same two
  indexes successfully.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Deploy Server Web UI users                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * As soon as the user do click 'view output logs' in a generic *
  * process, it takes 30 seconds to get the output which means a *
  * significant delay due to other logs are available            *
  * instantaneously. The issue came to the scene after upgrade   *
  * from 7.0.3.2 to 7.2.1.2. The external approval feature       *
  * changed the security model with respect to generic process,  *
  * it involved joining new columns in the backend. These        *
  * columns should be indexed because they are logically foreign *
  * keys, but this was not done. The 7.0.3.2 version of the      *
  * product did not execute these queries, which is the reason   *
  * of the performance degraded when user accessed the generic   *
  * process logs after upgrade.                                  *
  *                                                              *
  * These indexes should be added:                               *
  * create index rt_apr_xaprvl on                                *
  * rt_app_process_request(external_approval_trace_id);          *
  * create index rt_cpr_xaprvl on                                *
  * rt_comp_process_request(external_approval_trace_id);         *
  * Because the column is nullable, these cannot be unique       *
  * indexes because that causes problems in some databases.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Fix is provided in IBM UrbanCode Deploy 7.3.0.0              *
  ****************************************************************
  

Problem conclusion

• Fix is provided in IBM UrbanCode Deploy 7.3.0.0
  

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

  UC DEPLOY

• Fixed component ID

  5725M5400

Applicable component levels