Hi Si, I just tried a brand new install on a seperate box (my dev machine). I downloaded the OpenTaps version 424208 as you recommended. Here is the configuration:
Win XP Java SDK 1.4.2_04 MySQL 5.0.22 MySQL JDBC driver 3.1.13 I'm wondering if the problem is with the JDBC driver. What version are you using? I'm going to try again with a different version verion of the driver. Any other thoughts? Thanks, John Here is the full exception from the logfile: ---- exception report ---------------------------------------------------------- Failure in create operation for entity [UomConversion]: org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)] (while inserting: [GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)] (SQL Exception while executing the following:INSERT INTO UOM_CONVERSION (UOM_ID, UOM_ID_TO, CONVERSION_FACTOR, CUSTOM_METHOD_ID, DECIMAL_SCALE, ROUNDING_MODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data truncated for column 'CONVERSION_FACTOR' at row 1))). Rolling back transaction. Exception: org.ofbiz.entity.GenericEntityException Message: Exception while inserting the following entity: [GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)] (while inserting: [GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)] (SQL Exception while executing the following:INSERT INTO UOM_CONVERSION (UOM_ID, UOM_ID_TO, CONVERSION_FACTOR, CUSTOM_METHOD_ID, DECIMAL_SCALE, ROUNDING_MODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data truncated for column 'CONVERSION_FACTOR' at row 1))) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)] (while inserting: [GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)] (SQL Exception while executing the following:INSERT INTO UOM_CONVERSION (UOM_ID, UOM_ID_TO, CONVERSION_FACTOR, CUSTOM_METHOD_ID, DECIMAL_SCALE, ROUNDING_MODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data truncated for column 'CONVERSION_FACTOR' at row 1))) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:130) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1109) org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:266) org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:397) javolution.xml.sax.RealtimeParser.processElement(Unknown Source) javolution.xml.sax.RealtimeParser.parseContent(Unknown Source) javolution.xml.sax.RealtimeParser.parse(Unknown Source) javolution.xml.sax.RealtimeParser.parse(Unknown Source) org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:245) org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205) org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:225) org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:248) org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:80) org.ofbiz.base.start.Start.startStartLoaders(Start.java:263) org.ofbiz.base.start.Start.startServer(Start.java:314) org.ofbiz.base.start.Start.start(Start.java:318) org.ofbiz.base.start.Start.main(Start.java:404) org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26 14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26 14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)] (SQL Exception while executing the following:INSERT INTO UOM_CONVERSION (UOM_ID, UOM_ID_TO, CONVERSION_FACTOR, CUSTOM_METHOD_ID, DECIMAL_SCALE, ROUNDING_MODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data truncated for column 'CONVERSION_FACTOR' at row 1)) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:185) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1109) org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:266) org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:397) javolution.xml.sax.RealtimeParser.processElement(Unknown Source) javolution.xml.sax.RealtimeParser.parseContent(Unknown Source) javolution.xml.sax.RealtimeParser.parse(Unknown Source) javolution.xml.sax.RealtimeParser.parse(Unknown Source) org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:245) org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205) org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:225) org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:248) org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:80) org.ofbiz.base.start.Start.startStartLoaders(Start.java:263) org.ofbiz.base.start.Start.startServer(Start.java:314) org.ofbiz.base.start.Start.start(Start.java:318) org.ofbiz.base.start.Start.main(Start.java:404) org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO UOM_CONVERSION (UOM_ID, UOM_ID_TO, CONVERSION_FACTOR, CUSTOM_METHOD_ID, DECIMAL_SCALE, ROUNDING_MODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data truncated for column 'CONVERSION_FACTOR' at row 1) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:439) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:180) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1109) org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:266) org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:397) javolution.xml.sax.RealtimeParser.processElement(Unknown Source) javolution.xml.sax.RealtimeParser.parseContent(Unknown Source) javolution.xml.sax.RealtimeParser.parse(Unknown Source) javolution.xml.sax.RealtimeParser.parse(Unknown Source) org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:245) org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205) org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:225) org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:248) org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:80) org.ofbiz.base.start.Start.startStartLoaders(Start.java:263) org.ofbiz.base.start.Start.startServer(Start.java:314) org.ofbiz.base.start.Start.start(Start.java:318) org.ofbiz.base.start.Start.main(Start.java:404) com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'CONVERSION_FACTOR' at row 1 com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:709) com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3461) com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1198) com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677) com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357) com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274) com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259) org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:436) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:180) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1109) org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:266) org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:397) javolution.xml.sax.RealtimeParser.processElement(Unknown Source) javolution.xml.sax.RealtimeParser.parseContent(Unknown Source) javolution.xml.sax.RealtimeParser.parse(Unknown Source) javolution.xml.sax.RealtimeParser.parse(Unknown Source) org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:245) org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205) org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:225) org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:248) org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:80) org.ofbiz.base.start.Start.startStartLoaders(Start.java:263) org.ofbiz.base.start.Start.startServer(Start.java:314) org.ofbiz.base.start.Start.start(Start.java:318) org.ofbiz.base.start.Start.main(Start.java:404) -------------------------------------------------------------------------------- 1490663[ TransactionUtil.java:276:WARN ]
