PI90024: UCR PLUGIN INTEGRATION WITH UCD FAILS ON SNAPSHOT IMPORT WITH DBCONSTRAINTVIOLATION EXCEPTION ON UR_VERSION DB TABLE

APAR status

• Closed as program error.

Error description

• Steps to reproduce
  
  1. Create  a snapshot in UCD
  2. Run the plugin integration of UCR with UCD (full sync)
  3. Delete the snapshot created  on step 1
  4. Rename  another snapshot using the same name with the deleted
  one
  5. Run the integration
  
  The integration will fail on snapshot import with the following
  error
  
  =2017-11-08 14:11:55,208 ERROR PUT-versions-sync
  com.urbancode.urelease.web.filter.HibernateSessionRequestFilter
  - Exception during transaction commit -- response to client may
  be incorrect!
  org.hibernate.exception.ConstraintViolationException: could not
  update:
  [com.urbancode.urelease.domain.application.Version#3ada46b1-4c47
  -4185-a8f2-071cb1e4236a]
  	at
  org.hibernate.exception.SQLStateConverter.convert(SQLStateConver
  ter.java:96)
  	at
  org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptio
  nHelper.java:66)
  	....
  	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
  	at
  org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383
  )
  	at
  org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction
  .java:133)
  	at
  com.urbancode.persistence.hibernate.TxManager.doFinalCommit(TxMa
  nager.java:542)
  	at
  com.urbancode.persistence.hibernate.TxManager.commit(TxManager.j
  ava:522)
  	at
  com.urbancode.urelease.web.filter.HibernateSessionRequestFilter.
  doFilter(HibernateSessionRequestFilter.java:50)
  	....
  	Caused by: java.sql.SQLIntegrityConstraintViolationException:
  The statement was aborted because it would have caused a
  duplicate key value in a unique or primary key constraint or
  unique index identified by 'UR_VERSION_NAME_UQ' defined on
  'UR_VERSION'.
  	at
  org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException
  (Unknown Source)
  	at
  org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
  Source)
  	at
  org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLExce
  ption(Unknown Source)
  	....
  

Local fix

• Disable the Full Sync option and run the integration again
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When importing a snapshot that had the same name of a        *
  * previously deleted snapshot, it would map to the deleted     *
  * snapshot in UCR creating a duplicate entry violation         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Ensure snapshots that have the name of a previously deleted
  snapshot are properly ghosted.
  

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 RELEASE

• Fixed component ID

  5725M5500

Applicable component levels