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 <[email protected]>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 > -- Abhijeet Pandey
