APAR status
Closed as program error.
Error description
New installations of UCD 7.0.4.0 on mysql or mariadb will create columns of type BLOB instead of LONGBLOB. This causes BLOBS greater than 64k in size to be truncated to fit the 64k limit. This is most noticeable when running deployments. If the wf_workflow blob surpasses 64k, such as if the deployment references a lot of components or properties, then the workflow will fail to be deserialized from the database and the deployment will fail. This issue does not affect customers that upgrade to 7.0.4.0, or customers that are installing a new UCD server on a database other than mysql or maria.
Local fix
Alter all columns that are currently type "blob" to be of type "longblob" The tables in UCD that have a column of type blob are: wf_workflow, wf_dispatched_task, ds_plugin_task_request, rt_command
Problem summary
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * New installations of UCD 7.0.4.0 on mysql or mariadb will * * create * * columns of type BLOB instead of LONGBLOB. This causes BLOBS * * greater than 64k in size to be truncated to fit the 64k * * limit. * * * * This is most noticeable when running deployments. If the * * wf_workflow blob surpasses 64k, such as if the deployment * * references a lot of components or properties, then the * * workflow * * will fail to be deserialized from the database and the * * deployment will fail. * * * * This issue does not affect customers that upgrade to * * 7.0.4.0, or * * customers that are installing a new UCD server on a database * * other than mysql or maria. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Fix provided for ucd 7.0.4.0.ifix02
Temporary fix
Comments
APAR Information
APAR number
PH18861
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-11-05
Closed date
2019-11-12
Last modified date
2019-11-12
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:
12 November 2019