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