Bug 1000034

Summary: [Admin Portal] Cannot update VM properties - Field timeZone can not be updated when status is Up
Product: Red Hat Enterprise Virtualization Manager Reporter: Chris Pelland <cpelland>
Component: ovirt-engine-webadmin-portalAssignee: Martin Betak <mbetak>
Status: CLOSED ERRATA QA Contact: Pavel Novotny <pnovotny>
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 3.2.0CC: acathrow, ecohen, iheim, jbelka, lyarwood, mbetak, michal.skrivanek, Rhev-m-bugs, scohen, yeylon
Target Milestone: ---Keywords: Regression, ZStream
Target Release: 3.2.4   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: virt
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Older versions of the Manager set the virtual machine's default time zone to an empty string, but this field is now set to a null value. This update adds a database migration script to handle this change, so users can update the time zone on running virtual machines.
 Story Points: ---
Clone Of: 988259 Environment:
Last Closed: 2013-10-25 18:43:10 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On: 988259    
Bug Blocks: 974985, 987906    

Comment 4 Pavel Novotny 2013-10-16 15:26:05 UTC 
Verified in rhevm-3.2.4-0.44.el6ev.noarch (sf21).

Verification steps:
1) In older RHEVM 3.2 (3.2.0 aka sf17.5 in this case) create new VM with Windows OS type.
2) In DB, simulate the old behavior via seting the time_zone to empty string :
{{{
# psql -U engine engine
engine=> \pset null <NULL>
engine=> UPDATE vm_static SET time_zone = '' where vm_name = 'my-win7-sf17_5';
UPDATE 1
engine=> SELECT vm_guid, vm_name, time_zone from vm_static;
               vm_guid                |    vm_name     | time_zone 
--------------------------------------+----------------+-----------
 00000000-0000-0000-0000-000000000000 | Blank          | <NULL>
 993f9143-1a45-4f69-a739-34be9f62f049 | my-win7        | 
}}}
3) Run the VM in webadmin and try to edit for example the description -> you should get an error pop-up. Stop the VM.
4) Upgrade to RHEVM 3.2.4 (sf21)
5) Repeat step 3 -> now it should be possible to change the description.
6) Check the time_zone value in DB:
{{{
# psql -U engine engine
engine=> \pset null <NULL>
engine=> SELECT vm_guid, vm_name, time_zone from vm_static;
               vm_guid                |    vm_name     | time_zone 
--------------------------------------+----------------+-----------
 00000000-0000-0000-0000-000000000000 | Blank          | <NULL>
 993f9143-1a45-4f69-a739-34be9f62f049 | my-win7        | <NULL>
}}}
Comment 6 errata-xmlrpc 2013-10-25 18:43:10 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHBA-2013-1468.html