ant clean-all only cleans the Derby DB it does not clean any external DB like MS-SQL. you have to use MS-SQL tools to do this. the fact it is inserting duplicate says it is already in the MS-SQL db so let it run then check a page
Abhijeet Pandey sent the following on 8/7/2009 2:54 AM: > 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 <bjf...@free-man.net> 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 >>>> <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. >> >> > > -- 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.