hyperic-hq-discuss — Hyperic HQ SVN Commits

[Hyperic-hq-discuss] [JIRA] Updated: (HHQ-755) Unable to store very large or small values.

[Ryan M. (JIRA) <ji...@hy...>]

     [ http://jira.hyperic.com/browse/HHQ-755?page=all ]

Ryan Morgan updated HHQ-755:
----------------------------

    Attachment: patch.txt


Attach a better patch that just appends a very small measurement value to the end of each report.

> Unable to store very large or small values.
> -------------------------------------------
>
>          Key: HHQ-755
>          URL: http://jira.hyperic.com/browse/HHQ-755
>      Project: Hyperic HQ
>         Type: Bug

>   Components: Measurement
>     Versions: 3.0.0, 3.0.1, 3.0.2
>  Environment: Seen on both Oracle 9i and Postgres 8.2.0
>     Reporter: Ryan Morgan
>     Assignee: Jon Travis
>     Priority: Blocker
>      Fix For: 3.0.3, 3.1.0
>  Attachments: patch.txt
>
>
> Attempting to insert Double.MIN_VALUE or Double.MAX_VALUE fails on both Oracle and Postgres.  Double.MIN_VALUE is 2-1074, but I've seen this behavior on numbers in the 2-210 range.
> This is critical since any bad value could potentially cause the entire metric data batch to be thrown out.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.hyperic.com/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[Hyperic-hq-discuss] [JIRA] Updated: (HHQ-755) Unable to store very large or small values.

[Ryan M. (JIRA) <ji...@hy...>]

     [ http://jira.hyperic.com/browse/HHQ-755?page=all ]

Ryan Morgan updated HHQ-755:
----------------------------

    Attachment:     (was: patch.txt)

> Unable to store very large or small values.
> -------------------------------------------
>
>          Key: HHQ-755
>          URL: http://jira.hyperic.com/browse/HHQ-755
>      Project: Hyperic HQ
>         Type: Bug

>   Components: Measurement
>     Versions: 3.0.0, 3.0.1, 3.0.2
>  Environment: Seen on both Oracle 9i and Postgres 8.2.0
>     Reporter: Ryan Morgan
>     Assignee: Jon Travis
>     Priority: Blocker
>      Fix For: 3.0.3, 3.1.0

>
>
> Attempting to insert Double.MIN_VALUE or Double.MAX_VALUE fails on both Oracle and Postgres.  Double.MIN_VALUE is 2-1074, but I've seen this behavior on numbers in the 2-210 range.
> This is critical since any bad value could potentially cause the entire metric data batch to be thrown out.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.hyperic.com/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Re: [Hyperic-hq-discuss] UPtime or availablility of a platform and of a server

[mike m. <mi...@an...>]

Thanks for your info...

Re: [Hyperic-hq-discuss] Cant run new discovery on a windows box

[mike m. <mi...@an...>]

THanks for the fast response.

[Hyperic-hq-discuss] hq r3797 - in branches/HQ_3_0: installer/data sql/measurement src/org/hyperic/hq/measurement/server/session

[<jt...@hy...>]

Author: jtravis
Date: 2007-03-20 12:50:02 -0800 (Tue, 20 Mar 2007)
New Revision: 3797
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3797

Modified:
   branches/HQ_3_0/installer/data/db-upgrade.xml
   branches/HQ_3_0/sql/measurement/MeasurementData.hq-xml
   branches/HQ_3_0/sql/measurement/MeasurementHistData.hq-xml
   branches/HQ_3_0/src/org/hyperic/hq/measurement/server/session/DataManagerEJBImpl.java
   branches/HQ_3_0/src/org/hyperic/hq/measurement/server/session/MeasurementData.java
   branches/HQ_3_0/src/org/hyperic/hq/measurement/server/session/MeasurementHistData.java
Log:
HHQ-755 Revert back to BigDecimal, since underflows and other floating point errors will cause measurement data to not be inserted.  The original Sorry error is likely fixed by the change to DataManager which dealt with processing the exception of batch (logic error)

Modified: branches/HQ_3_0/installer/data/db-upgrade.xml
===================================================================
--- branches/HQ_3_0/installer/data/db-upgrade.xml	2007-03-20 20:35:41 UTC (rev 3796)
+++ branches/HQ_3_0/installer/data/db-upgrade.xml	2007-03-20 20:50:02 UTC (rev 3797)
@@ -4938,6 +4938,70 @@
                             nullable="NULL"/>
     </schemaSpec>
 
+	<schemaSpec version="3.22">
+	  <schema-directSQL>
+	    <statement targetDB="postgresql">
+	      alter table eam_measurement_data alter column value type NUMERIC(24,5)
+	    </statement>
+	    <statement targetDB="postgresql">
+	      alter table eam_measurement_data_1h alter column value type  NUMERIC(24,5)
+	    </statement>
+	    <statement targetDB="postgresql">
+	      alter table eam_measurement_data_1h alter column minvalue type NUMERIC(24,5)
+	    </statement>
+	    <statement targetDB="postgresql">
+	      alter table eam_measurement_data_1h alter column maxvalue type NUMERIC(24,5)
+	    </statement>
+        <statement targetDB="postgresql">
+          alter table eam_measurement_data_6h alter column value type NUMERIC(24,5)
+        </statement>
+        <statement targetDB="postgresql">
+          alter table eam_measurement_data_6h alter column minvalue type NUMERIC(24,5)
+        </statement>
+        <statement targetDB="postgresql">
+          alter table eam_measurement_data_6h alter column maxvalue type NUMERIC(24,5)
+        </statement>
+        <statement targetDB="postgresql">
+          alter table eam_measurement_data_1d alter column value type NUMERIC(24,5)
+        </statement>
+        <statement targetDB="postgresql">
+          alter table eam_measurement_data_1d alter column minvalue type NUMERIC(24,5)
+        </statement>
+        <statement targetDB="postgresql">
+          alter table eam_measurement_data_1d alter column maxvalue type NUMERIC(24,5)
+        </statement>
+
+	  	<statement targetDB="oracle">
+          alter table eam_measurement_data modify (
+            value NUMERIC(24,5)
+          )
+        </statement>
+        <statement targetDB="oracle">
+          alter table eam_measurement_data_1h modify (
+            value NUMERIC(24,5),
+            minvalue NUMERIC(24,5),
+            maxvalue NUMERIC(24,5)
+          )
+        </statement>
+        <statement targetDB="oracle">
+          alter table eam_measurement_data_6h modify (
+            value NUMERIC(24,5),
+            minvalue NUMERIC(24,5),
+            maxvalue NUMERIC(24,5)
+          )
+        </statement>
+        <statement targetDB="oracle">
+          alter table eam_measurement_data_1d modify (
+            value NUMERIC(24,5),
+            minvalue NUMERIC(24,5),
+            maxvalue NUMERIC(24,5)
+          )
+        </statement>
+      
+      </schema-directSQL>
+    </schemaSpec>
+	
+
 </dbupgrade>
 
 </target>

Modified: branches/HQ_3_0/sql/measurement/MeasurementData.hq-xml
===================================================================
--- branches/HQ_3_0/sql/measurement/MeasurementData.hq-xml	2007-03-20 20:35:41 UTC (rev 3796)
+++ branches/HQ_3_0/sql/measurement/MeasurementData.hq-xml	2007-03-20 20:50:02 UTC (rev 3797)
@@ -17,8 +17,8 @@
       </key-property>
     </composite-id>
 
-    <property name="value">
-      <column name="VALUE" />
+    <property name="value" type="big_decimal">
+      <column name="VALUE" precision="24" scale="5" />
     </property>
   </class>
 

Modified: branches/HQ_3_0/sql/measurement/MeasurementHistData.hq-xml
===================================================================
--- branches/HQ_3_0/sql/measurement/MeasurementHistData.hq-xml	2007-03-20 20:35:41 UTC (rev 3796)
+++ branches/HQ_3_0/sql/measurement/MeasurementHistData.hq-xml	2007-03-20 20:50:02 UTC (rev 3797)
@@ -17,16 +17,16 @@
       </key-property>
     </composite-id>
 
-    <property name="value">
-      <column name="VALUE"/>
+    <property name="value" type="big_decimal">
+      <column name="VALUE" precision="24" scale="5" />
     </property>
 
-    <property name="minValue">
-      <column name="MINVALUE"/>
+    <property name="minValue" type="big_decimal">
+      <column name="MINVALUE" precision="24" scale="5"/>
     </property>
 
-    <property name="maxValue">
-      <column name="MAXVALUE"/>
+    <property name="maxValue" type="big_decimal">
+      <column name="MAXVALUE" precision="24" scale="5"/>
     </property>
   </class>
 
@@ -41,16 +41,16 @@
       </key-property>
     </composite-id>
 
-    <property name="value">
-      <column name="VALUE"/>
+    <property name="value" type="big_decimal">
+      <column name="VALUE" precision="24" scale="5" />
     </property>
 
-    <property name="minValue">
-      <column name="MINVALUE"/>
+    <property name="minValue" type="big_decimal">
+      <column name="MINVALUE" precision="24" scale="5"/>
     </property>
 
-    <property name="maxValue">
-      <column name="MAXVALUE"/>
+    <property name="maxValue" type="big_decimal">
+      <column name="MAXVALUE" precision="24" scale="5"/>
     </property>
   </class>
 
@@ -65,16 +65,16 @@
       </key-property>
     </composite-id>
 
-    <property name="value">
-      <column name="VALUE"/>
+    <property name="value" type="big_decimal">
+      <column name="VALUE" precision="24" scale="5" />
     </property>
 
-    <property name="minValue">
-      <column name="MINVALUE"/>
+    <property name="minValue" type="big_decimal">
+      <column name="MINVALUE" precision="24" scale="5"/>
     </property>
 
-    <property name="maxValue">
-      <column name="MAXVALUE"/>
+    <property name="maxValue" type="big_decimal">
+      <column name="MAXVALUE" precision="24" scale="5"/>
     </property>
   </class>
 

Modified: branches/HQ_3_0/src/org/hyperic/hq/measurement/server/session/DataManagerEJBImpl.java
===================================================================
--- branches/HQ_3_0/src/org/hyperic/hq/measurement/server/session/DataManagerEJBImpl.java	2007-03-20 20:35:41 UTC (rev 3796)
+++ branches/HQ_3_0/src/org/hyperic/hq/measurement/server/session/DataManagerEJBImpl.java	2007-03-20 20:50:02 UTC (rev 3797)
@@ -25,6 +25,7 @@
 
 package org.hyperic.hq.measurement.server.session;
 
+import java.math.BigDecimal;
 import java.sql.BatchUpdateException;
 import java.sql.Connection;
 import java.sql.PreparedStatement;
@@ -303,10 +304,17 @@
                 DataPoint pt = (DataPoint)i.next();
                 Integer metricId = pt.getMetricId();
                 MetricValue val = pt.getMetricValue();
+                BigDecimal bigDec;
                 
+                try {
+                    bigDec = BigDecimal.valueOf(val.getValue());
+                } catch(NumberFormatException e) {  // infinite, or NaN
+                    _log.warn("Unable to insert infinite or NaN for metric id=" + metricId);
+                    continue;
+                }
                 stmt.setInt(1, metricId.intValue());
                 stmt.setLong(2, val.getTimestamp());
-                stmt.setDouble(3, val.getValue());
+                stmt.setBigDecimal(3, bigDec);
                 stmt.addBatch();
             }
             
@@ -432,10 +440,17 @@
                 DataPoint pt = (DataPoint)i.next();
                 Integer metricId  = pt.getMetricId();
                 MetricValue val   = pt.getMetricValue();
+                BigDecimal bigDec;
                 
+                try {
+                    bigDec = BigDecimal.valueOf(val.getValue());
+                } catch(NumberFormatException e) {  // infinite, or NaN
+                    _log.warn("Unable to insert infinite or NaN for metric id=" + metricId);
+                    continue;
+                }
                 stmt.setInt(1, metricId.intValue());
                 stmt.setLong(2, val.getTimestamp());
-                stmt.setDouble(3, val.getValue());
+                stmt.setBigDecimal(3, bigDec);
                 stmt.addBatch();
             }
             

