Users - Inventory Item Detail Error

[Kyle Tippetts]

First, I'm on an older version of OFBiz -- 9/2004. However, perhaps  
someone out there can explain to me what's going on here. When I  
create an order I get this error in the log:

CreateValue.java:75 :ERROR]
---- exception report  
----------------------------------------------------------
Exception: org.ofbiz.entity.GenericEntityException
Message: Exception while inserting the following entity:  
[GenericEntity:InventoryItemDetail][createdTxStamp,2006-04-11  
14:01:05.095(java.sql.Timestamp)][inventoryItemId,10060
(java.lang.String)][orderId,SSM58110(java.lang.String)]
[inventoryItemDetailSeqId,10000(java.lang.String)]
[availableToPromiseDiff,-1.0(java.lang.Double)][lastUpdatedTxStamp,
2006-04-11 14:01:05.095(java.sql.Timestamp)][orderItemSeqId,1
(java.lang.String)][createdStamp,2006-04-11 14:01:05.095
(java.sql.Timestamp)][lastUpdatedStamp,2006-04-11 14:01:05.095
(java.sql.Timestamp)] (while inserting:  
[GenericEntity:InventoryItemDetail][createdTxStamp,2006-04-11  
14:01:05.095(java.sql.Timestamp)][inventoryItemId,10060
(java.lang.String)][orderId,SSM58110(java.lang.String)]
[inventoryItemDetailSeqId,10000(java.lang.String)]
[availableToPromiseDiff,-1.0(java.lang.Double)][lastUpdatedTxStamp,
2006-04-11 14:01:05.095(java.sql.Timestamp)][orderItemSeqId,1
(java.lang.String)][createdStamp,2006-04-11 14:01:05.095
(java.sql.Timestamp)][lastUpdatedStamp,2006-04-11 14:01:05.095
(java.sql.Timestamp)] (SQL Exception while executing the  
following:INSERT INTO public.INVENTORY_ITEM_DETAIL  
(INVENTORY_ITEM_ID, INVENTORY_ITEM_DETAIL_SEQ_ID,  
QUANTITY_ON_HAND_DIFF, AVAILABLE_TO_PROMISE_DIFF, ORDER_ID,  
ORDER_ITEM_SEQ_ID, SHIPMENT_ID, SHIPMENT_ITEM_SEQ_ID, WORK_EFFORT_ID,  
ITEM_ISSUANCE_ID, RECEIPT_ID, PHYSICAL_INVENTORY_ID,  
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,  
CREATED_TX_STAMP) VALUES  
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR:  Cannot  
insert a duplicate key into unique index pk_inventory_item_detail)))
---- stack trace  
---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Exception while inserting  
the following entity: [GenericEntity:InventoryItemDetail]
[createdTxStamp,2006-04-11 14:01:05.095(java.sql.Timestamp)]
[inventoryItemId,10060(java.lang.String)][orderId,SSM58110
(java.lang.String)][inventoryItemDetailSeqId,10000(java.lang.String)]
[availableToPromiseDiff,-1.0(java.lang.Double)][lastUpdatedTxStamp,
2006-04-11 14:01:05.095(java.sql.Timestamp)][orderItemSeqId,1
(java.lang.String)][createdStamp,2006-04-11 14:01:05.095
(java.sql.Timestamp)][lastUpdatedStamp,2006-04-11 14:01:05.095
(java.sql.Timestamp)] (while inserting:  
[GenericEntity:InventoryItemDetail][createdTxStamp,2006-04-11  
14:01:05.095(java.sql.Timestamp)][inventoryItemId,10060
(java.lang.String)][orderId,SSM58110(java.lang.String)]
[inventoryItemDetailSeqId,10000(java.lang.String)]
[availableToPromiseDiff,-1.0(java.lang.Double)][lastUpdatedTxStamp,
2006-04-11 14:01:05.095(java.sql.Timestamp)][orderItemSeqId,1
(java.lang.String)][createdStamp,2006-04-11 14:01:05.095
(java.sql.Timestamp)][lastUpdatedStamp,2006-04-11 14:01:05.095
(java.sql.Timestamp)] (SQL Exception while executing the  
following:INSERT INTO public.INVENTORY_ITEM_DETAIL  
(INVENTORY_ITEM_ID, INVENTORY_ITEM_DETAIL_SEQ_ID,  
QUANTITY_ON_HAND_DIFF, AVAILABLE_TO_PROMISE_DIFF, ORDER_ID,  
ORDER_ITEM_SEQ_ID, SHIPMENT_ID, SHIPMENT_ITEM_SEQ_ID, WORK_EFFORT_ID,  
ITEM_ISSUANCE_ID, RECEIPT_ID, PHYSICAL_INVENTORY_ID,  
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,  
CREATED_TX_STAMP) VALUES  
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR:  Cannot  
insert a duplicate key into unique index pk_inventory_item_detail)))
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:121)

I can see that it is indeed trying to insert the duplicate  
inventoryItemDetailSeqId into the InventoryItemDetal table, but I  
cannot for the life of me figure out why, or what to do to fix the  
problem. I have tried:

* adding more ATP/QOH to the Inventory Item (10060 in this case) by  
doing a physical inventory variance, but I get this same error.
* Doing an inventory receive into the Inventory Item 10060, but I get  
the same error.
* Creating a new inventory item for the product in question, but I  
get the same error.

The system keeps using inventory item 10060 no matter what, and I  
can't seem to change that.

Obviously I don't understand the relationship between product and  
inventory items and the way OFBiz models that. I've purchased the PDF  
documentation, but that relationship isn't explained there -- just  
what each field does.

Any help will be greatly appreciated.

Thanks
--Kyle
==============================
--Kyle Tippetts
--[hidden email]



 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users