APAR status
Closed as fixed if next.
Error description
Power Virtualization Center (PowerVC) 1.4.2 upgrade failed with below error. DBMigrationError: (_mysql_exceptions.DataError) (1406, "Data too long for column 'image_configuration_strategy' at row 26") [SQL: u'UPDATE instance_power_specs SET image_endianness=(SELECT instance_system_metadata.value \nFROM instance_system_metadata \nWHERE instance_system_metadata.instance_uuid = instance_power_specs.instance_uuid AND instance_system_metadata.`key` = %s), image_configuration_strategy=(SELECT instance_system_metadata.value \nFROM instance_system_metadata \nWHERE instance_system_metadata.instance_uuid = instance_power_specs.instance_uuid AND instance_system_metadata.`key` = %s), image_os_distro=(SELECT instance_system_metadata.value \nFROM instance_system_metadata \nWHERE instance_system_metadata.instance_uuid = instance_power_specs.instance_uuid AND instance_system_metadata.`key` = %s), storage_connectivity_group_id=(SELECT instance_system_metadata.value \nFROM instance_system_metadata \nWHERE instance_system_metadata.instance_uuid = instance_power_specs.instance_uuid AND instance_system_metadata.`key` = %s)'] [parameters: ('image_endianness', 'image_configuration_strategy', 'image_os_distro', 'storage_connectivity_group_id')] Impact: PowerVC restore fails during upgrade.
Local fix
Problem summary
Code changes have been implemented and the fix is available in future release.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IT28007
Reported component name
POWERVC STANDAR
Reported component ID
5765VCS00
Reported release
142
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Submitted date
2019-02-06
Closed date
2019-03-18
Last modified date
2019-03-18
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXK2N","label":"PowerVC Standard Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"142","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG11R","label":"APARs - AIX 7.1 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"142","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG11Q","label":"AIX 6.1 HIPERS, APARs and Fixes"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"142","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
18 March 2019