Note: This is a beta release of Red Hat Bugzilla 5.0. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Also email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback here.

Bug 891073

Summary: [rhevm-dwh] History DB - Change Fields "Network Name" to "Logical Network Name"
Product: Red Hat Enterprise Virtualization Manager Reporter: David Botzer <dbotzer>
Component: ovirt-engine-dwhAssignee: Shirly Radco <sradco>
Status: CLOSED ERRATA QA Contact: Pavel Stehlik <pstehlik>
Severity: low Docs Contact:
Priority: low    
Version: 3.1.0CC: aberezin, bazulay, bsettle, iheim, pstehlik, rbalakri, Rhev-m-bugs, ylavi
Target Milestone: ---Flags: dyasny: Triaged+
Target Release: 3.5.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: infra
Fixed In Version: oVirt 3.5 Alpha 1 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-02-11 18:14:09 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On:    
Bug Blocks: 1142923, 1156165    
Attachments:
Description Flags
NetworkName none

Description David Botzer 2013-01-01 14:44:42 UTC
Created attachment 670984 [details]
NetworkName

Description of problem:
In webadmin the entity name is"Logical Network"
And in History DB / Reports this entity fields are called only "Network"
e.x
"Network Name"

In order to distinguish, and allow coralation between Webadmin & Reports

Version-Release number of selected component (if applicable):
3.1/si25.2

How reproducible:
always

Steps to Reproduce:
1.Examine Engine DB table "network" the field name is "Network Name"
2.Examine Engine DB "vds_interface" the field name is "Network Name"
3.Examine History DB "v3_1_host_interface_configuration_view" the field name is "Network Name"
4.Examine in Webadmin under cluster, See Logical Networks Tab
  name of entity is "Logical Network"
  
Actual results:
field name is "Network Name"

Expected results:
Should change to "Logical Network Name"

Additional info:

Comment 3 Barak Dagan 2014-06-11 12:52:03 UTC
Verified on oVirt 3.5 Alpha 1:

bash-4.1$ psql -d engine -c "select table_name, column_name from information_schema.columns where table_name like '%dwh%view%' and column_name like '%network%';"

                  table_name                   |     column_name      
-----------------------------------------------+----------------------
 dwh_host_interface_configuration_history_view | logical_network_name
 dwh_vm_interface_configuration_history_view   | logical_network_name



bash-4.1$ psql -d ovirt_engine_history -c "select table_name, column_name from information_schema.columns where table_name like 'v3_5%configuration%' and column_name like '%network%';"

                 table_name                  |     column_name      
---------------------------------------------+----------------------
 v3_5_configuration_history_hosts_interfaces | logical_network_name
 v3_5_latest_configuration_hosts_interfaces  | logical_network_name
 v3_5_configuration_history_vms_interfaces   | logical_network_name
 v3_5_latest_configuration_vms_interfaces    | logical_network_name

Comment 6 errata-xmlrpc 2015-02-11 18:14:09 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.

https://rhn.redhat.com/errata/RHEA-2015-0177.html