IBM Support

PH16395: When running a deployment, UCR errors and the UCD application process history shows an error: Cannot insert duplicate key

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

  • Error : Application process cannot start : Cannot insert
    duplicate key row in object 'dbo.inv_desired_inventory' with
    unique index 'inv_unique_desired_entry
    
    Steps to reproduce:
    
    1) On UCD , Create a deployment which includes creating
    component,application,environment,snapshot having versions and
    resource tree
    2) On UCR, Goto Integrations. Goto plugin tab, Add IBM UrbanCode
    Deploy Plugin .Goto Integrations, Add New -> Add UCD server
    which is up and running by Integration Type : IBM Urban Code
    Deploy plugin
    3) After configuring , Do Run Integration
    4) From UCR, Navigate to Applications , Add a team for
    Application
    5) Navigate to environments, Goto Release Environments, Drag and
    drop environment to Corresponding release Environment
    6) Navigate to Releases and Deployments ,Navigate to Deployment
    plans tab , create a deployment plan and select corresponding
    release
    7) Click on plan , Create segment ,Execution pattern parallel.
    8) Create one more segment, execution pattern parallel for it as
    well.
    9) Navigate to Deployments,Click on execution date link , Click
    on Deployment execution -> Start deployment
    10) One of the 2 segments exection would error out .
    11) On UCD, Application History -> Application process cannot
    start : Cannot insert duplicate key row in object
    'dbo.inv_desired_inventory' with unique index
    'inv_unique_desired_entry
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All end users on all supported browsers.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Error : Application process cannot start : Cannot insert     *
    * duplicate key row in object 'dbo.inv_desired_inventory' with *
    * unique index 'inv_unique_desired_entry                       *
    *                                                              *
    * Steps to reproduce:                                          *
    *                                                              *
    * 1) On UCD , Create a deployment which includes creating      *
    * component,application,environment,snapshot having versions   *
    * and                                                          *
    * resource tree                                                *
    * 2) On UCR, Goto Integrations. Goto plugin tab, Add IBM       *
    * UrbanCode                                                    *
    * Deploy Plugin .Goto Integrations, Add New -> Add UCD server  *
    * which is up and running by Integration Type : IBM Urban Code *
    * Deploy plugin                                                *
    * 3) After configuring , Do Run Integration                    *
    * 4) From UCR, Navigate to Applications , Add a team for       *
    * Application                                                  *
    * 5) Navigate to environments, Goto Release Environments, Drag *
    * and                                                          *
    * drop environment to Corresponding release Environment        *
    * 6) Navigate to Releases and Deployments ,Navigate to         *
    * Deployment                                                   *
    * plans tab , create a deployment plan and select              *
    * corresponding                                                *
    * release                                                      *
    * 7) Click on plan , Create segment ,Execution pattern         *
    * parallel.                                                    *
    * 8) Create one more segment, execution pattern parallel for   *
    * it as                                                        *
    * well.                                                        *
    * 9) Navigate to Deployments,Click on execution date link ,    *
    * Click                                                        *
    * on Deployment execution -> Start deployment                  *
    * 10) One of the 2 segments exection would error out .         *
    * 11) On UCD, Application History -> Application process       *
    * cannot                                                       *
    * start : Cannot insert duplicate key row in object            *
    * 'dbo.inv_desired_inventory' with unique index                *
    * 'inv_unique_desired_entry                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Fixed in version 7.0.5.0                                     *
    ****************************************************************
    

Problem conclusion

  • Fix is provided in IBM UrbanCode Deploy 7.0.5.0
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH16395

  • Reported component name

    UC DEPLOY

  • Reported component ID

    5725M5400

  • Reported release

    625

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-09-04

  • Closed date

    2020-01-14

  • Last modified date

    2020-01-14

  • 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":"625","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
14 January 2020