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.
