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