2016-04-24 17:40:33,327 ERROR [Thread-9] [org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl:178] unable to add new item:[MetricsDoubleTypeDevice(sensorVariable=SensorVariable(id=12, sensor=Sensor(id=8, sensorId=2, type=S_WIND, name=Backyard Wind, lastSeen=1461540990447, node=Node(id=3, eui=4, gatewayTable=GatewayTable(id=1, enabled=true, name=MySensors Serial, networkType=MY_SENSORS, timestamp=null, state=UP, statusMessage=Connected Successfully, statusSince=1461541232047, type=SERIAL, properties={br=115200, rdr=jSerialComm, rf=120, dr=Auto, pn=/dev/cu.usbserial-AH02JYNJ}), name=OutdoorRelay, version=1.0, type=S_ARDUINO_REPEATER_NODE, libVersion=1.5.4, batteryLevel=null, eraseConfig=null, firmware=null, state=DOWN, lastSeen=1461459349784, rssi=null, otherData=null), room=null, variableTypes=[Temperature, Wind]), variableType=V_TEMP, metricType=DOUBLE, timestamp=1461541233322, value=null, previousValue=0.8, unit=°C), timestamp=1461541233323, samples=1, min=null, max=null, avg=null, aggregationType=RAW, timestampFrom=null, timestampTo=null)]
java.sql.SQLException: Unable to run insert stmt on object MetricsDoubleTypeDevice(sensorVariable=SensorVariable(id=12, sensor=Sensor(id=8, sensorId=2, type=S_WIND, name=Backyard Wind, lastSeen=1461540990447, node=Node(id=3, eui=4, gatewayTable=GatewayTable(id=1, enabled=true, name=MySensors Serial, networkType=MY_SENSORS, timestamp=null, state=UP, statusMessage=Connected Successfully, statusSince=1461541232047, type=SERIAL, properties={br=115200, rdr=jSerialComm, rf=120, dr=Auto, pn=/dev/cu.usbserial-AH02JYNJ}), name=OutdoorRelay, version=1.0, type=S_ARDUINO_REPEATER_NODE, libVersion=1.5.4, batteryLevel=null, eraseConfig=null, firmware=null, state=DOWN, lastSeen=1461459349784, rssi=null, otherData=null), room=null, variableTypes=[Temperature, Wind]), variableType=V_TEMP, metricType=DOUBLE, timestamp=1461541233322, value=null, previousValue=0.8, unit=°C), timestamp=1461541233323, samples=1, min=null, max=null, avg=null, aggregationType=RAW, timestampFrom=null, timestampTo=null): INSERT INTO `metrics_double_type_device` (`sensorVariableId` ,`timestamp` ,`samples` ,`min` ,`max` ,`avg` ,`aggregationType` ) VALUES (?,?,?,?,?,?,?)
        at com.j256.ormlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:22) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at com.j256.ormlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:135) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at com.j256.ormlite.stmt.StatementExecutor.create(StatementExecutor.java:450) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at com.j256.ormlite.dao.BaseDaoImpl.create(BaseDaoImpl.java:310) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl.create(BaseAbstractDaoImpl.java:175) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.mycontroller.standalone.message.McMessageEngine.recordSetTypeData(McMessageEngine.java:692) [mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.mycontroller.standalone.message.McMessageEngine.execute(McMessageEngine.java:99) [mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.mycontroller.standalone.message.McMessageEngine.run(McMessageEngine.java:805) [mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65]
Caused by: org.h2.jdbc.JdbcSQLException: NULL not allowed for column "AVG"; SQL statement:
INSERT INTO `metrics_double_type_device` (`sensorVariableId` ,`timestamp` ,`samples` ,`min` ,`max` ,`avg` ,`aggregationType` ) VALUES (?,?,?,?,?,?,?) [23502-176]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.h2.message.DbException.get(DbException.java:178) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.h2.message.DbException.get(DbException.java:154) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.h2.table.Column.validateConvertUpdateSequence(Column.java:308) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.h2.table.Table.validateConvertUpdateSequence(Table.java:726) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.h2.command.dml.Insert.insertRows(Insert.java:152) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.h2.command.dml.Insert.update(Insert.java:115) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.h2.command.CommandContainer.update(CommandContainer.java:79) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.h2.command.Command.executeUpdate(Command.java:254) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:158) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:144) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at com.j256.ormlite.jdbc.JdbcDatabaseConnection.insert(JdbcDatabaseConnection.java:170) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        at com.j256.ormlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:91) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
        ... 7 common frames omitted