if you pass a value of infinity (Double.POSITIVE_INFINITY) you get an error like this Note that averageCost,Infinity is being converted to "1.#INF" for the Postgres db (Using Postgres 8.2):
org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:InventorySoldSummary][aceptblAverage,0.0(java.lang.Double)][a cptblMths,12(java.lang.Long)][averageCost,Infinity(java.lang.Double)][avgSal esPrice,Infinity(java.lang.Double)][avgShipDays,2.0(java.lang.Double)][creat edStamp,2008-03-19 19:17:14.984(java.sql.Timestamp)][createdTxStamp,2008-03-19 19:17:14.984(java.sql.Timestamp)][enumId,EOQ_NOT_SOLD(java.lang.String)][fac ilityId,NT-Kent(java.lang.String)][lastUpdatedStamp,2008-03-19 19:17:14.984(java.sql.Timestamp)][lastUpdatedTxStamp,2008-03-19 19:17:14.984(java.sql.Timestamp)][month1,0.0(java.lang.Double)][month10,0.0( java.lang.Double)][month11,0.0(java.lang.Double)][month12,0.0(java.lang.Doub le)][month2,0.0(java.lang.Double)][month3,0.0(java.lang.Double)][month4,0.0( java.lang.Double)][month5,0.0(java.lang.Double)][month6,0.0(java.lang.Double )][month7,0.0(java.lang.Double)][month8,0.0(java.lang.Double)][month9,0.0(ja va.lang.Double)][newestSaleDays,153(java.lang.Long)][normMth1,0.0(java.lang. Double)][normMth10,0.0(java.lang.Double)][normMth11,0.0(java.lang.Double)][n ormMth12,0.0(java.lang.Double)][normMth2,0.0(java.lang.Double)][normMth3,0.0 (java.lang.Double)][normMth4,0.0(java.lang.Double)][normMth5,0.0(java.lang.D ouble)][normMth6,0.0(java.lang.Double)][normMth7,0.0(java.lang.Double)][norm Mth8,0.0(java.lang.Double)][normMth9,0.0(java.lang.Double)][numberofsales,2( java.lang.Long)][oldestSaleDays,153(java.lang.Long)][productId,BE22461580A15 (java.lang.String)][qtrWeightAvg,0.0(java.lang.Double)][qtyToOrder,0.0(java. lang.Double)][quantityAverage,0.0(java.lang.Double)][quantityMax,1.0(java.la ng.Double)][quantityMin,-1.0(java.lang.Double)][quantityTotal,0.0(java.lang. Double)][recommended,0.0(java.lang.Double)][stdDeviation,1.0(java.lang.Doubl e)][supplierPartyId,SHOP(java.lang.String)][weightAvgQty,0.0(java.lang.Doubl e)] (SQL Exception while executing the following:INSERT INTO public.INVENTORY_SOLD_SUMMARY (PRODUCT_ID, FACILITY_ID, SUPPLIER_PARTY_ID, QUANTITY_TOTAL, ACPTBL_MTHS, QUANTITY_MIN, QUANTITY_MAX, ACEPTBL_AVERAGE, WEIGHT_AVG_QTY, QTR_WEIGHT_AVG, QUANTITY_AVERAGE, STD_DEVIATION, RECOMMENDED, QTY_TO_ORDER, AVAILABLE, QTY_BACK_ORDERED, AVERAGE_COST, AVG_SALES_PRICE, NUMBEROFSALES, OLDEST_SALE_DAYS, NEWEST_SALE_DAYS, AVG_SHIP_DAYS, MONTH1, MONTH2, MONTH3, MONTH4, MONTH5, MONTH6, MONTH7, MONTH8, MONTH9, MONTH10, MONTH11, MONTH12, NORM_MTH1, NORM_MTH2, NORM_MTH3, NORM_MTH4, NORM_MTH5, NORM_MTH6, NORM_MTH7, NORM_MTH8, NORM_MTH9, NORM_MTH10, NORM_MTH11, NORM_MTH12, ENUM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: invalid input syntax for type numeric: "1.#INF")) Works fine for localderby. I fixed this in this instance by passing -1.00 which has no valid value for this case, but it looks like a bug to me because I can imagine the need to store infinity. Skip No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1333 - Release Date: 3/18/2008 8:10 AM
