IBM Support

PH36592: DRAGGING AND DROPPING MULTIPLE COMPONENTS ONTO AN AGENT IN ENV BASE RESOURCES CAN FAIL WITH EXCEPTION

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

  • intermittently in the environment base resources page, dragging
    and dropping components from the sidebar menu onto an agent or
    resource hangs in the UI.
    
    Shortly there after the action fails, resulting in an exception
    being thrown, with the error "could not extract ResultSet"
    
    Some of the components may be successfully added.
    
    ERROR https-jsse-nio-0.0.0.0-8443-exec-5
    com.urbancode.ds.web.rest.mappers.RuntimeExceptionMapper - could
    not extract ResultSet
    org.hibernate.exception.LockAcquisitionException: could not
    extract ResultSet
            at
    org.hibernate.exception.internal.SQLExceptionTypeDelegate.conver
    t(SQLExceptionTypeDelegate.java:75)
            at
    org.hibernate.exception.internal.StandardSQLExceptionConverter.c
    onvert(StandardSQLExceptionConverter.java:42)
            at
    org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExce
    ptionHelper.java:113)
            at
    org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExce
    ptionHelper.java:99)
            at
    org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(R
    esultSetReturnImpl.java:67)
            at
    org.hibernate.loader.Loader.getResultSet(Loader.java:2341)
            at
    org.hibernate.loader.Loader.executeQueryStatement(Loader.java:20
    94)
            at
    org.hibernate.loader.Loader.executeQueryStatement(Loader.java:20
    56)
            at org.hibernate.loader.Loader.doQuery(Loader.java:953)
            at
    org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollectio
    ns(Loader.java:350)
            at org.hibernate.loader.Loader.doList(Loader.java:2887)
            at org.hibernate.loader.Loader.doList(Loader.java:2869)
            at
    org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:270
    1)
            at org.hibernate.loader.Loader.list(Loader.java:2696)
            at
    org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader
    .java:109)
            at
    org.hibernate.internal.SessionImpl.list(SessionImpl.java:1878)
            at
    org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:370)
            at
    com.urbancode.security.persistence.SecurityResourceFactory.getRe
    sourceTeamMappings(SecurityResourceFactory.java:451)
            at
    com.urbancode.ds.subsys.resource.domain.Resource.getParentTeamMa
    ppings(Resource.java:1654)
            at
    com.urbancode.ds.subsys.resource.domain.Resource.applyInheritanc
    e(Resource.java:1494)
            at
    com.urbancode.ds.web.cli.rest.deploy.ResourceAPIHelper.createRes
    ourceFromJSON(ResourceAPIHelper.java:1741)
            at
    com.urbancode.ds.web.cli.rest.deploy.ResourceAPIHelper.saveResou
    rce(ResourceAPIHelper.java:1493)
            at
    com.urbancode.ds.web.rest.resource.ResourceResource.saveResource
    (ResourceResource.java:314)
            at
    com.urbancode.ds.web.rest.resource.ResourceResource_$$_jvst5d1_5
    ._d52saveResource(ResourceResource_$$_jvst5d1_5.java)
    

Local fix

  • Add components individually
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Drag and drop of components in an environment                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Intermittently in the environment base resources page,       *
    * dragging and dropping components from the sidebar menu onto  *
    * an agent or resource hangs in the UI.                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • Fixed in 7.2.1.0
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH36592

  • Reported component name

    UC DEPLOY

  • Reported component ID

    5725M5400

  • Reported release

    711

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-04-22

  • Closed date

    2021-11-16

  • Last modified date

    2021-11-16

  • 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

[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS4GSP","label":"IBM UrbanCode Deploy"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"711"}]

Document Information

Modified date:
17 November 2021