what i did that i deleted the ofbiz database and then also it is throwing this error.
after deletion i did ant clean-all , then i created ofbiz db again and then i did ant run-install . what i am missing here ? it is working fine when connected to default db, also it is connecting with mssql , but it not able to load demo data and it is giving "Cannot insert duplicate key " message . Thanks, Abhijeet Pandey On Fri, Aug 7, 2009 at 3:09 PM, BJ Freeman <[email protected]> wrote: > 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 > >> <[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 > >>> > >> > >> > > > > -- > 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. > > -- Abhijeet Pandey
