PH46670: CONSTRAINT VIOLATIONS DURING DEPLOYMENT HISTORY CLEANUP

APAR status

• Closed as program error.

Error description

• Error 1:
  
  Consecutive environment cleanup requests fail with:
  ERROR AsynEventService-0
  com.urbancode.air.services.event.EventService - Exception in
  event listener; running next listener:
  org.hibernate.exception.ConstraintViolationException: could not
  execute statement javax.persistence.PersistenceException:
  org.hibernate.exception.ConstraintViolationException: could not
  execute statement
  Caused by: org.hibernate.exception.ConstraintViolationException:
  could not execute statement
  Caused by:
  org.apache.derby.shared.common.error.DerbySQLIntegrityConstraint
  ViolationException: DELETE on table 'DS_ENVIRONMENT' caused a
  violation of foreign key constraint 'DS_EVC_TO_ENVIRONMENT' for
  key (aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee).  The statement has
  been rolled back.
  ========================================================
  Error 2:
  
  Caused by: java.sql.SQLIntegrityConstraintViolationException:
  (conn=18004) Cannot delete or update a parent row: a foreign key
  constraint fails (`ucd`.`ds_version`, CONSTRAINT
  `ds_package_2_cmp` FOREIGN KEY (`component_id`) REFERENCES
  `ds_component` (`id`))
      at
  org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.creat
  eException(ExceptionFactory.java:70)
      at
  org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.creat
  e(ExceptionFactory.java:158)
      at
  org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(Maria
  DbStatement.java:266)
      at
  org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(Cli
  entSidePreparedStatement.java:229)
      at
  org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSideP
  reparedStatement.java:149)
      at
  org.mariadb.jdbc.ClientSidePreparedStatement.executeUpdate(Clien
  tSidePreparedStatement.java:181)
      at
  com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(Prox
  yPreparedStatement.java:61)
      at
  com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdat
  e(HikariProxyPreparedStatement.java)
      at
  org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUp
  date(ResultSetReturnImpl.java:197)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * UrbanCode Web UI Users                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Constraint violations during deployment history cleanup      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Fix is provided in IBM UrbanCode Deploy 7.3.2.1              *
  ****************************************************************
  

Problem conclusion

• Fix is provided in IBM UrbanCode Deploy 7.3.2.1
  

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