you have run this more than once I assume check the db to see if it has data in the table dbo.INVENTORY_ITEM if so you need to do a clean. or you can just let it complete and see if you have demo data.
BJ Freeman sent the following on 8/7/2009 2:32 AM: > this error looks like you need to clean your DB. > duplicate key row in object 'dbo.INVENTORY_ITEM' with unique index >> 'INVITEM_SOFID'.)). Rolling back transaction. > > Abhijeet Pandey sent the following on 8/7/2009 2:07 AM: >> Hi, >> >> pasting first few lines of log --> >> >> It is giving "Cannot insert duplicate key row in object" , i wonder how it >> is getting duplicate data when i am using fresh DB. >> >> >> >> Entity: InventoryItemDetail >> >> 2009-08-07 12:06:24,187 (main) [ EntityEcaRule.java:117:INFO ] Running >> Entity ECA Service: updateSerializedInventoryTotals, triggered by rule on >> Entity: InventoryItem >> >> 2009-08-07 12:06:24,202 (main) [ ServiceDispatcher.java:586:INFO ] Sync >> service [entity-default/updateInventoryItemFromDetail] finished in [109] >> milliseconds >> >> 2009-08-07 12:06:24,218 (main) [ GenericDelegator.java:843:ERROR] >> >> ---- exception report >> ---------------------------------------------------------- >> Failure in create operation for entity [InventoryItem]: >> org.ofbiz.entity.GenericEntityException: Error while inserting: >> [GenericEntity:InventoryItem][createdStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][createdTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][facilityId,WebStoreWarehouse(java.lang.String)][inventoryItemId,9001(java.lang.String)][inventoryItemTypeId,NON_SERIAL_INV_ITEM(java.lang.String)][lastUpdatedStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][lastUpdatedTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][locationSeqId,TLTLTLLL01(java.lang.String)][ownerPartyId,Company(java.lang.String)][productId,GZ-2644(java.lang.String)][unitCost,2.5(java.math.BigDecimal)] >> (SQL Exception while executing the following:INSERT INTO dbo.INVENTORY_ITEM >> (INVENTORY_ITEM_ID, INVENTORY_ITEM_TYPE_ID, PRODUCT_ID, PARTY_ID, >> OWNER_PARTY_ID, STATUS_ID, DATETIME_RECEIVED, DATETIME_MANUFACTURED, >> EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, UOM_ID, BIN_NUMBER, >> LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL, >> AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE, >> SERIAL_NUMBER, SOFT_IDENTIFIER, ACTIVATION_NUMBER, ACTIVATION_VALID_THRU, >> UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, >> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert >> duplicate key row in object 'dbo.INVENTORY_ITEM' with unique index >> 'INVITEM_SOFID'.)). Rolling back transaction. >> Exception: org.ofbiz.entity.GenericEntityException >> Message: Error while inserting: >> [GenericEntity:InventoryItem][createdStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][createdTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][facilityId,WebStoreWarehouse(java.lang.String)][inventoryItemId,9001(java.lang.String)][inventoryItemTypeId,NON_SERIAL_INV_ITEM(java.lang.String)][lastUpdatedStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][lastUpdatedTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][locationSeqId,TLTLTLLL01(java.lang.String)][ownerPartyId,Company(java.lang.String)][productId,GZ-2644(java.lang.String)][unitCost,2.5(java.math.BigDecimal)] >> (SQL Exception while executing the following:INSERT INTO dbo.INVENTORY_ITEM >> (INVENTORY_ITEM_ID, INVENTORY_ITEM_TYPE_ID, PRODUCT_ID, PARTY_ID, >> OWNER_PARTY_ID, STATUS_ID, DATETIME_RECEIVED, DATETIME_MANUFACTURED, >> EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, UOM_ID, BIN_NUMBER, >> LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL, >> AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE, >> SERIAL_NUMBER, SOFT_IDENTIFIER, ACTIVATION_NUMBER, ACTIVATION_VALID_THRU, >> UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, >> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert >> duplicate key row in object 'dbo.INVENTORY_ITEM' with unique index >> 'INVITEM_SOFID'.)) >> ---- cause >> --------------------------------------------------------------------- >> Exception: org.ofbiz.entity.GenericDataSourceException >> Message: SQL Exception while executing the following:INSERT INTO >> dbo.INVENTORY_ITEM (INVENTORY_ITEM_ID, INVENTORY_ITEM_TYPE_ID, PRODUCT_ID, >> PARTY_ID, OWNER_PARTY_ID, STATUS_ID, DATETIME_RECEIVED, >> DATETIME_MANUFACTURED, EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, >> UOM_ID, BIN_NUMBER, LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL, >> AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE, >> SERIAL_NUMBER, SOFT_IDENTIFIER, ACTIVATION_NUMBER, ACTIVATION_VALID_THRU, >> UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, >> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert >> duplicate key row in object 'dbo.INVENTORY_ITEM' with unique index >> 'INVITEM_SOFID'.) >> ---- cause >> --------------------------------------------------------------------- >> Exception: com.microsoft.sqlserver.jdbc.SQLServerException >> Message: Cannot insert duplicate key row in object 'dbo.INVENTORY_ITEM' with >> unique index 'INVITEM_SOFID'. >> ---- stack trace >> --------------------------------------------------------------- >> com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key >> row in object 'dbo.INVENTORY_ITEM' with unique index 'INVITEM_SOFID'. >> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source) >> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown >> Source) >> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) >> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) >> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:429) >> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:165) >> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111) >> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) >> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:821) >> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1453) >> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:284) >> org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:421) >> javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source) >> javolution.xml.sax.XMLReaderImpl.parse(Unknown Source) >> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:260) >> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:220) >> org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:216) >> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:380) >> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101) >> org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) >> org.ofbiz.base.start.Start.startServer(Start.java:322) >> org.ofbiz.base.start.Start.start(Start.java:326) >> org.ofbiz.base.start.Start.main(Start.java:409) >> -------------------------------------------------------------------------------- >> >> >> 2009-08-07 12:06:24,218 (main) [ TransactionUtil.java:322:WARN ] >> >> ---- exception report >> ---------------------------------------------------------- >> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this >> stack trace shows where this is happening: >> Exception: java.lang.Exception >> Message: Failure in create operation for entity [InventoryItem]: >> org.ofbiz.entity.GenericEntityException: Error while inserting: >> [GenericEntity:InventoryItem][createdStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][createdTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][facilityId,WebStoreWarehouse(java.lang.String)][inventoryItemId,9001(java.lang.String)][inventoryItemTypeId,NON_SERIAL_INV_ITEM(java.lang.String)][lastUpdatedStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][lastUpdatedTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][locationSeqId,TLTLTLLL01(java.lang.String)][ownerPartyId,Company(java.lang.String)][productId,GZ-2644(java.lang.String)][unitCost,2.5(java.math.BigDecimal)] >> (SQL Exception while executing the following:INSERT INTO dbo.INVENTORY_ITEM >> (INVENTORY_ITEM_ID, INVENTORY_ITEM_TYPE_ID, PRODUCT_ID, PARTY_ID, >> OWNER_PARTY_ID, STATUS_ID, DATETIME_RECEIVED, DATETIME_MANUFACTURED, >> EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, UOM_ID, BIN_NUMBER, >> LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL, >> AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE, >> SERIAL_NUMBER, SOFT_IDENTIFIER, ACTIVATION_NUMBER, ACTIVATION_VALID_THRU, >> UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, >> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert >> duplicate key row in object 'dbo.INVENTORY_ITEM' with unique index >> 'INVITEM_SOFID'.)). Rolling back transaction. >> ---- stack trace >> --------------------------------------------------------------- >> java.lang.Exception: Failure in create operation for entity [InventoryItem]: >> org.ofbiz.entity.GenericEntityException: Error while inserting: >> [GenericEntity:InventoryItem][createdStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][createdTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][facilityId,WebStoreWarehouse(java.lang.String)][inventoryItemId,9001(java.lang.String)][inventoryItemTypeId,NON_SERIAL_INV_ITEM(java.lang.String)][lastUpdatedStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][lastUpdatedTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][locationSeqId,TLTLTLLL01(java.lang.String)][ownerPartyId,Company(java.lang.String)][productId,GZ-2644(java.lang.String)][unitCost,2.5(java.math.BigDecimal)] >> (SQL Exception while executing the following:INSERT INTO dbo.INVENTORY_ITEM >> (INVENTORY_ITEM_ID, INVENTORY_ITEM_TYPE_ID, PRODUCT_ID, PARTY_ID, >> OWNER_PARTY_ID, STATUS_ID, DATETIME_RECEIVED, DATETIME_MANUFACTURED, >> EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, UOM_ID, BIN_NUMBER, >> LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL, >> AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE, >> SERIAL_NUMBER, SOFT_IDENTIFIER, ACTIVATION_NUMBER, ACTIVATION_VALID_THRU, >> UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, >> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert >> duplicate key row in object 'dbo.INVENTORY_ITEM' with unique index >> 'INVITEM_SOFID'.)). Rolling back transaction. >> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322) >> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269) >> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:846) >> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1453) >> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:284) >> org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:421) >> javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source) >> javolution.xml.sax.XMLReaderImpl.parse(Unknown Source) >> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:260) >> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:220) >> org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:216) >> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:380) >> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101) >> org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) >> org.ofbiz.base.start.Start.startServer(Start.java:322) >> org.ofbiz.base.start.Start.start(Start.java:326) >> org.ofbiz.base.start.Start.main(Start.java:409) >> -------------------------------------------------------------------------------- >> >> >> 2009-08-07 12:06:24,218 (main) [ GenericDelegator.java:1487:ERROR] >> >> ---- exception report >> ---------------------------------------------------------- >> Failure in storeAll operation: org.ofbiz.entity.GenericEntityException: >> Error while inserting: [GenericEntity:InventoryItem][createdStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][createdTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][facilityId,WebStoreWarehouse(java.lang.String)][inventoryItemId,9001(java.lang.String)][inventoryItemTypeId,NON_SERIAL_INV_ITEM(java.lang.String)][lastUpdatedStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][lastUpdatedTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][locationSeqId,TLTLTLLL01(java.lang.String)][ownerPartyId,Company(java.lang.String)][productId,GZ-2644(java.lang.String)][unitCost,2.5(java.math.BigDecimal)] >> (SQL Exception while executing the following:INSERT INTO dbo.INVENTORY_ITEM >> (INVENTORY_ITEM_ID, INVENTORY_ITEM_TYPE_ID, PRODUCT_ID, PARTY_ID, >> OWNER_PARTY_ID, STATUS_ID, DATETIME_RECEIVED, DATETIME_MANUFACTURED, >> EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, UOM_ID, BIN_NUMBER, >> LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL, >> AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE, >> SERIAL_NUMBER, SOFT_IDENTIFIER, ACTIVATION_NUMBER, ACTIVATION_VALID_THRU, >> UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, >> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert >> duplicate key row in object 'dbo.INVENTORY_ITEM' with unique index >> 'INVITEM_SOFID'.)). Rolling back transaction. >> Exception: org.ofbiz.entity.GenericEntityException >> Message: Error while inserting: >> [GenericEntity:InventoryItem][createdStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][createdTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][facilityId,WebStoreWarehouse(java.lang.String)][inventoryItemId,9001(java.lang.String)][inventoryItemTypeId,NON_SERIAL_INV_ITEM(java.lang.String)][lastUpdatedStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][lastUpdatedTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][locationSeqId,TLTLTLLL01(java.lang.String)][ownerPartyId,Company(java.lang.String)][productId,GZ-2644(java.lang.String)][unitCost,2.5(java.math.BigDecimal)] >> (SQL Exception while executing the following:INSERT INTO dbo.INVENTORY_ITEM >> (INVENTORY_ITEM_ID, INVENTORY_ITEM_TYPE_ID, PRODUCT_ID, PARTY_ID, >> OWNER_PARTY_ID, STATUS_ID, DATETIME_RECEIVED, DATETIME_MANUFACTURED, >> EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, UOM_ID, BIN_NUMBER, >> LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL, >> AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE, >> SERIAL_NUMBER, SOFT_IDENTIFIER, ACTIVATION_NUMBER, ACTIVATION_VALID_THRU, >> UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, >> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert >> duplicate key row in object 'dbo.INVENTORY_ITEM' with unique index >> 'INVITEM_SOFID'.)) >> ---- cause >> --------------------------------------------------------------------- >> Exception: org.ofbiz.entity.GenericDataSourceException >> Message: SQL Exception while executing the following:INSERT INTO >> dbo.INVENTORY_ITEM (INVENTORY_ITEM_ID, INVENTORY_ITEM_TYPE_ID, PRODUCT_ID, >> PARTY_ID, OWNER_PARTY_ID, STATUS_ID, DATETIME_RECEIVED, >> DATETIME_MANUFACTURED, EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, >> UOM_ID, BIN_NUMBER, LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL, >> AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE, >> SERIAL_NUMBER, SOFT_IDENTIFIER, ACTIVATION_NUMBER, ACTIVATION_VALID_THRU, >> UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, >> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert >> duplicate key row in object 'dbo.INVENTORY_ITEM' with unique index >> 'INVITEM_SOFID'.) >> ---- cause >> --------------------------------------------------------------------- >> Exception: com.microsoft.sqlserver.jdbc.SQLServerException >> Message: Cannot insert duplicate key row in object 'dbo.INVENTORY_ITEM' with >> unique index 'INVITEM_SOFID'. >> ---- stack trace >> --------------------------------------------------------------- >> com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key >> row in object 'dbo.INVENTORY_ITEM' with unique index 'INVITEM_SOFID'. >> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source) >> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown >> Source) >> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) >> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) >> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:429) >> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:165) >> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111) >> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) >> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:821) >> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1453) >> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:284) >> org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:421) >> javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source) >> javolution.xml.sax.XMLReaderImpl.parse(Unknown Source) >> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:260) >> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:220) >> org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:216) >> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:380) >> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101) >> org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) >> org.ofbiz.base.start.Start.startServer(Start.java:322) >> org.ofbiz.base.start.Start.start(Start.java:326) >> org.ofbiz.base.start.Start.main(Start.java:409) >> -------------------------------------------------------------------------------- >> >> >> 2009-08-07 12:06:24,218 (main) [ TransactionUtil.java:326:INFO ] >> [TransactionUtil.setRollbackOnly] transaction rollback only not set, >> rollback only is already set. >> >> 2009-08-07 12:06:24,234 (main) [ EntitySaxReader.java:432:ERROR] >> >> ---- exception report >> ---------------------------------------------------------- >> Error storing value >> Exception: org.ofbiz.entity.GenericEntityException >> Message: Error while inserting: >> [GenericEntity:InventoryItem][createdStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][createdTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][facilityId,WebStoreWarehouse(java.lang.String)][inventoryItemId,9001(java.lang.String)][inventoryItemTypeId,NON_SERIAL_INV_ITEM(java.lang.String)][lastUpdatedStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][lastUpdatedTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][locationSeqId,TLTLTLLL01(java.lang.String)][ownerPartyId,Company(java.lang.String)][productId,GZ-2644(java.lang.String)][unitCost,2.5(java.math.BigDecimal)] >> (SQL Exception while executing the following:INSERT INTO dbo.INVENTORY_ITEM >> (INVENTORY_ITEM_ID, INVENTORY_ITEM_TYPE_ID, PRODUCT_ID, PARTY_ID, >> OWNER_PARTY_ID, STATUS_ID, DATETIME_RECEIVED, DATETIME_MANUFACTURED, >> EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, UOM_ID, BIN_NUMBER, >> LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL, >> AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE, >> SERIAL_NUMBER, SOFT_IDENTIFIER, ACTIVATION_NUMBER, ACTIVATION_VALID_THRU, >> UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, >> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert >> duplicate key row in object 'dbo.INVENTORY_ITEM' with unique index >> 'INVITEM_SOFID'.)) >> ---- cause >> --------------------------------------------------------------------- >> Exception: org.ofbiz.entity.GenericDataSourceException >> Message: SQL Exception while executing the following:INSERT INTO >> dbo.INVENTORY_ITEM (INVENTORY_ITEM_ID, INVENTORY_ITEM_TYPE_ID, PRODUCT_ID, >> PARTY_ID, OWNER_PARTY_ID, STATUS_ID, DATETIME_RECEIVED, >> DATETIME_MANUFACTURED, EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, >> UOM_ID, BIN_NUMBER, LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL, >> AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE, >> SERIAL_NUMBER, SOFT_IDENTIFIER, ACTIVATION_NUMBER, ACTIVATION_VALID_THRU, >> UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, >> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert >> duplicate key row in object 'dbo.INVENTORY_ITEM' with unique index >> 'INVITEM_SOFID'.) >> ---- cause >> --------------------------------------------------------------------- >> Exception: com.microsoft.sqlserver.jdbc.SQLServerException >> Message: Cannot insert duplicate key row in object 'dbo.INVENTORY_ITEM' with >> unique index 'INVITEM_SOFID'. >> ---- stack trace >> --------------------------------------------------------------- >> com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key >> row in object 'dbo.INVENTORY_ITEM' with unique index 'INVITEM_SOFID'. >> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source) >> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown >> Source) >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown >> Source) >> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) >> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) >> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:429) >> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:165) >> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111) >> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) >> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:821) >> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1453) >> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:284) >> org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:421) >> javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source) >> javolution.xml.sax.XMLReaderImpl.parse(Unknown Source) >> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:260) >> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:220) >> org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:216) >> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:380) >> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101) >> org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) >> org.ofbiz.base.start.Start.startServer(Start.java:322) >> org.ofbiz.base.start.Start.start(Start.java:326) >> org.ofbiz.base.start.Start.main(Start.java:409) >> -------------------------------------------------------------------------------- >> >> >> 2009-08-07 12:06:24,234 (main) [ EntitySaxReader.java:269:ERROR] >> >> ---- exception report >> ---------------------------------------------------------- >> An error occurred saving the data, rolling back transaction (true) >> Exception: org.xml.sax.SAXException >> Message: Error storing value >> ---- stack trace >> --------------------------------------------------------------- >> org.ofbiz.entity.GenericEntityException: Error while inserting: >> [GenericEntity:InventoryItem][createdStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][createdTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][facilityId,WebStoreWarehouse(java.lang.String)][inventoryItemId,9001(java.lang.String)][inventoryItemTypeId,NON_SERIAL_INV_ITEM(java.lang.String)][lastUpdatedStamp,2009-08-07 >> 12:06:24.202(java.sql.Timestamp)][lastUpdatedTxStamp,2009-08-07 >> 12:06:13.544(java.sql.Timestamp)][locationSeqId,TLTLTLLL01(java.lang.String)][ownerPartyId,Company(java.lang.String)][productId,GZ-2644(java.lang.String)][unitCost,2.5(java.math.BigDecimal)] >> (SQL Exception while executing the following:INSERT INTO dbo.INVENTORY_ITEM >> (INVENTORY_ITEM_ID, INVENTORY_ITEM_TYPE_ID, PRODUCT_ID, PARTY_ID, >> OWNER_PARTY_ID, STATUS_ID, DATETIME_RECEIVED, DATETIME_MANUFACTURED, >> EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, UOM_ID, BIN_NUMBER, >> LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL, >> AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE, >> SERIAL_NUMBER, SOFT_IDENTIFIER, ACTIVATION_NUMBER, ACTIVATION_VALID_THRU, >> UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, >> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert >> duplicate key row in object 'dbo.INVENTORY_ITEM' with unique index >> 'INVITEM_SOFID'.)) >> org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:433) >> javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source) >> javolution.xml.sax.XMLReaderImpl.parse(Unknown Source) >> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:260) >> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:220) >> org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:216) >> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:380) >> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101) >> org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) >> org.ofbiz.base.start.Start.startServer(Start.java:322) >> org.ofbiz.base.start.Start.start(Start.java:326) >> org.ofbiz.base.start.Start.main(Start.java:409) >> -------------------------------------------------------------------------------- >> >> >> 2009-08-07 12:06:24,234 (main) [ TransactionUtil.java:286:ERROR] >> >> ---- exception report >> ---------------------------------------------------------- >> [TransactionUtil.rollback] >> Exception: java.lang.Exception >> Message: Stack Trace >> ---- stack trace >> --------------------------------------------------------------- >> java.lang.Exception: Stack Trace >> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285) >> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267) >> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:270) >> >> >> >> >> On Fri, Aug 7, 2009 at 2:17 PM, Carsten Schinzer >> <c.schin...@googlemail.com>wrote: >> >>> Your attachment is being deleted (I can't see it on the mailing list). >>> >>> Please go through the log carefully, it is very verbose about data load >>> issues. So there would definitely be an indication. >>> >>> Check your logfile for the first occurrence of "ERROR" and what it sais. If >>> it is really an issue with the data load, there should be occurencies of >>> "GenericEntityException". >>> >>> You say you are using MS SQL Server and that has tables created ... is it >>> specific to your SQL Server setup? Tablespace limited, other capacity >>> limitations? I am guessing this. The logfile should definitely give you >>> good >>> hints of what to check. So please do that homework first. >>> >>> Kind regards >>> >>> >>> Carsten >>> >> >> > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator.