Modified: branches/HQ_3_0/src/org/hyperic/hq/measurement/server/session/MeasurementData.java
===================================================================
--- branches/HQ_3_0/src/org/hyperic/hq/measurement/server/session/MeasurementData.java	2007-03-20 20:35:41 UTC (rev 3796)
+++ branches/HQ_3_0/src/org/hyperic/hq/measurement/server/session/MeasurementData.java	2007-03-20 20:50:02 UTC (rev 3797)
@@ -26,10 +26,11 @@
 package org.hyperic.hq.measurement.server.session;
 
 import java.io.Serializable;
+import java.math.BigDecimal;
 
 public class MeasurementData implements Serializable {
     private MeasurementDataId _id;
-    private double            _value;
+    private BigDecimal        _value;
 
     public MeasurementData() {
     }
@@ -42,11 +43,11 @@
         _id = id;
     }
 
-    public double getValue() {
+    public BigDecimal getValue() {
         return _value;
     }
     
-    protected void setValue(double value) {
+    protected void setValue(BigDecimal value) {
         _value = value;
     }
 

Modified: branches/HQ_3_0/src/org/hyperic/hq/measurement/server/session/MeasurementHistData.java
===================================================================
--- branches/HQ_3_0/src/org/hyperic/hq/measurement/server/session/MeasurementHistData.java	2007-03-20 20:35:41 UTC (rev 3796)
+++ branches/HQ_3_0/src/org/hyperic/hq/measurement/server/session/MeasurementHistData.java	2007-03-20 20:50:02 UTC (rev 3797)
@@ -26,14 +26,15 @@
 package org.hyperic.hq.measurement.server.session;
 
 import java.io.Serializable;
+import java.math.BigDecimal;
 
 public class MeasurementHistData 
     implements Serializable 
 {
     private MeasurementDataId _id;
-    private double            _value;
-    private double            _minValue;
-    private double            _maxValue;
+    private BigDecimal            _value;
+    private BigDecimal            _minValue;
+    private BigDecimal            _maxValue;
 
     protected MeasurementHistData() {
     }
@@ -46,27 +47,27 @@
         _id = id;
     }
 
-    public double getValue() {
+    public BigDecimal getValue() {
         return _value;
     }
     
-    protected void setValue(double value) {
+    protected void setValue(BigDecimal value) {
         _value = value;
     }
 
-    public double getMinValue() {
+    public BigDecimal getMinValue() {
         return _minValue;
     }
     
-    protected void setMinValue(double minValue) {
+    protected void setMinValue(BigDecimal minValue) {
         _minValue = minValue;
     }
 
-    public double getMaxValue() {
+    public BigDecimal getMaxValue() {
         return _maxValue;
     }
     
-    protected void setMaxValue(double maxValue) {
+    protected void setMaxValue(BigDecimal maxValue) {
         _maxValue = maxValue;
     }
 

Re: [Hyperic-hq-discuss] How to configure Hyperic to use Active Directory for LDAP Authenticatio

[Murray B. <hq-...@hy...>]

I'm running the 3.0.2EE Beta. (The last Beta before 3.0EE went GA.)

Cheers . . . Murray

[Hyperic-hq-discuss] hq r3796 - trunk/src/org/hyperic/hq/measurement/server/session

[<jt...@hy...>]

Author: jtravis
Date: 2007-03-20 12:35:41 -0800 (Tue, 20 Mar 2007)
New Revision: 3796
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3796

Modified:
   trunk/src/org/hyperic/hq/measurement/server/session/MeasurementData.java
Log:
Revert back to BigDecimal, since underflows and other floating point errors will cause measurement data to not be inserted.  The original Sorry error is likely fixed by the change to DataManager which dealt with processing the exception of batch (logic error)

Modified: trunk/src/org/hyperic/hq/measurement/server/session/MeasurementData.java
===================================================================
--- trunk/src/org/hyperic/hq/measurement/server/session/MeasurementData.java	2007-03-20 20:19:17 UTC (rev 3795)
+++ trunk/src/org/hyperic/hq/measurement/server/session/MeasurementData.java	2007-03-20 20:35:41 UTC (rev 3796)
@@ -26,10 +26,11 @@
 package org.hyperic.hq.measurement.server.session;
 
 import java.io.Serializable;
+import java.math.BigDecimal;
 
 public class MeasurementData implements Serializable {
     private MeasurementDataId _id;
-    private double            _value;
+    private BigDecimal        _value;
 
     public MeasurementData() {
     }
@@ -42,11 +43,11 @@
         _id = id;
     }
 
-    public double getValue() {
+    public BigDecimal getValue() {
         return _value;
     }
     
-    protected void setValue(double value) {
+    protected void setValue(BigDecimal value) {
         _value = value;
     }
 

[Hyperic-hq-discuss] hq r3795 - in trunk: installer/data sql/measurement src/org/hyperic/hq/measurement/server/session

[<jt...@hy...>]

Author: jtravis
Date: 2007-03-20 12:19:17 -0800 (Tue, 20 Mar 2007)
New Revision: 3795
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3795

Modified:
   trunk/installer/data/db-upgrade.xml
   trunk/sql/measurement/MeasurementData.hq-xml
   trunk/sql/measurement/MeasurementHistData.hq-xml
   trunk/src/org/hyperic/hq/measurement/server/session/DataManagerEJBImpl.java
   trunk/src/org/hyperic/hq/measurement/server/session/MeasurementHistData.java
Log:
Revert back to BigDecimal, since underflows and other floating point errors will cause measurement data to not be inserted.  The original Sorry error is likely fixed by the change to DataManager which dealt with processing the exception of batch (logic error)

Modified: trunk/installer/data/db-upgrade.xml
===================================================================
--- trunk/installer/data/db-upgrade.xml	2007-03-20 13:03:23 UTC (rev 3794)
+++ trunk/installer/data/db-upgrade.xml	2007-03-20 20:19:17 UTC (rev 3795)
@@ -4938,6 +4938,70 @@
                             nullable="NULL"/>
     </schemaSpec>
 
+	<schemaSpec version="3.22">
+	  <schema-directSQL>
+	    <statement targetDB="postgresql">
+	      alter table eam_measurement_data alter column value type NUMERIC(24,5)
+	    </statement>
+	    <statement targetDB="postgresql">
+	      alter table eam_measurement_data_1h alter column value type  NUMERIC(24,5)
+	    </statement>
+	    <statement targetDB="postgresql">
+	      alter table eam_measurement_data_1h alter column minvalue type NUMERIC(24,5)
+	    </statement>
+	    <statement targetDB="postgresql">
+	      alter table eam_measurement_data_1h alter column maxvalue type NUMERIC(24,5)
+	    </statement>
+        <statement targetDB="postgresql">
+          alter table eam_measurement_data_6h alter column value type NUMERIC(24,5)
+        </statement>
+        <statement targetDB="postgresql">
+          alter table eam_measurement_data_6h alter column minvalue type NUMERIC(24,5)
+        </statement>
+        <statement targetDB="postgresql">
+          alter table eam_measurement_data_6h alter column maxvalue type NUMERIC(24,5)
+        </statement>
+        <statement targetDB="postgresql">
+          alter table eam_measurement_data_1d alter column value type NUMERIC(24,5)
+        </statement>
+        <statement targetDB="postgresql">
+          alter table eam_measurement_data_1d alter column minvalue type NUMERIC(24,5)
+        </statement>
+        <statement targetDB="postgresql">
+          alter table eam_measurement_data_1d alter column maxvalue type NUMERIC(24,5)
+        </statement>
+
+	  	<statement targetDB="oracle">
+          alter table eam_measurement_data modify (
+            value NUMERIC(24,5)
+          )
+        </statement>
+        <statement targetDB="oracle">
+          alter table eam_measurement_data_1h modify (
+            value NUMERIC(24,5),
+            minvalue NUMERIC(24,5),
+            maxvalue NUMERIC(24,5)
+          )
+        </statement>
+        <statement targetDB="oracle">
+          alter table eam_measurement_data_6h modify (
+            value NUMERIC(24,5),
+            minvalue NUMERIC(24,5),
+            maxvalue NUMERIC(24,5)
+          )
+        </statement>
+        <statement targetDB="oracle">
+          alter table eam_measurement_data_1d modify (
+            value NUMERIC(24,5),
+            minvalue NUMERIC(24,5),
+            maxvalue NUMERIC(24,5)
+          )
+        </statement>
+      
+      </schema-directSQL>
+    </schemaSpec>
+	
+
 </dbupgrade>
 
 </target>

Modified: trunk/sql/measurement/MeasurementData.hq-xml
===================================================================
--- trunk/sql/measurement/MeasurementData.hq-xml	2007-03-20 13:03:23 UTC (rev 3794)
+++ trunk/sql/measurement/MeasurementData.hq-xml	2007-03-20 20:19:17 UTC (rev 3795)
@@ -17,8 +17,8 @@
       </key-property>
     </composite-id>
 
-    <property name="value">
-      <column name="VALUE" />
+    <property name="value" type="big_decimal">
+      <column name="VALUE" precision="24" scale="5" />
     </property>
   </class>
 

Modified: trunk/sql/measurement/MeasurementHistData.hq-xml
===================================================================
--- trunk/sql/measurement/MeasurementHistData.hq-xml	2007-03-20 13:03:23 UTC (rev 3794)
+++ trunk/sql/measurement/MeasurementHistData.hq-xml	2007-03-20 20:19:17 UTC (rev 3795)
@@ -17,16 +17,16 @@
       </key-property>
     </composite-id>
 
-    <property name="value">
-      <column name="VALUE"/>
+    <property name="value" type="big_decimal">
+      <column name="VALUE" precision="24" scale="5" />
     </property>
 
-    <property name="minValue">
-      <column name="MINVALUE"/>
+    <property name="minValue" type="big_decimal">
+      <column name="MINVALUE" precision="24" scale="5"/>
     </property>
 
-    <property name="maxValue">
-      <column name="MAXVALUE"/>
+    <property name="maxValue" type="big_decimal">
+      <column name="MAXVALUE" precision="24" scale="5"/>
     </property>
   </class>
 
@@ -41,16 +41,16 @@
       </key-property>
     </composite-id>
 
-    <property name="value">
-      <column name="VALUE"/>
+    <property name="value" type="big_decimal">
+      <column name="VALUE" precision="24" scale="5" />
     </property>
 
-    <property name="minValue">
-      <column name="MINVALUE"/>
+    <property name="minValue" type="big_decimal">
+      <column name="MINVALUE" precision="24" scale="5"/>
     </property>
 
-    <property name="maxValue">
-      <column name="MAXVALUE"/>
+    <property name="maxValue" type="big_decimal">
+      <column name="MAXVALUE" precision="24" scale="5"/>
     </property>
   </class>
 
@@ -65,16 +65,16 @@
       </key-property>
     </composite-id>
 
-    <property name="value">
-      <column name="VALUE"/>
+    <property name="value" type="big_decimal">
+      <column name="VALUE" precision="24" scale="5" />
     </property>
 
-    <property name="minValue">
-      <column name="MINVALUE"/>
+    <property name="minValue" type="big_decimal">
+      <column name="MINVALUE" precision="24" scale="5"/>
     </property>
 
-    <property name="maxValue">
-      <column name="MAXVALUE"/>
+    <property name="maxValue" type="big_decimal">
+      <column name="MAXVALUE" precision="24" scale="5"/>
     </property>
   </class>
 

Modified: trunk/src/org/hyperic/hq/measurement/server/session/DataManagerEJBImpl.java
===================================================================
--- trunk/src/org/hyperic/hq/measurement/server/session/DataManagerEJBImpl.java	2007-03-20 13:03:23 UTC (rev 3794)
+++ trunk/src/org/hyperic/hq/measurement/server/session/DataManagerEJBImpl.java	2007-03-20 20:19:17 UTC (rev 3795)
@@ -25,6 +25,7 @@
 
 package org.hyperic.hq.measurement.server.session;
 
+import java.math.BigDecimal;
 import java.sql.BatchUpdateException;
 import java.sql.Connection;
 import java.sql.PreparedStatement;
@@ -303,10 +304,17 @@
                 DataPoint pt = (DataPoint)i.next();
                 Integer metricId = pt.getMetricId();
                 MetricValue val = pt.getMetricValue();
+                BigDecimal bigDec;
                 
+                try {
+                    bigDec = BigDecimal.valueOf(val.getValue());
+                } catch(NumberFormatException e) {  // infinite, or NaN
+                    _log.warn("Unable to insert infinite or NaN for metric id=" + metricId);
+                    continue;
+                }
                 stmt.setInt(1, metricId.intValue());
                 stmt.setLong(2, val.getTimestamp());
-                stmt.setDouble(3, val.getValue());
+                stmt.setBigDecimal(3, bigDec);
                 stmt.addBatch();
             }
             
@@ -432,10 +440,17 @@
                 DataPoint pt = (DataPoint)i.next();
                 Integer metricId  = pt.getMetricId();
                 MetricValue val   = pt.getMetricValue();
+                BigDecimal bigDec;
                 
+                try {
+                    bigDec = BigDecimal.valueOf(val.getValue());
+                } catch(NumberFormatException e) {  // infinite, or NaN
+                    _log.warn("Unable to insert infinite or NaN for metric id=" + metricId);
+                    continue;
+                }
                 stmt.setInt(1, metricId.intValue());
                 stmt.setLong(2, val.getTimestamp());
-                stmt.setDouble(3, val.getValue());
+                stmt.setBigDecimal(3, bigDec);
                 stmt.addBatch();
             }
             

Modified: trunk/src/org/hyperic/hq/measurement/server/session/MeasurementHistData.java
===================================================================
--- trunk/src/org/hyperic/hq/measurement/server/session/MeasurementHistData.java	2007-03-20 13:03:23 UTC (rev 3794)
+++ trunk/src/org/hyperic/hq/measurement/server/session/MeasurementHistData.java	2007-03-20 20:19:17 UTC (rev 3795)
@@ -26,14 +26,15 @@
 package org.hyperic.hq.measurement.server.session;
 
 import java.io.Serializable;
+import java.math.BigDecimal;
 
 public class MeasurementHistData 
     implements Serializable 
 {
     private MeasurementDataId _id;
-    private double            _value;
-    private double            _minValue;
-    private double            _maxValue;
+    private BigDecimal            _value;
+    private BigDecimal            _minValue;
+    private BigDecimal            _maxValue;
 
     protected MeasurementHistData() {
     }
@@ -46,27 +47,27 @@
         _id = id;
     }
 
-    public double getValue() {
+    public BigDecimal getValue() {
         return _value;
     }
     
-    protected void setValue(double value) {
+    protected void setValue(BigDecimal value) {
         _value = value;
     }
 
-    public double getMinValue() {
+    public BigDecimal getMinValue() {
         return _minValue;
     }
     
-    protected void setMinValue(double minValue) {
+    protected void setMinValue(BigDecimal minValue) {
         _minValue = minValue;
     }
 
-    public double getMaxValue() {
+    public BigDecimal getMaxValue() {
         return _maxValue;
     }
     
-    protected void setMaxValue(double maxValue) {
+    protected void setMaxValue(BigDecimal maxValue) {
         _maxValue = maxValue;
     }
 

Re: [Hyperic-hq-discuss] Cant run new discovery on a windows box

[Noah S. <noa...@hy...>]

NO... you are safe for NOW.

Agents do NOT need to get UPGRADED each time you upgrade the SERVER.

Re: [Hyperic-hq-discuss] Cant run new auto-discover on HYPERIC SERVER 3.0 v296---get stack trace

[mike m. <mi...@an...>]

An upgradeto HY{PERIC server 3.02 fixed the problem...

Re: [Hyperic-hq-discuss] Cant run new discovery on a windows box

[mike m. <mi...@an...>]

A upgrade to 3.02 seems to have fixed the problem. DO i have to upgrade all the other clients NOW to 3.0.2 ????

Re: [Hyperic-hq-discuss] How to configure Hyperic to use Active Directory for LDAP Authenticatio

[Ryan M. <rm...@hy...>]

Hi Murray,

The authentication code underwent some changes recently that may be causing this. (We added Kerberos support in 3.0.2).  What version of the server are you using?

-Ryan

[Hyperic-hq-discuss] [JIRA] Commented: (HHQ-755) Unable to store very large or small values.

[Ryan M. (JIRA) <ji...@hy...>]

    [ http://jira.hyperic.com/browse/HHQ-755?page=comments#action_16024 ] 

Ryan Morgan commented on HHQ-755:
---------------------------------


I should also note the 'Sorry' error only occurs on Oracle.  On postgres there is no error message, but the data is not stored.

2007-03-20 10:15:15,300 DEBUG [org.hyperic.hq.measurement.server.session.DataManagerEJBImpl] Attempting to insert 42 points
2007-03-20 10:15:15,319 DEBUG [org.hyperic.hq.measurement.server.session.DataManagerEJBImpl] Need to deal with 0 unhandled data points (out of 0).  datasize=42
2007-03-20 10:15:15,319 DEBUG [org.hyperic.hq.measurement.server.session.DataManagerEJBImpl] Num left = 42
2007-03-20 10:15:15,319 DEBUG [org.hyperic.hq.measurement.server.session.DataManagerEJBImpl] Sending 42 data points to update
2007-03-20 10:15:15,334 DEBUG [org.hyperic.hq.measurement.server.session.DataManagerEJBImpl] Need to deal with 0 unhandled data points (out of 42)



> Unable to store very large or small values.
> -------------------------------------------
>
>          Key: HHQ-755
>          URL: http://jira.hyperic.com/browse/HHQ-755
>      Project: Hyperic HQ
>         Type: Bug

>   Components: Measurement
>     Versions: 3.0.2, 3.0.1, 3.0.0
>  Environment: Seen on both Oracle 9i and Postgres 8.2.0
>     Reporter: Ryan Morgan
>     Assignee: Jon Travis
>     Priority: Blocker
>      Fix For: 3.0.3, 3.1.0
>  Attachments: patch.txt
>
>
> Attempting to insert Double.MIN_VALUE or Double.MAX_VALUE fails on both Oracle and Postgres.  Double.MIN_VALUE is 2-1074, but I've seen this behavior on numbers in the 2-210 range.
> This is critical since any bad value could potentially cause the entire metric data batch to be thrown out.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.hyperic.com/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[Hyperic-hq-discuss] [JIRA] Updated: (HHQ-755) Unable to store very large or small values.

[Ryan M. (JIRA) <ji...@hy...>]

     [ http://jira.hyperic.com/browse/HHQ-755?page=all ]

Ryan Morgan updated HHQ-755:
----------------------------

    Attachment: patch.txt


Attach simple patch to reproduce the problem.

> Unable to store very large or small values.
> -------------------------------------------
>
>          Key: HHQ-755
>          URL: http://jira.hyperic.com/browse/HHQ-755
>      Project: Hyperic HQ
>         Type: Bug

>   Components: Measurement
>     Versions: 3.0.2, 3.0.1, 3.0.0
>  Environment: Seen on both Oracle 9i and Postgres 8.2.0
>     Reporter: Ryan Morgan
>     Assignee: Jon Travis
>     Priority: Blocker
>      Fix For: 3.0.3, 3.1.0
>  Attachments: patch.txt
>
>
> Attempting to insert Double.MIN_VALUE or Double.MAX_VALUE fails on both Oracle and Postgres.  Double.MIN_VALUE is 2-1074, but I've seen this behavior on numbers in the 2-210 range.
> This is critical since any bad value could potentially cause the entire metric data batch to be thrown out.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.hyperic.com/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[Hyperic-hq-discuss] [JIRA] Created: (HHQ-755) Unable to store very large or small values.

[Ryan M. (JIRA) <ji...@hy...>]

Unable to store very large or small values.
-------------------------------------------

         Key: HHQ-755
         URL: http://jira.hyperic.com/browse/HHQ-755
     Project: Hyperic HQ
        Type: Bug

  Components: Measurement  
    Versions: 3.0.2, 3.0.1, 3.0.0    
 Environment: Seen on both Oracle 9i and Postgres 8.2.0
    Reporter: Ryan Morgan
 Assigned to: Jon Travis 
    Priority: Blocker
     Fix For: 3.0.3, 3.1.0
 Attachments: patch.txt


Attempting to insert Double.MIN_VALUE or Double.MAX_VALUE fails on both Oracle and Postgres.  Double.MIN_VALUE is 2-1074, but I've seen this behavior on numbers in the 2-210 range.

This is critical since any bad value could potentially cause the entire metric data batch to be thrown out.




-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.hyperic.com/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Re: [Hyperic-hq-discuss] i18n problem

[zuolaw <hq...@hy...>]

Hi Heather,

Appreciated your help.
I don't know how to upload the files in this forum, will you please send email to my mailbox(mak...@gm...), I will send the files to you.

Actually I did the following:
1.Modified the /web/portal/MainLayout.jsp (It should be <html:html> rather than  <html:html locale="true">)
And add the line at the top
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
2. Modified the /web/common/Login.jsp, /web/common/Header.jsp, /web/common/Head.jsp,
Changed <%@ page language="java"> 
to
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
3. Create an new ApplicationResources_jp.properties
4. native2ascii -encoding utf-8 ApplicationResources_jp.properties /converted/ApplicationResources_jp.properties
5. Add one filter to configure the encoding of request, I will send the source code to you.

It turns out that the layout is localized, however, in some pages like RecentAlerts.jsp, it still displays ???

Thanks
Zuo

Re: [Hyperic-hq-discuss] How to scan a log file for a pattern

[Ryan M. <rm...@hy...>]

Hi Thomas,

You can do what you describe using the File service.  You can configure multiple File services, each pointing to different logs with their own regex and alerting policies.

You can create these File monitors by navigating to the platform, then select 'New Platform Service' from the tools menu in the upper right hand corner.  From the services drop down pick 'Fileserver File'.

-Ryan

[Hyperic-hq-discuss] hq r3794 - trunk/etc

[<bo...@hy...>]

Author: bob
Date: 2007-03-20 05:03:23 -0800 (Tue, 20 Mar 2007)
New Revision: 3794
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3794

Modified:
   trunk/etc/version.properties
Log:
Release 3.1.0 build #346

Modified: trunk/etc/version.properties
===================================================================
--- trunk/etc/version.properties	2007-03-20 11:36:16 UTC (rev 3793)
+++ trunk/etc/version.properties	2007-03-20 13:03:23 UTC (rev 3794)
@@ -1,3 +1,3 @@
-#Mon Mar 19 05:00:11 PDT 2007
+#Tue Mar 20 05:01:29 PDT 2007
 version=3.1.0
-build=345
+build=346

[Hyperic-hq-discuss] hq r3793 - branches/HQ_3_0/etc

[<bo...@hy...>]

Author: bob
Date: 2007-03-20 03:36:16 -0800 (Tue, 20 Mar 2007)
New Revision: 3793
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3793

Modified:
   branches/HQ_3_0/etc/version.properties
Log:
Release 3.0.3 build #347

Modified: branches/HQ_3_0/etc/version.properties
===================================================================
--- branches/HQ_3_0/etc/version.properties	2007-03-20 00:36:15 UTC (rev 3792)
+++ branches/HQ_3_0/etc/version.properties	2007-03-20 11:36:16 UTC (rev 3793)
@@ -1,3 +1,3 @@
-#Mon Mar 19 04:10:51 PDT 2007
+#Tue Mar 20 04:09:15 PDT 2007
 version=3.0.3
-build=346
+build=347

[Hyperic-hq-discuss] Oracle up/down monitoring

[Thomas J. <tho...@tr...>]

Hello

I would like to get an alert from Oracle when the database goes down and a clear of the alert when it comes up again.

I can monitor the availability != 100 % . This does work when the database goes first down. But even if it comes up again the availability is obviously not 100% anymore. 

But I am still interested to know that at least my database is back again. How can I solve this?

Thanks for your answers.

Thomas

Re: [Hyperic-hq-discuss] How to scan a log file for a pattern

[Thomas J. <tho...@tr...>]

Hi

Thanks for the answer ... it works as described ...

But I would prefer something more configurable, particularily for the patterns. 

What I am thinking of is something, that I can configure per file I want to track inlcude and exclude patterns.

With Oracle, particularly some additional products such as OAS etc. I have numrous log files to scan. And when I have all to include in one configuration together with the syslog, this becomes quite crowded and difficult to maintain.

So is this the only way to do log file monitoring ... (well except maybe writing a script) ?

Thanks.

Thomas

Re: [Hyperic-hq-discuss] Metric in own Plugin collected only once

[<ale...@pc...>]

Perlscript

Re: [Hyperic-hq-discuss] Metric in own Plugin collected only once

[<ale...@pc...>]

I think I know what exactly is the problem. If I place a command like ps in the backticks in my perlscript, that command gets executed and I can work with the output in my perlscript. If I replace that command with

./cl_test --ConnectionSettings \"nxuc1nyuv733c9b051cv5d\"
 \"DIRECT_CONNECTION\" \"\" \"\" 0 \"\" \"PROXY_UNKNOWN\" --TestConnectionEstabl
ishment 0"

that app doesn't get executed. But it does get executed if I invoke the perlscript by myself. Only If I start It through a plugin the backticks aren't executed ( the perlscript itself does). 
I also tried using the absolute Path which also didn't work.
Also permission issues can't be the problem. Any Idea's?

[Hyperic-hq-discuss] Answer Questions! Win Fabulous Prizes!

[John M. W. <joh...@hy...>]

Greetings,

As you may have noticed, every user of our forums as a tiny icon next to their user name. For Hyperic employees, or Hypericans, it's the "H" logo. For everyone else, you'll see one of 6 icons, although at this point, everyone probably has the same one. 

This is part of our new points for rewards program, where you get credit for answering forum questions. And if you do something really special, like contribute a plugin, patch, or HOWTO document, we'll assign you special bonus points... and you get a little gold star!! Ok, not really, unless you just really want one ;)

So here's how the points work - you get 5 points for a "helpful" answer, and you get 10 points for a "correct" answer. Note that whoever asks a question gets to pick which answers are helpful or correct, so you might want to be nice to those who ask questions. Those who qualify as special contributors, get 25 points assigned per contribution, although we reserve the right to assign more to those contributions of the highest quality.

There are 6 levels to which you may aspire:

1. Newbie - 0 - 5 points
2. Rookie - 6 - 50 points
3. Pro - 51 - 250 points
4. Champion - 251 - 750 points
5. Expert - 751 - 2000 points
6. Guru - 2001 + 

Swag rewards start at the "Champion" level - a newly designed t-shirt, not yet available in stores. Here's the FAQ: http://www.hyperic.com/resources/rewards-faq.html

Enjoy,
John Mark
Community Manager

Re: [Hyperic-hq-discuss] Group can only be in a single role?

[Murray B. <hq-...@hy...>]

Charles,

Thanks. The workaround is okay. I have managed to add the group to both roles now.

Thanks . . . Murray