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

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

    [ 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