Shirly Radco has uploaded a new change for review.

Change subject: history: removed Host power management
......................................................................

history: removed Host power management

Removed Host power management fields from History DB.

Change-Id: I9d4bff565a4bcebc1200978ec066f0d0bafb410c
Signed-off-by: Shirly Radco <[email protected]>
---
M etl_export/src/ovirt_engine_dwh/configurationsync_3_6/ConfigurationSync.java
M packaging/dbscripts/create_views_3_0.sql
M packaging/dbscripts/create_views_3_1.sql
M packaging/dbscripts/create_views_3_2.sql
M packaging/dbscripts/create_views_3_3.sql
M packaging/dbscripts/create_views_3_4.sql
M packaging/dbscripts/create_views_3_5.sql
M packaging/dbscripts/create_views_3_6.sql
A 
packaging/dbscripts/upgrade/03_06_0010_drop_pm_ip_address_from_host_configuration.sql
M tos_project/process/ConfigurationSync_3.6.item
M tos_project/process/ConfigurationSync_3.6.properties
11 files changed, 68 insertions(+), 221 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/96/36396/1

diff --git 
a/etl_export/src/ovirt_engine_dwh/configurationsync_3_6/ConfigurationSync.java 
b/etl_export/src/ovirt_engine_dwh/configurationsync_3_6/ConfigurationSync.java
index 0d12714..826fd8b 100644
--- 
a/etl_export/src/ovirt_engine_dwh/configurationsync_3_6/ConfigurationSync.java
+++ 
b/etl_export/src/ovirt_engine_dwh/configurationsync_3_6/ConfigurationSync.java
@@ -16756,12 +16756,6 @@
                        return this.host_os;
                }
 
-               public String pm_ip_address;
-
-               public String getPm_ip_address() {
-                       return this.pm_ip_address;
-               }
-
                public String kernel_version;
 
                public String getKernel_version() {
@@ -16940,8 +16934,6 @@
 
                                        this.host_os = readString(dis);
 
-                                       this.pm_ip_address = readString(dis);
-
                                        this.kernel_version = readString(dis);
 
                                        this.kvm_version = readString(dis);
@@ -17042,10 +17034,6 @@
 
                                // String
 
-                               writeString(this.pm_ip_address, dos);
-
-                               // String
-
                                writeString(this.kernel_version, dos);
 
                                // String
@@ -17100,7 +17088,6 @@
                        sb.append(",number_of_sockets=" + 
String.valueOf(number_of_sockets));
                        sb.append(",cpu_speed_mh=" + 
String.valueOf(cpu_speed_mh));
                        sb.append(",host_os=" + host_os);
-                       sb.append(",pm_ip_address=" + pm_ip_address);
                        sb.append(",kernel_version=" + kernel_version);
                        sb.append(",kvm_version=" + kvm_version);
                        sb.append(",vdsm_version=" + vdsm_version);
@@ -17238,12 +17225,6 @@
                        return this.host_os;
                }
 
-               public String pm_ip_address;
-
-               public String getPm_ip_address() {
-                       return this.pm_ip_address;
-               }
-
                public String kernel_version;
 
                public String getKernel_version() {
@@ -17417,8 +17398,6 @@
 
                                        this.host_os = readString(dis);
 
-                                       this.pm_ip_address = readString(dis);
-
                                        this.kernel_version = readString(dis);
 
                                        this.kvm_version = readString(dis);
@@ -17524,10 +17503,6 @@
 
                                // String
 
-                               writeString(this.pm_ip_address, dos);
-
-                               // String
-
                                writeString(this.kernel_version, dos);
 
                                // String
@@ -17575,7 +17550,6 @@
                        sb.append(",number_of_sockets=" + 
String.valueOf(number_of_sockets));
                        sb.append(",cpu_speed_mh=" + 
String.valueOf(cpu_speed_mh));
                        sb.append(",host_os=" + host_os);
-                       sb.append(",pm_ip_address=" + pm_ip_address);
                        sb.append(",kernel_version=" + kernel_version);
                        sb.append(",kvm_version=" + kvm_version);
                        sb.append(",vdsm_version=" + vdsm_version);
@@ -17710,12 +17684,6 @@
                        return this.host_os;
                }
 
