IBM Support

PH20028: IMPORTING COMPONENT TEMPLATE WITH TAGS AS AN UPGRADE FAILS DUE TO A CONSTRAINT VIOLATION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When importing a component template that has tags, the import
    process fails due to a constraint violation. This happens
    because the component already has tags and the component
    template upgrade imports the existing tags as new tags.
    
    2019-12-05 14:02:27,265 EST WARN http-nio-0.0.0.0-8080-exec-7
    org.hibernate.util.JDBCExceptionReporter - SQL Error: -1,
    SQLState: 23505
    2019-12-05 14:02:27,265 EST ERROR http-nio-0.0.0.0-8080-exec-7
    org.hibernate.util.JDBCExceptionReporter - 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
    'VC_PRM_GKVID' defined on 'VC_PERSISTENT_RECORD_METADATA'.
    2019-12-05 14:02:27,309 EST ERROR http-nio-0.0.0.0-8080-exec-7
    com.urbancode.commons.web.filter.ExceptionHandlingFilter -
    org.hibernate.exception.ConstraintViolationException: could not
    insert: [com.urbancode.air.vc.metadata.GenericRecordMetadata]
    org.hibernate.exception.ConstraintViolationException: could not
    insert: [com.urbancode.air.vc.metadata.GenericRecordMetadata]
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All end users on all supported browsers.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When importing a component template that has tags, the       *
    * import                                                       *
    * process fails due to a constraint violation. This happens    *
    * because the component already has tags and the component     *
    * template upgrade imports the existing tags as new tags.      *
    *                                                              *
    * 2019-12-05 14:02:27,265 EST WARN                             *
    * http-nio-0.0.0.0-8080-exec-7                                 *
    * org.hibernate.util.JDBCExceptionReporter - SQL Error: -1,    *
    * SQLState: 23505                                              *
    * 2019-12-05 14:02:27,265 EST ERROR                            *
    * http-nio-0.0.0.0-8080-exec-7                                 *
    * org.hibernate.util.JDBCExceptionReporter - 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                                                           *
    * 'VC_PRM_GKVID' defined on 'VC_PERSISTENT_RECORD_METADATA'.   *
    * 2019-12-05 14:02:27,309 EST ERROR                            *
    * http-nio-0.0.0.0-8080-exec-7                                 *
    * com.urbancode.commons.web.filter.ExceptionHandlingFilter -   *
    * org.hibernate.exception.ConstraintViolationException: could  *
    * not                                                          *
    * insert:                                                      *
    * [com.urbancode.air.vc.metadata.GenericRecordMetadata]        *
    * org.hibernate.exception.ConstraintViolationException: could  *
    * not                                                          *
    * insert:                                                      *
    * [com.urbancode.air.vc.metadata.GenericRecordMetadata]        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Fixed in version 7.0.5.2                                     *
    ****************************************************************
    

Problem conclusion

  • Fix is provided in IBM UrbanCode Deploy 7.0.5.2
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH20028

  • Reported component name

    UC DEPLOY

  • Reported component ID

    5725M5400

  • Reported release

    704

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-12-06

  • Closed date

    2020-03-11

  • Last modified date

    2020-03-11

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS4GSP","label":"IBM UrbanCode Deploy"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"704","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
11 March 2020