IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR57144

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-12-08

  • Closed date

    2017-03-01

  • Last modified date

    2017-03-01

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
04 September 2023