-               public String pm_ip_address;
-
-               public String getPm_ip_address() {
-                       return this.pm_ip_address;
-               }
-
                public String kernel_version;
 
                public String getKernel_version() {
@@ -17889,8 +17857,6 @@
 
                                        this.host_os = readString(dis);
 
-                                       this.pm_ip_address = readString(dis);
-
                                        this.kernel_version = readString(dis);
 
                                        this.kvm_version = readString(dis);
@@ -17996,10 +17962,6 @@
 
                                // String
 
-                               writeString(this.pm_ip_address, dos);
-
-                               // String
-
                                writeString(this.kernel_version, dos);
 
                                // String
@@ -18047,7 +18009,6 @@
                        sb.append(",number_of_sockets=" + 
String.valueOf(number_of_sockets));
                        sb.append(",cpu_speed_mh=" + 
String.valueOf(cpu_speed_mh));
                        sb.append(",host_os=" + host_os);
-                       sb.append(",pm_ip_address=" + pm_ip_address);
                        sb.append(",kernel_version=" + kernel_version);
                        sb.append(",kvm_version=" + kvm_version);
                        sb.append(",vdsm_version=" + vdsm_version);
@@ -18153,7 +18114,7 @@
 
                                String insert_tJDBCOutput_4 = "INSERT INTO "
                                                + "host_configuration"
-                                               + " 
(host_id,host_unique_id,host_name,cluster_id,host_type,fqdn_or_ip,memory_size_mb,swap_size_mb,cpu_model,number_of_cores,number_of_sockets,cpu_speed_mh,host_os,pm_ip_address,kernel_version,kvm_version,vdsm_version,vdsm_port,cluster_configuration_version,create_date,update_date,delete_date)
 VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
+                                               + " 
(host_id,host_unique_id,host_name,cluster_id,host_type,fqdn_or_ip,memory_size_mb,swap_size_mb,cpu_model,number_of_cores,number_of_sockets,cpu_speed_mh,host_os,kernel_version,kvm_version,vdsm_version,vdsm_port,cluster_configuration_version,create_date,update_date,delete_date)
 VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
                                java.sql.PreparedStatement pstmt_tJDBCOutput_4 
= connection_tJDBCOutput_4
                                                
.prepareStatement(insert_tJDBCOutput_4);
 
@@ -18217,7 +18178,7 @@
                                java.sql.Statement stmt_tJDBCInput_4 = 
conn_tJDBCInput_4
                                                .createStatement();
 
-                               String dbquery_tJDBCInput_4 = "SELECT     
host_id,     host_unique_id,     host_name,     cluster_id,    
upper(cast(cluster_id as char(36))) as cluster_join_id,      host_type,     
fqdn_or_ip,     memory_size_mb,     swap_size_mb,     cpu_model,    
number_of_cores,    number_of_sockets,   cpu_speed_mh,    host_os,     
pm_ip_address,     kernel_version,     kvm_version,     vdsm_version,     
vdsm_port,     create_date,     update_date  FROM 
dwh_host_configuration_history_view";
+                               String dbquery_tJDBCInput_4 = "SELECT     
host_id,     host_unique_id,     host_name,     cluster_id,    
upper(cast(cluster_id as char(36))) as cluster_join_id,      host_type,     
fqdn_or_ip,     memory_size_mb,     swap_size_mb,     cpu_model,    
number_of_cores,    number_of_sockets,   cpu_speed_mh,    host_os,     
kernel_version,     kvm_version,     vdsm_version,     vdsm_port,     
create_date,     update_date  FROM dwh_host_configuration_history_view";
 
                                globalMap.put("tJDBCInput_4_QUERY", 
dbquery_tJDBCInput_4);
                                java.sql.ResultSet rs_tJDBCInput_4 = null;
@@ -18462,22 +18423,6 @@
                                                column_index_tJDBCInput_4 = 15;
 
                                                if (colQtyInRs_tJDBCInput_4 < 
column_index_tJDBCInput_4) {
-                                                       row7.pm_ip_address = 
null;
-                                               } else {
-
-                                                       tmpContent_tJDBCInput_4 
= rs_tJDBCInput_4
-                                                                       
.getString(column_index_tJDBCInput_4);
-                                                       if 
(tmpContent_tJDBCInput_4 != null) {
-                                                               
row7.pm_ip_address = tmpContent_tJDBCInput_4;
-                                                       } else {
-                                                               
row7.pm_ip_address = null;
-                                                       }
-
-                                               }
-
-                                               column_index_tJDBCInput_4 = 16;
-
-                                               if (colQtyInRs_tJDBCInput_4 < 
column_index_tJDBCInput_4) {
                                                        row7.kernel_version = 
null;
                                                } else {
 
@@ -18491,7 +18436,7 @@
 
                                                }
 
-                                               column_index_tJDBCInput_4 = 17;
+                                               column_index_tJDBCInput_4 = 16;
 
                                                if (colQtyInRs_tJDBCInput_4 < 
column_index_tJDBCInput_4) {
                                                        row7.kvm_version = null;
@@ -18507,7 +18452,7 @@
 
                                                }
 
-                                               column_index_tJDBCInput_4 = 18;
+                                               column_index_tJDBCInput_4 = 17;
 
                                                if (colQtyInRs_tJDBCInput_4 < 
column_index_tJDBCInput_4) {
                                                        row7.vdsm_version = 
null;
@@ -18523,7 +18468,7 @@
 
                                                }
 
-                                               column_index_tJDBCInput_4 = 19;
+                                               column_index_tJDBCInput_4 = 18;
 
                                                if (colQtyInRs_tJDBCInput_4 < 
column_index_tJDBCInput_4) {
                                                        row7.vdsm_port = null;
@@ -18539,7 +18484,7 @@
 
                                                }
 
-                                               column_index_tJDBCInput_4 = 20;
+                                               column_index_tJDBCInput_4 = 19;
 
                                                if (colQtyInRs_tJDBCInput_4 < 
column_index_tJDBCInput_4) {
                                                        row7.create_date = null;
@@ -18557,7 +18502,7 @@
 
                                                }
 
-                                               column_index_tJDBCInput_4 = 21;
+                                               column_index_tJDBCInput_4 = 20;
 
                                                if (colQtyInRs_tJDBCInput_4 < 
column_index_tJDBCInput_4) {
                                                        row7.update_date = null;
@@ -18694,8 +18639,6 @@
                                                                
host_configuration_tmp.cpu_speed_mh = row7.cpu_speed_mh;
                                                                
host_configuration_tmp.host_os = StringHandling
                                                                                
.TRIM(row7.host_os);
-                                                               
host_configuration_tmp.pm_ip_address = StringHandling
-                                                                               
.TRIM(row7.pm_ip_address);
                                                                
host_configuration_tmp.kernel_version = StringHandling
                                                                                
.TRIM(row7.kernel_version);
                                                                
host_configuration_tmp.kvm_version = StringHandling
@@ -18830,83 +18773,75 @@
                                                                                
        host_configuration.host_os);
                                                                }
 
