JR57144: YOU CAN'T CREATE A TRACK BECAUSE UNIQUE INDEX VIOLATIONS OCCUR FOR THE LSW_PO_DEPENDENCY TABLE

bpm.8570.cf2017.03.delta.repository
Downloading IBM Business Process Manager V8.5.7 Cumulative Fix 2017.03

APAR status

• Closed as program error.

Error description

• When you try to create a track, you see unique index violations
  for the LSW_PO_DEPENDENCY table that prevent you from creating
  the track. You might a stack trace that is similar to the
  following example:
  
  CWLLG2229E: An exception occurred in an EJB call.  Error:
  PreparedStatementCallback; SQL [
              INSERT INTO LSW_PO_DEPENDENCY (
                BRANCH_ID,
                START_SEQ_NUM,
                SOURCE_TYPE,
                SOURCE_ID,
               SOURCE_LOCATION,
                TARGET_REF,
                END_SEQ_NUM)
                VALUES (?,?,?,?,?,?,?)
             ]; ORA-00001: unique constraint
  (CRSTNDEVPS_PC.LSWC_PO_DEPENDENCY) violated
   ; nested exception is
  java.sql.SQLIntegrityConstraintViolationException: ORA-00001:
  unique constraint (CRSTNDEVPS_PC.LSWC_PO_DEPENDENCY) violated
  
  
  org.springframework.dao.DataIntegrityViolationException:
  PreparedStatementCallback; SQL [
                INSERT INTO LSW_PO_DEPENDENCY (
                 BRANCH_ID,
                START_SEQ_NUM,
                SOURCE_TYPE,
                SOURCE_ID,
                SOURCE_LOCATION,
                 TARGET_REF,
                END_SEQ_NUM)
                VALUES (?,?,?,?,?,?,?)
              ]; ORA-00001: unique constraint
  (CRSTNDEVPS_PC.LSWC_PO_DEPENDENCY) violated
   ; nested exception is
  java.sql.SQLIntegrityConstraintViolationException: ORA-00001:
  unique constraint (CRSTNDEVPS_PC.LSWC_PO_DEPENDENCY) violated
  
    at
  org.springframework.jdbc.support.SQLExceptionSubclassTranslator.
  translate(SQLExceptionSubclassTranslator.java:69)
   at
  org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTransla
  tor.translate(SQLErrorCodeSQLExceptionTranslator.java:237)
   at
  org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.
  java:607)
    at
  org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.
  java:619)
   at
  com.lombardisoftware.server.ejb.persistence.versioning.MutableSn
  apshotContextImpl.writeAllDependencies(MutableSnapshotContextImp
  l.java:928)
  . . .
  
  PRODUCTS AFFECTED
  IBM Business Process Manager (BPM) Advanced
  IBM BPM Standard
  IBM BPM Express
  

Local fix

Problem summary

• No additional information is available.
  

Problem conclusion

• A fix that prevents duplicate dependency records from being
  created and logs a warning message is planned for inclusion in
  IBM BPM V8.5.7 cumulative fix 2017.03.
  

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

  BPM ADVANCED

• Fixed component ID

  5725C9400

Applicable component levels