Log **** Re: Error while doing run-install

[Abhijeet Pandey]

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
<[hidden email]>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

[BJ Freeman]

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
> <[hidden email]>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]

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
>> <[hidden email]>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]

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 <[hidden email]> 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
> >> <[hidden email]>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

[BJ Freeman]

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 <[hidden email]> 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
>>>> <[hidden email]>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.