-                                                               if 
(host_configuration.pm_ip_address == null) {
+                                                               if 
(host_configuration.kernel_version == null) {
                                                                        
pstmt_tJDBCOutput_4.setNull(14,
                                                                                
        java.sql.Types.VARCHAR);
                                                                } else {
                                                                        
pstmt_tJDBCOutput_4.setString(14,
-                                                                               
        host_configuration.pm_ip_address);
-                                                               }
-
-                                                               if 
(host_configuration.kernel_version == null) {
-                                                                       
pstmt_tJDBCOutput_4.setNull(15,
-                                                                               
        java.sql.Types.VARCHAR);
-                                                               } else {
-                                                                       
pstmt_tJDBCOutput_4.setString(15,
                                                                                
        host_configuration.kernel_version);
                                                                }
 
                                                                if 
(host_configuration.kvm_version == null) {
-                                                                       
pstmt_tJDBCOutput_4.setNull(16,
+                                                                       
pstmt_tJDBCOutput_4.setNull(15,
                                                                                
        java.sql.Types.VARCHAR);
                                                                } else {
-                                                                       
pstmt_tJDBCOutput_4.setString(16,
+                                                                       
pstmt_tJDBCOutput_4.setString(15,
                                                                                
        host_configuration.kvm_version);
                                                                }
 
                                                                if 
(host_configuration.vdsm_version == null) {
-                                                                       
pstmt_tJDBCOutput_4.setNull(17,
+                                                                       
pstmt_tJDBCOutput_4.setNull(16,
                                                                                
        java.sql.Types.VARCHAR);
                                                                } else {
-                                                                       
pstmt_tJDBCOutput_4.setString(17,
+                                                                       
pstmt_tJDBCOutput_4.setString(16,
                                                                                
        host_configuration.vdsm_version);
                                                                }
 
-                                                               
pstmt_tJDBCOutput_4.setInt(18,
+                                                               
pstmt_tJDBCOutput_4.setInt(17,
                                                                                
host_configuration.vdsm_port);
 
                                                                if 
(host_configuration.cluster_configuration_version == null) {
-                                                                       
pstmt_tJDBCOutput_4.setNull(19,
+                                                                       
pstmt_tJDBCOutput_4.setNull(18,
                                                                                
        java.sql.Types.INTEGER);
                                                                } else {
                                                                        
pstmt_tJDBCOutput_4
-                                                                               
        .setInt(19,
+                                                                               
        .setInt(18,
                                                                                
                        host_configuration.cluster_configuration_version);
                                                                }
 
                                                                if 
(host_configuration.create_date != null) {
                                                                        
pstmt_tJDBCOutput_4
                                                                                
        .setTimestamp(
-                                                                               
                        20,
+                                                                               
                        19,
                                                                                
                        new java.sql.Timestamp(
                                                                                
                                        host_configuration.create_date
                                                                                
                                                        .getTime()));
                                                                } else {
-                                                                       
pstmt_tJDBCOutput_4.setNull(20,
+                                                                       
pstmt_tJDBCOutput_4.setNull(19,
                                                                                
        java.sql.Types.DATE);
                                                                }
 
                                                                if 
(host_configuration.update_date != null) {
                                                                        
pstmt_tJDBCOutput_4
                                                                                
        .setTimestamp(
-                                                                               
                        21,
+                                                                               
                        20,
                                                                                
                        new java.sql.Timestamp(
                                                                                
                                        host_configuration.update_date
                                                                                
                                                        .getTime()));
                                                                } else {
-                                                                       
pstmt_tJDBCOutput_4.setNull(21,
+                                                                       
pstmt_tJDBCOutput_4.setNull(20,
                                                                                
        java.sql.Types.DATE);
                                                                }
 
                                                                if 
(host_configuration.delete_date != null) {
                                                                        
pstmt_tJDBCOutput_4
                                                                                
        .setTimestamp(
-                                                                               
                        22,
+                                                                               
                        21,
                                                                                
                        new java.sql.Timestamp(
                                                                                
                                        host_configuration.delete_date
                                                                                
                                                        .getTime()));
                                                                } else {
-                                                                       
pstmt_tJDBCOutput_4.setNull(22,
+                                                                       
pstmt_tJDBCOutput_4.setNull(21,
                                                                                
        java.sql.Types.DATE);
                                                                }
 
@@ -19163,12 +19098,6 @@
                        return this.host_os;
                }
 
-               public String pm_ip_address;
-
-               public String getPm_ip_address() {
-                       return this.pm_ip_address;
-               }
-
                public String kernel_version;
 
                public String getKernel_version() {
@@ -19347,8 +19276,6 @@
 
                                        this.host_os = readString(dis);
 
-                                       this.pm_ip_address = readString(dis);
-
                                        this.kernel_version = readString(dis);
 
                                        this.kvm_version = readString(dis);
@@ -19449,10 +19376,6 @@
 
                                // String
 
-                               writeString(this.pm_ip_address, dos);
-
-                               // String
-
                                writeString(this.kernel_version, dos);
 
                                // String
@@ -19507,7 +19430,6 @@
                        sb.append(",number_of_sockets=" + 
String.valueOf(number_of_sockets));
                        sb.append(",cpu_speed_mh=" + 
String.valueOf(cpu_speed_mh));
                        sb.append(",host_os=" + host_os);
-                       sb.append(",pm_ip_address=" + pm_ip_address);
                        sb.append(",kernel_version=" + kernel_version);
                        sb.append(",kvm_version=" + kvm_version);
                        sb.append(",vdsm_version=" + vdsm_version);
@@ -19651,12 +19573,6 @@
                        return this.host_os;
                }
 
-               public String pm_ip_address;
-
-               public String getPm_ip_address() {
-                       return this.pm_ip_address;
-               }
-
                public String kernel_version;
 
                public String getKernel_version() {
@@ -19838,8 +19754,6 @@
 
                                        this.host_os = readString(dis);
 
-                                       this.pm_ip_address = readString(dis);
-
                                        this.kernel_version = readString(dis);
 
                                        this.kvm_version = readString(dis);
@@ -19951,10 +19865,6 @@
 
                                // String
 
-                               writeString(this.pm_ip_address, dos);
-
-                               // String
-
                                writeString(this.kernel_version, dos);
 
                                // String
@@ -20007,7 +19917,6 @@
                        sb.append(",number_of_sockets=" + 
String.valueOf(number_of_sockets));
                        sb.append(",cpu_speed_mh=" + 
String.valueOf(cpu_speed_mh));
                        sb.append(",host_os=" + host_os);
-                       sb.append(",pm_ip_address=" + pm_ip_address);
                        sb.append(",kernel_version=" + kernel_version);
                        sb.append(",kvm_version=" + kvm_version);
                        sb.append(",vdsm_version=" + vdsm_version);
@@ -20150,12 +20059,6 @@
                        return this.host_os;
                }
 
-               public String pm_ip_address;
-
-               public String getPm_ip_address() {
-                       return this.pm_ip_address;
-               }
-
                public String kernel_version;
 
                public String getKernel_version() {
@@ -20337,8 +20240,6 @@
 
                                        this.host_os = readString(dis);
 
-                                       this.pm_ip_address = readString(dis);
-
                                        this.kernel_version = readString(dis);
 
                                        this.kvm_version = readString(dis);
@@ -20450,10 +20351,6 @@
 
                                // String
 
-                               writeString(this.pm_ip_address, dos);
-
-                               // String
-
                                writeString(this.kernel_version, dos);
 
                                // String
@@ -20506,7 +20403,6 @@
                        sb.append(",number_of_sockets=" + 
String.valueOf(number_of_sockets));
                        sb.append(",cpu_speed_mh=" + 
String.valueOf(cpu_speed_mh));
                        sb.append(",host_os=" + host_os);
-                       sb.append(",pm_ip_address=" + pm_ip_address);
                        sb.append(",kernel_version=" + kernel_version);
                        sb.append(",kvm_version=" + kvm_version);
                        sb.append(",vdsm_version=" + vdsm_version);
@@ -20614,7 +20510,7 @@
 
                                String insert_tJDBCOutput_17 = "INSERT INTO "
                                                + "host_configuration"
-                                               + " 
(host_id,host_unique_id,host_name,cluster_id,host_type,fqdn_or_ip,memory_size_mb,swap_size_mb,cpu_model,number_of_cores,number_of_sockets,cpu_speed_mh,host_os,pm_ip_address,kernel_version,kvm_version,vdsm_version,vdsm_port,cluster_configuration_version,create_date,update_date,delete_date)
 VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
+                                               + " 
(host_id,host_unique_id,host_name,cluster_id,host_type,fqdn_or_ip,memory_size_mb,swap_size_mb,cpu_model,number_of_cores,number_of_sockets,cpu_speed_mh,host_os,kernel_version,kvm_version,vdsm_version,vdsm_port,cluster_configuration_version,create_date,update_date,delete_date)
 VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
                                java.sql.PreparedStatement pstmt_tJDBCOutput_17 
= connection_tJDBCOutput_17
                                                
.prepareStatement(insert_tJDBCOutput_17);
 
@@ -20678,7 +20574,7 @@
                                java.sql.Statement stmt_tJDBCInput_22 = 
conn_tJDBCInput_22
                                                .createStatement();
 
-                               String dbquery_tJDBCInput_22 = "SELECT 
history_id,              host_id,                upper(cast(host_id as 
char(36))) as host_join_id,               host_unique_id,                 
host_name,              cluster_id,             host_type,              
fqdn_or_ip,             memory_size_mb,                 swap_size_mb,           
cpu_model,              number_of_cores,          number_of_sockets,         
cpu_speed_mh,              host_os,                pm_ip_address,               
   kernel_version,                 kvm_version,            vdsm_version,        
           vdsm_port,              cluster_configuration_version,               
   create_date,            update_date  FROM v3_6_latest_configuration_hosts";
+                               String dbquery_tJDBCInput_22 = "SELECT 
history_id,              host_id,                upper(cast(host_id as 
char(36))) as host_join_id,               host_unique_id,                 
host_name,              cluster_id,             host_type,              
fqdn_or_ip,             memory_size_mb,                 swap_size_mb,           
cpu_model,              number_of_cores,          number_of_sockets,         
cpu_speed_mh,              host_os,                kernel_version,              
   kvm_version,            vdsm_version,                   vdsm_port,           
   cluster_configuration_version,                  create_date,            
update_date  FROM v3_6_latest_configuration_hosts";
 
                                globalMap.put("tJDBCInput_22_QUERY", 
dbquery_tJDBCInput_22);
                                java.sql.ResultSet rs_tJDBCInput_22 = null;
@@ -20939,22 +20835,6 @@
                                                column_index_tJDBCInput_22 = 16;
 
                                                if (colQtyInRs_tJDBCInput_22 < 
column_index_tJDBCInput_22) {
-                                                       row21.pm_ip_address = 
null;
-                                               } else {
-
-                                                       
tmpContent_tJDBCInput_22 = rs_tJDBCInput_22
-                                                                       
.getString(column_index_tJDBCInput_22);
-                                                       if 
(tmpContent_tJDBCInput_22 != null) {
-                                                               
row21.pm_ip_address = tmpContent_tJDBCInput_22;
-                                                       } else {
-                                                               
row21.pm_ip_address = null;
-                                                       }
-
-                                               }
-
-                                               column_index_tJDBCInput_22 = 17;
-
-                                               if (colQtyInRs_tJDBCInput_22 < 
column_index_tJDBCInput_22) {
                                                        row21.kernel_version = 
null;
                                                } else {
 
@@ -20968,7 +20848,7 @@
 
                                                }
 
-                                               column_index_tJDBCInput_22 = 18;
+                                               column_index_tJDBCInput_22 = 17;
 
                                                if (colQtyInRs_tJDBCInput_22 < 
column_index_tJDBCInput_22) {
                                                        row21.kvm_version = 
null;
@@ -20984,7 +20864,7 @@
 
                                                }
 
-                                               column_index_tJDBCInput_22 = 19;
+                                               column_index_tJDBCInput_22 = 18;
 
                                                if (colQtyInRs_tJDBCInput_22 < 
column_index_tJDBCInput_22) {
                                                        row21.vdsm_version = 
null;
@@ -21000,7 +20880,7 @@
 
                                                }
 
-                                               column_index_tJDBCInput_22 = 20;
+                                               column_index_tJDBCInput_22 = 19;
 
                                                if (colQtyInRs_tJDBCInput_22 < 
column_index_tJDBCInput_22) {
                                                        row21.vdsm_port = null;
@@ -21016,7 +20896,7 @@
 
                                                }
 
-                                               column_index_tJDBCInput_22 = 21;
+                                               column_index_tJDBCInput_22 = 20;
 
                                                if (colQtyInRs_tJDBCInput_22 < 
column_index_tJDBCInput_22) {
                                                        
row21.cluster_configuration_version = null;
@@ -21032,7 +20912,7 @@
 
                                                }
 
-                                               column_index_tJDBCInput_22 = 22;
+                                               column_index_tJDBCInput_22 = 21;
 
                                                if (colQtyInRs_tJDBCInput_22 < 
column_index_tJDBCInput_22) {
                                                        row21.create_date = 
null;
@@ -21050,7 +20930,7 @@
 
                                                }
 
-                                               column_index_tJDBCInput_22 = 23;
+                                               column_index_tJDBCInput_22 = 22;
 
                                                if (colQtyInRs_tJDBCInput_22 < 
column_index_tJDBCInput_22) {
                                                        row21.update_date = 
null;
@@ -21178,7 +21058,6 @@
                                                                
delete_hosts_tmp.number_of_sockets = row21.number_of_sockets;
                                                                
delete_hosts_tmp.cpu_speed_mh = row21.cpu_speed_mh;
                                                                
delete_hosts_tmp.host_os = row21.host_os;
-                                                               
delete_hosts_tmp.pm_ip_address = row21.pm_ip_address;
                                                                
delete_hosts_tmp.kernel_version = row21.kernel_version;
                                                                
delete_hosts_tmp.kvm_version = row21.kvm_version;
                                                                
delete_hosts_tmp.vdsm_version = row21.vdsm_version;
@@ -21309,80 +21188,72 @@
                                                                                
delete_hosts.host_os);
                                                        }
 
-                                                       if 
(delete_hosts.pm_ip_address == null) {
+                                                       if 
(delete_hosts.kernel_version == null) {
                                                                
pstmt_tJDBCOutput_17.setNull(14,
                                                                                
java.sql.Types.VARCHAR);
                                                        } else {
                                                                
pstmt_tJDBCOutput_17.setString(14,
-                                                                               
delete_hosts.pm_ip_address);
-                                                       }
-
-                                                       if 
(delete_hosts.kernel_version == null) {
-                                                               
pstmt_tJDBCOutput_17.setNull(15,
-                                                                               
java.sql.Types.VARCHAR);
-                                                       } else {
-                                                               
pstmt_tJDBCOutput_17.setString(15,
                                                                                
delete_hosts.kernel_version);
                                                        }
 
                                                        if 
(delete_hosts.kvm_version == null) {
-                                                               
pstmt_tJDBCOutput_17.setNull(16,
+                                                               
pstmt_tJDBCOutput_17.setNull(15,
                                                                                
java.sql.Types.VARCHAR);
                                                        } else {
-                                                               
pstmt_tJDBCOutput_17.setString(16,
+                                                               
pstmt_tJDBCOutput_17.setString(15,
                                                                                
delete_hosts.kvm_version);
                                                        }
 
                                                        if 
(delete_hosts.vdsm_version == null) {
-                                                               
pstmt_tJDBCOutput_17.setNull(17,
+                                                               
pstmt_tJDBCOutput_17.setNull(16,
                                                                                
java.sql.Types.VARCHAR);
                                                        } else {
-                                                               
pstmt_tJDBCOutput_17.setString(17,
+                                                               
pstmt_tJDBCOutput_17.setString(16,
                                                                                
delete_hosts.vdsm_version);
                                                        }
 
-                                                       
pstmt_tJDBCOutput_17.setInt(18,
+                                                       
pstmt_tJDBCOutput_17.setInt(17,
                                                                        
delete_hosts.vdsm_port);
 
                                                        if 
(delete_hosts.cluster_configuration_version == null) {
-                                                               
pstmt_tJDBCOutput_17.setNull(19,
+                                                               
pstmt_tJDBCOutput_17.setNull(18,
                                                                                
java.sql.Types.INTEGER);
                                                        } else {
                                                                
pstmt_tJDBCOutput_17
-                                                                               
.setInt(19,
+                                                                               
.setInt(18,
                                                                                
                delete_hosts.cluster_configuration_version);
                                                        }
 
                                                        if 
(delete_hosts.create_date != null) {
                                                                
pstmt_tJDBCOutput_17.setTimestamp(
-                                                                               
20,
+                                                                               
19,
                                                                                
new java.sql.Timestamp(
                                                                                
                delete_hosts.create_date
+                                                                               
                                .getTime()));
+                                                       } else {
+                                                               
pstmt_tJDBCOutput_17.setNull(19,
+                                                                               
java.sql.Types.DATE);
+                                                       }
+
+                                                       if 
(delete_hosts.update_date != null) {
+                                                               
pstmt_tJDBCOutput_17.setTimestamp(
+                                                                               
20,
+                                                                               
new java.sql.Timestamp(
+                                                                               
                delete_hosts.update_date
                                                                                
                                .getTime()));
                                                        } else {
                                                                
pstmt_tJDBCOutput_17.setNull(20,
                                                                                
java.sql.Types.DATE);
                                                        }
 
-                                                       if 
(delete_hosts.update_date != null) {
-                                                               
pstmt_tJDBCOutput_17.setTimestamp(
-                                                                               
21,
-                                                                               
new java.sql.Timestamp(
-                                                                               
                delete_hosts.update_date
-                                                                               
                                .getTime()));
-                                                       } else {
-                                                               
pstmt_tJDBCOutput_17.setNull(21,
-                                                                               
java.sql.Types.DATE);
-                                                       }
-
                                                        if 
(delete_hosts.delete_date != null) {
                                                                
pstmt_tJDBCOutput_17.setTimestamp(
-                                                                               
22,
+                                                                               
21,
                                                                                
new java.sql.Timestamp(
                                                                                
                delete_hosts.delete_date
                                                                                
                                .getTime()));
                                                        } else {
-                                                               
pstmt_tJDBCOutput_17.setNull(22,
+                                                               
pstmt_tJDBCOutput_17.setNull(21,
                                                                                
java.sql.Types.DATE);
                                                        }
 
@@ -64817,6 +64688,6 @@
        ResumeUtil resumeUtil = null;
 }
 
/************************************************************************************************
- * 1764228 characters generated by Talend Open Studio for Data Integration on
- * the August 5, 2014 12:43:10 PM IDT
+ * 1760702 characters generated by Talend Open Studio for Data Integration on
+ * the December 25, 2014 3:54:56 PM IST
  
************************************************************************************************/
diff --git a/packaging/dbscripts/create_views_3_0.sql 
b/packaging/dbscripts/create_views_3_0.sql
index f435799..da85047 100644
--- a/packaging/dbscripts/create_views_3_0.sql
+++ b/packaging/dbscripts/create_views_3_0.sql
@@ -211,7 +211,7 @@
       cpu_model as cpu_model,
       number_of_cores as number_of_cores,
       host_os as host_os,
-      pm_ip_address as pm_ip_address,
+      cast(NULL as VARCHAR(255)) as pm_ip_address,
       kernel_version as kernel_version,
       kvm_version as kvm_version,
       CASE SUBSTR(vdsm_version,1,3)
diff --git a/packaging/dbscripts/create_views_3_1.sql 
b/packaging/dbscripts/create_views_3_1.sql
index 5172690..502a58f 100644
--- a/packaging/dbscripts/create_views_3_1.sql
+++ b/packaging/dbscripts/create_views_3_1.sql
@@ -213,7 +213,7 @@
       number_of_sockets,
       cpu_speed_mh,
       host_os as host_os,
-      pm_ip_address as pm_ip_address,
+      cast(NULL as VARCHAR(255)) as pm_ip_address,
       kernel_version as kernel_version,
       kvm_version as kvm_version,
       CASE SUBSTR(vdsm_version,1,3)
diff --git a/packaging/dbscripts/create_views_3_2.sql 
b/packaging/dbscripts/create_views_3_2.sql
index d5c153f..9d72bb3 100644
--- a/packaging/dbscripts/create_views_3_2.sql
+++ b/packaging/dbscripts/create_views_3_2.sql
@@ -216,7 +216,7 @@
       number_of_sockets,
       cpu_speed_mh,
       host_os as host_os,
-      pm_ip_address as pm_ip_address,
+      cast(NULL as VARCHAR(255)) as pm_ip_address,
       kernel_version as kernel_version,
       kvm_version as kvm_version,
       CASE SUBSTR(vdsm_version,1,3)
diff --git a/packaging/dbscripts/create_views_3_3.sql 
b/packaging/dbscripts/create_views_3_3.sql
index 80257a2..2537ad9 100644
--- a/packaging/dbscripts/create_views_3_3.sql
+++ b/packaging/dbscripts/create_views_3_3.sql
@@ -216,7 +216,7 @@
       number_of_sockets,
       cpu_speed_mh,
       host_os as host_os,
-      pm_ip_address as pm_ip_address,
+      cast(NULL as VARCHAR(255)) as pm_ip_address,
       kernel_version as kernel_version,
       kvm_version as kvm_version,
       CASE SUBSTR(vdsm_version,1,3)
diff --git a/packaging/dbscripts/create_views_3_4.sql 
b/packaging/dbscripts/create_views_3_4.sql
index c8f7566..19d39a3 100644
--- a/packaging/dbscripts/create_views_3_4.sql
+++ b/packaging/dbscripts/create_views_3_4.sql
@@ -210,7 +210,7 @@
       number_of_sockets,
       cpu_speed_mh,
       host_os as host_os,
-      pm_ip_address as pm_ip_address,
+      cast(NULL as VARCHAR(255)) as pm_ip_address,
       kernel_version as kernel_version,
       kvm_version as kvm_version,
       CASE SUBSTR(vdsm_version,1,3)
diff --git a/packaging/dbscripts/create_views_3_5.sql 
b/packaging/dbscripts/create_views_3_5.sql
index 2a94fa3..8ac995d 100644
--- a/packaging/dbscripts/create_views_3_5.sql
+++ b/packaging/dbscripts/create_views_3_5.sql
@@ -210,7 +210,7 @@
       number_of_sockets,
       cpu_speed_mh,
       host_os as host_os,
-      pm_ip_address as pm_ip_address,
+      cast(NULL as VARCHAR(255)) as pm_ip_address,
       kernel_version as kernel_version,
       kvm_version as kvm_version,
       CASE SUBSTR(vdsm_version,1,3)
diff --git a/packaging/dbscripts/create_views_3_6.sql 
b/packaging/dbscripts/create_views_3_6.sql
index 7ec58b8..d0102aa 100644
--- a/packaging/dbscripts/create_views_3_6.sql
+++ b/packaging/dbscripts/create_views_3_6.sql
@@ -210,7 +210,6 @@
       number_of_sockets,
       cpu_speed_mh,
       host_os as host_os,
-      pm_ip_address as pm_ip_address,
       kernel_version as kernel_version,
       kvm_version as kvm_version,
       CASE SUBSTR(vdsm_version,1,3)
diff --git 
a/packaging/dbscripts/upgrade/03_06_0010_drop_pm_ip_address_from_host_configuration.sql
 
b/packaging/dbscripts/upgrade/03_06_0010_drop_pm_ip_address_from_host_configuration.sql
new file mode 100644
index 0000000..d02f744
--- /dev/null
+++ 
b/packaging/dbscripts/upgrade/03_06_0010_drop_pm_ip_address_from_host_configuration.sql
@@ -0,0 +1,3 @@
+--delete pm_ip_address column from host_configuration table
+SELECT fn_db_drop_column('host_configuration', 'pm_ip_address');
+
diff --git a/tos_project/process/ConfigurationSync_3.6.item 
b/tos_project/process/ConfigurationSync_3.6.item
index 282f4d6..ebe1efb 100644
--- a/tos_project/process/ConfigurationSync_3.6.item
+++ b/tos_project/process/ConfigurationSync_3.6.item
@@ -740,7 +740,7 @@
     <elementParameter field="TECHNICAL" 
name="QUERYSTORE:REPOSITORY_QUERYSTORE_TYPE" value=""/>
     <elementParameter field="TECHNICAL" name="QUERYSTORE:QUERYSTORE_TYPE" 
value="BUILT_IN"/>
     <elementParameter field="GUESS_SCHEMA" name="GUESS_SCHEMA" 
value="&quot;&quot;"/>
-    <elementParameter field="MEMO_SQL" name="QUERY" value="&quot;SELECT 
&#xD;&#xA;  host_id, &#xD;&#xA;  host_unique_id, &#xD;&#xA;  host_name, 
&#xD;&#xA;  cluster_id,&#xD;&#xA;  upper(cast(cluster_id as char(36))) as 
cluster_join_id,  &#xD;&#xA;  host_type, &#xD;&#xA;  fqdn_or_ip, &#xD;&#xA;  
memory_size_mb, &#xD;&#xA;  swap_size_mb, &#xD;&#xA;  cpu_model,&#xD;&#xA;  
number_of_cores, &#xA;  number_of_sockets,&#xA;  cpu_speed_mh,&#xD;&#xA;  
host_os, &#xD;&#xA;  pm_ip_address, &#xD;&#xA;  kernel_version, &#xD;&#xA;  
kvm_version, &#xD;&#xA;  vdsm_version, &#xD;&#xA;  vdsm_port, &#xD;&#xA;  
create_date, &#xD;&#xA;  update_date&#xD;&#xA;FROM 
dwh_host_configuration_history_view&quot;"/>
+    <elementParameter field="MEMO_SQL" name="QUERY" value="&quot;SELECT 
&#xD;&#xA;  host_id, &#xD;&#xA;  host_unique_id, &#xD;&#xA;  host_name, 
&#xD;&#xA;  cluster_id,&#xD;&#xA;  upper(cast(cluster_id as char(36))) as 
cluster_join_id,  &#xD;&#xA;  host_type, &#xD;&#xA;  fqdn_or_ip, &#xD;&#xA;  
memory_size_mb, &#xD;&#xA;  swap_size_mb, &#xD;&#xA;  cpu_model,&#xD;&#xA;  
number_of_cores, &#xA;  number_of_sockets,&#xA;  cpu_speed_mh,&#xD;&#xA;  
host_os, &#xD;&#xA;  kernel_version, &#xD;&#xA;  kvm_version, &#xD;&#xA;  
vdsm_version, &#xD;&#xA;  vdsm_port, &#xD;&#xA;  create_date, &#xD;&#xA;  
update_date&#xD;&#xA;FROM dwh_host_configuration_history_view&quot;"/>
     <elementParameter field="LABEL" name="NOTE" value="This option only 
applies when deploying and running in the Talend Runtime"/>
     <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" 
value="false"/>
     <elementParameter field="TEXT" name="DATASOURCE_ALIAS" 
value="&quot;&quot;"/>
@@ -778,8 +778,6 @@
       <elementValue elementRef="TRIM" value="false"/>
       <elementValue elementRef="SCHEMA_COLUMN" value="host_os"/>
       <elementValue elementRef="TRIM" value="false"/>
-      <elementValue elementRef="SCHEMA_COLUMN" value="pm_ip_address"/>
-      <elementValue elementRef="TRIM" value="false"/>
       <elementValue elementRef="SCHEMA_COLUMN" value="kernel_version"/>
       <elementValue elementRef="TRIM" value="false"/>
       <elementValue elementRef="SCHEMA_COLUMN" value="kvm_version"/>
@@ -813,7 +811,6 @@
       <column comment="" key="false" length="5" name="number_of_sockets" 
nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" 
usefulColumn="true"/>
       <column comment="" key="false" length="18" name="cpu_speed_mh" 
nullable="true" pattern="" precision="0" sourceType="FLOAT8" type="id_Double" 
usefulColumn="true"/>
       <column comment="" key="false" length="4000" name="host_os" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
-      <column comment="" key="false" length="255" name="pm_ip_address" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="4000" name="kernel_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="4000" name="kvm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="40" name="vdsm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
@@ -850,7 +847,6 @@
       <column comment="" key="false" length="5" name="number_of_sockets" 
nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" 
usefulColumn="true"/>
       <column comment="" key="false" length="18" name="cpu_speed_mh" 
nullable="true" pattern="" precision="0" sourceType="FLOAT8" type="id_Double" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="host_os" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
-      <column comment="" key="false" length="255" name="pm_ip_address" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kernel_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kvm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="40" name="vdsm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
@@ -861,7 +857,7 @@
       <column comment="" key="false" length="8" name="delete_date" 
nullable="true" pattern="&quot;yyyy-MM-dd HH:mm:ss.SSSSSS&quot;" precision="6" 
sourceType="TIMESTAMP" type="id_Date" usefulColumn="true"/>
     </metadata>
     <nodeData xsi:type="MapperData">
-      <uiProperties/>
+      <uiProperties shellMaximized="true"/>
       <varTables sizeState="INTERMEDIATE" name="Var" minimized="true"/>
       <outputTables sizeState="INTERMEDIATE" name="host_configuration">
         <mapperTableEntries name="host_id" expression="row7.host_id" 
type="id_Object"/>
@@ -877,7 +873,6 @@
         <mapperTableEntries name="number_of_sockets" 
expression="row7.number_of_sockets" type="id_Short" nullable="true"/>
         <mapperTableEntries name="cpu_speed_mh" expression="row7.cpu_speed_mh" 
type="id_Double" nullable="true"/>
         <mapperTableEntries name="host_os" 
expression="StringHandling.TRIM(row7.host_os)" type="id_String" 
nullable="true"/>
-        <mapperTableEntries name="pm_ip_address" 
expression="StringHandling.TRIM(row7.pm_ip_address)" type="id_String" 
nullable="true"/>
         <mapperTableEntries name="kernel_version" 
expression="StringHandling.TRIM(row7.kernel_version)" type="id_String" 
nullable="true"/>
         <mapperTableEntries name="kvm_version" 
expression="StringHandling.TRIM(row7.kvm_version)" type="id_String" 
nullable="true"/>
         <mapperTableEntries name="vdsm_version" 
expression="StringHandling.TRIM(row7.vdsm_version)" type="id_String" 
nullable="true"/>
@@ -902,7 +897,6 @@
         <mapperTableEntries name="number_of_sockets" type="id_Short" 
nullable="true"/>
         <mapperTableEntries name="cpu_speed_mh" type="id_Double" 
nullable="true"/>
         <mapperTableEntries name="host_os" type="id_String" nullable="true"/>
-        <mapperTableEntries name="pm_ip_address" type="id_String" 
nullable="true"/>
         <mapperTableEntries name="kernel_version" type="id_String" 
nullable="true"/>
         <mapperTableEntries name="kvm_version" type="id_String" 
nullable="true"/>
         <mapperTableEntries name="vdsm_version" type="id_String" 
nullable="true"/>
@@ -1004,11 +998,6 @@
       <elementValue elementRef="DELETE_KEY" value="false"/>
       <elementValue elementRef="UPDATABLE" value="true"/>
       <elementValue elementRef="INSERTABLE" value="true"/>
-      <elementValue elementRef="SCHEMA_COLUMN" value="pm_ip_address"/>
-      <elementValue elementRef="UPDATE_KEY" value="false"/>
-      <elementValue elementRef="DELETE_KEY" value="false"/>
-      <elementValue elementRef="UPDATABLE" value="true"/>
-      <elementValue elementRef="INSERTABLE" value="true"/>
       <elementValue elementRef="SCHEMA_COLUMN" value="kernel_version"/>
       <elementValue elementRef="UPDATE_KEY" value="false"/>
       <elementValue elementRef="DELETE_KEY" value="false"/>
@@ -1072,7 +1061,6 @@
       <column comment="" key="false" length="5" name="number_of_sockets" 
nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" 
usefulColumn="true"/>
       <column comment="" key="false" length="18" name="cpu_speed_mh" 
nullable="true" pattern="" precision="0" sourceType="FLOAT8" type="id_Double" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="host_os" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
-      <column comment="" key="false" length="255" name="pm_ip_address" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kernel_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kvm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="40" name="vdsm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
@@ -1096,7 +1084,6 @@
       <column comment="" key="false" length="5" name="number_of_sockets" 
nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" 
usefulColumn="true"/>
       <column comment="" key="false" length="18" name="cpu_speed_mh" 
nullable="true" pattern="" precision="0" sourceType="FLOAT8" type="id_Double" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="host_os" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
-      <column comment="" key="false" length="255" name="pm_ip_address" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kernel_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kvm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="40" name="vdsm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
@@ -3318,7 +3305,7 @@
     <elementParameter field="TECHNICAL" 
name="QUERYSTORE:REPOSITORY_QUERYSTORE_TYPE" value=""/>
     <elementParameter field="TECHNICAL" name="QUERYSTORE:QUERYSTORE_TYPE" 
value="BUILT_IN"/>
     <elementParameter field="GUESS_SCHEMA" name="GUESS_SCHEMA" 
value="&quot;&quot;"/>
-    <elementParameter field="MEMO_SQL" name="QUERY" value="&quot;SELECT 
history_id, &#xD;&#xA;&#x9;&#x9;host_id, &#xD;&#xA;&#x9;&#x9;upper(cast(host_id 
as char(36))) as host_join_id,&#xD;&#xA;&#x9;&#x9;host_unique_id, 
&#xD;&#xA;&#x9;&#x9;host_name, &#xD;&#xA;&#x9;&#x9;cluster_id, 
&#xD;&#xA;&#x9;&#x9;host_type, &#xD;&#xA;&#x9;&#x9;fqdn_or_ip, 
&#xD;&#xA;&#x9;&#x9;memory_size_mb, 
&#xD;&#xA;&#x9;&#x9;swap_size_mb,&#xD;&#xA;&#x9;&#x9;cpu_model, 
&#xD;&#xA;&#x9;&#x9;number_of_cores, &#xA;        number_of_sockets,&#xA;       
 cpu_speed_mh,&#xD;&#xA;&#x9;&#x9;host_os, 
&#xD;&#xA;&#x9;&#x9;pm_ip_address,&#xD;&#xA;&#x9;&#x9;kernel_version, 
&#xD;&#xA;&#x9;&#x9;kvm_version, &#xD;&#xA;&#x9;&#x9;vdsm_version, 
&#xD;&#xA;&#x9;&#x9;vdsm_port, 
&#xD;&#xA;&#x9;&#x9;cluster_configuration_version, 
&#xD;&#xA;&#x9;&#x9;create_date, &#xD;&#xA;&#x9;&#x9;update_date&#xD;&#xA;FROM 
v3_6_latest_configuration_hosts&quot;"/>
+    <elementParameter field="MEMO_SQL" name="QUERY" value="&quot;SELECT 
history_id, &#xD;&#xA;&#x9;&#x9;host_id, &#xD;&#xA;&#x9;&#x9;upper(cast(host_id 
as char(36))) as host_join_id,&#xD;&#xA;&#x9;&#x9;host_unique_id, 
&#xD;&#xA;&#x9;&#x9;host_name, &#xD;&#xA;&#x9;&#x9;cluster_id, 
&#xD;&#xA;&#x9;&#x9;host_type, &#xD;&#xA;&#x9;&#x9;fqdn_or_ip, 
&#xD;&#xA;&#x9;&#x9;memory_size_mb, 
&#xD;&#xA;&#x9;&#x9;swap_size_mb,&#xD;&#xA;&#x9;&#x9;cpu_model, 
&#xD;&#xA;&#x9;&#x9;number_of_cores, &#xA;        number_of_sockets,&#xA;       
 cpu_speed_mh,&#xD;&#xA;&#x9;&#x9;host_os,&#xD;&#xA;&#x9;&#x9;kernel_version, 
&#xD;&#xA;&#x9;&#x9;kvm_version, &#xD;&#xA;&#x9;&#x9;vdsm_version, 
&#xD;&#xA;&#x9;&#x9;vdsm_port, 
&#xD;&#xA;&#x9;&#x9;cluster_configuration_version, 
&#xD;&#xA;&#x9;&#x9;create_date, &#xD;&#xA;&#x9;&#x9;update_date&#xD;&#xA;FROM 
v3_6_latest_configuration_hosts&quot;"/>
     <elementParameter field="LABEL" name="NOTE" value="This option only 
applies when deploying and running in the Talend Runtime"/>
     <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" 
value="false"/>
     <elementParameter field="TEXT" name="DATASOURCE_ALIAS" 
value="&quot;&quot;"/>
@@ -3358,8 +3345,6 @@
       <elementValue elementRef="TRIM" value="false"/>
       <elementValue elementRef="SCHEMA_COLUMN" value="host_os"/>
       <elementValue elementRef="TRIM" value="false"/>
-      <elementValue elementRef="SCHEMA_COLUMN" value="pm_ip_address"/>
-      <elementValue elementRef="TRIM" value="false"/>
       <elementValue elementRef="SCHEMA_COLUMN" value="kernel_version"/>
       <elementValue elementRef="TRIM" value="false"/>
       <elementValue elementRef="SCHEMA_COLUMN" value="kvm_version"/>
@@ -3396,7 +3381,6 @@
       <column comment="" key="false" length="5" name="number_of_sockets" 
nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" 
usefulColumn="true"/>
       <column comment="" key="false" length="18" name="cpu_speed_mh" 
nullable="true" pattern="" precision="0" sourceType="FLOAT8" type="id_Double" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="host_os" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
-      <column comment="" key="false" length="255" name="pm_ip_address" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kernel_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kvm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="0" name="vdsm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
@@ -3472,7 +3456,6 @@
       <column comment="" key="false" length="5" name="number_of_sockets" 
nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" 
usefulColumn="true"/>
       <column comment="" key="false" length="18" name="cpu_speed_mh" 
nullable="true" pattern="" precision="0" sourceType="FLOAT8" type="id_Double" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="host_os" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
-      <column comment="" key="false" length="255" name="pm_ip_address" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kernel_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kvm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="40" name="vdsm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
@@ -3483,7 +3466,7 @@
       <column comment="" key="false" length="8" name="delete_date" 
nullable="true" pattern="&quot;yyyy-MM-dd HH:mm:ss.SSSSSS&quot;" precision="6" 
sourceType="TIMESTAMP" type="id_Date" usefulColumn="true"/>
     </metadata>
     <nodeData xsi:type="MapperData">
-      <uiProperties/>
+      <uiProperties shellMaximized="true"/>
       <varTables sizeState="INTERMEDIATE" name="Var"/>
       <outputTables sizeState="INTERMEDIATE" name="delete_hosts" 
activateCondensedTool="true" rejectInnerJoin="true">
         <mapperTableEntries name="host_id" expression="row21.host_id" 
type="id_Object"/>
@@ -3499,7 +3482,6 @@
         <mapperTableEntries name="number_of_sockets" 
expression="row21.number_of_sockets" type="id_Short" nullable="true"/>
         <mapperTableEntries name="cpu_speed_mh" 
expression="row21.cpu_speed_mh" type="id_Double" nullable="true"/>
         <mapperTableEntries name="host_os" expression="row21.host_os" 
type="id_String" nullable="true"/>
-        <mapperTableEntries name="pm_ip_address" 
expression="row21.pm_ip_address " type="id_String" nullable="true"/>
         <mapperTableEntries name="kernel_version" 
expression="row21.kernel_version" type="id_String" nullable="true"/>
         <mapperTableEntries name="kvm_version" expression="row21.kvm_version" 
type="id_String" nullable="true"/>
         <mapperTableEntries name="vdsm_version" 
expression="row21.vdsm_version" type="id_String" nullable="true"/>
@@ -3525,7 +3507,6 @@
         <mapperTableEntries name="number_of_sockets" type="id_Short" 
nullable="true"/>
         <mapperTableEntries name="cpu_speed_mh" type="id_Double" 
nullable="true"/>
         <mapperTableEntries name="host_os" type="id_String" nullable="true"/>
-        <mapperTableEntries name="pm_ip_address" type="id_String" 
nullable="true"/>
         <mapperTableEntries name="kernel_version" type="id_String" 
nullable="true"/>
         <mapperTableEntries name="kvm_version" type="id_String" 
nullable="true"/>
         <mapperTableEntries name="vdsm_version" type="id_String" 
nullable="true"/>
@@ -3627,11 +3608,6 @@
       <elementValue elementRef="DELETE_KEY" value="false"/>
       <elementValue elementRef="UPDATABLE" value="true"/>
       <elementValue elementRef="INSERTABLE" value="true"/>
-      <elementValue elementRef="SCHEMA_COLUMN" value="pm_ip_address"/>
-      <elementValue elementRef="UPDATE_KEY" value="false"/>
-      <elementValue elementRef="DELETE_KEY" value="false"/>
-      <elementValue elementRef="UPDATABLE" value="true"/>
-      <elementValue elementRef="INSERTABLE" value="true"/>
       <elementValue elementRef="SCHEMA_COLUMN" value="kernel_version"/>
       <elementValue elementRef="UPDATE_KEY" value="false"/>
       <elementValue elementRef="DELETE_KEY" value="false"/>
@@ -3694,7 +3670,6 @@
       <column comment="" key="false" length="5" name="number_of_sockets" 
nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" 
usefulColumn="true"/>
       <column comment="" key="false" length="18" name="cpu_speed_mh" 
nullable="true" pattern="" precision="0" sourceType="FLOAT8" type="id_Double" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="host_os" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
-      <column comment="" key="false" length="255" name="pm_ip_address" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kernel_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kvm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="40" name="vdsm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
@@ -3718,7 +3693,6 @@
       <column comment="" key="false" length="5" name="number_of_sockets" 
nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" 
usefulColumn="true"/>
       <column comment="" key="false" length="18" name="cpu_speed_mh" 
nullable="true" pattern="" precision="0" sourceType="FLOAT8" type="id_Double" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="host_os" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
-      <column comment="" key="false" length="255" name="pm_ip_address" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kernel_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="255" name="kvm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
       <column comment="" key="false" length="40" name="vdsm_version" 
nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" 
usefulColumn="true"/>
@@ -8184,7 +8158,7 @@
       <column comment="" key="false" length="35" name="delete_date" 
nullable="true" pattern="&quot;dd-MM-yyyy&quot;" sourceType="" type="id_Date" 
originalLength="35" usefulColumn="true"/>
     </metadata>
     <nodeData xsi:type="MapperData">
-      <uiProperties shellMaximized="true"/>
+      <uiProperties/>
       <varTables sizeState="INTERMEDIATE" name="Var"/>
       <outputTables sizeState="INTERMEDIATE" name="delete_users" 
activateCondensedTool="true" rejectInnerJoin="true">
         <mapperTableEntries name="user_id" expression="row57.user_id " 
type="id_Object"/>
diff --git a/tos_project/process/ConfigurationSync_3.6.properties 
b/tos_project/process/ConfigurationSync_3.6.properties
index 64a3952..e1c7520 100644
--- a/tos_project/process/ConfigurationSync_3.6.properties
+++ b/tos_project/process/ConfigurationSync_3.6.properties
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"; 
xmlns:TalendProperties="http://www.talend.org/properties";>
-  <TalendProperties:Property xmi:id="_sTiOMEP_EeC5PvJxFZIIsw" 
id="_sTgZAEP_EeC5PvJxFZIIsw" label="ConfigurationSync" 
creationDate="2011-07-06T14:17:03.952+0300" 
modificationDate="2014-08-05T10:58:11.877+0300" version="3.6" statusCode="" 
item="_sTiOMkP_EeC5PvJxFZIIsw" displayName="ConfigurationSync">
+  <TalendProperties:Property xmi:id="_sTiOMEP_EeC5PvJxFZIIsw" 
id="_sTgZAEP_EeC5PvJxFZIIsw" label="ConfigurationSync" 
creationDate="2011-07-06T14:17:03.952+0300" 
modificationDate="2014-12-25T15:54:02.026+0200" version="3.6" statusCode="" 
item="_sTiOMkP_EeC5PvJxFZIIsw" displayName="ConfigurationSync">
     <author href="../talend.project#_SapC4EJlEeCWRqOtaF5m-w"/>
   </TalendProperties:Property>
   <TalendProperties:ItemState xmi:id="_sTiOMUP_EeC5PvJxFZIIsw" path=""/>


-- 
To view, visit http://gerrit.ovirt.org/36396
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I9d4bff565a4bcebc1200978ec066f0d0bafb410c
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-dwh
Gerrit-Branch: master
Gerrit-Owner: Shirly Radco <[email protected]>
_______________________________________________
Engine-patches mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to