You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Bruno Busco (JIRA)" <ji...@apache.org> on 2008/04/01 23:35:25 UTC
[jira] Created: (OFBIZ-1734) Creating a Physical Inventory Variance
with "Integration" reason generates an exception
Creating a Physical Inventory Variance with "Integration" reason generates an exception
---------------------------------------------------------------------------------------
Key: OFBIZ-1734
URL: https://issues.apache.org/jira/browse/OFBIZ-1734
Project: OFBiz
Issue Type: Bug
Components: product
Affects Versions: SVN trunk
Environment: Win XP - LocalDerby - SVN Trunk 643479
Reporter: Bruno Busco
1) select Facility -> Facilities -> WebStoreWarehouse -> Inventory Items
2) click on first Inventory Id in the list (9005)
3) in the Physical Inventory Variance panel at the bottom of the page select "Integration" in the Variance Reason Id field
4) insert '1' in the Quantity On Hand Var
5) click on 'Add' button
the following error is shown:
The Following Errors Occurred:
Error:Error:ERROR: Could not complete the Create an InventoryItemDetail [file:/F:/ofbiz_trunk/applications/product/script/org/ofbiz/product/inventory/InventoryServices.xml#createInventoryItemDetail] process [problem creating the newEntity value: Error while inserting: [GenericEntity:InventoryItemDetail][availableToPromiseDiff,0.0(java.lang.Double)][createdStamp,2008-04-01 23:35:14.453(java.sql.Timestamp)][createdTxStamp,2008-04-01 23:35:14.343(java.sql.Timestamp)][effectiveDate,2008-04-01 23:35:14.453(java.sql.Timestamp)][inventoryItemDetailSeqId,10016(java.lang.String)][inventoryItemId,9005(java.lang.String)][lastUpdatedStamp,2008-04-01 23:35:14.453(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-01 23:35:14.343(java.sql.Timestamp)][physicalInventoryId,10016(java.lang.String)][quantityOnHandDiff,1.0(java.lang.Double)][reasonEnumId,VAR_INTEGR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVENTORY_ITEM_DETAIL (INVENTORY_ITEM_ID, INVENTORY_ITEM_DETAIL_SEQ_ID, EFFECTIVE_DATE, QUANTITY_ON_HAND_DIFF, AVAILABLE_TO_PROMISE_DIFF, UNIT_COST, ORDER_ID, ORDER_ITEM_SEQ_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_ID, SHIPMENT_ITEM_SEQ_ID, RETURN_ID, RETURN_ITEM_SEQ_ID, WORK_EFFORT_ID, FIXED_ASSET_ID, MAINT_HIST_SEQ_ID, ITEM_ISSUANCE_ID, RECEIPT_ID, PHYSICAL_INVENTORY_ID, REASON_ENUM_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVENTORY_ITEM_DETAIL' caused a violation of foreign key constraint 'INV_ITDTL_REAS' for key (VAR_INTEGR). The statement has been rolled back.))] calling service createInventoryItemDetail in createInventoryItemVariance calling service createInventoryItemVariance in createPhysicalInventoryAndVariance
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (OFBIZ-1734) Creating a Physical Inventory Variance
with "Integration" reason generates an exception
Posted by "Bilgin Ibryam (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bilgin Ibryam closed OFBIZ-1734.
--------------------------------
Resolution: Fixed
Fix Version/s: SVN trunk
Hi Bruno,
In rev644805 Jacopo fixed this bug.
Thank you for reporting.
P.S. You can ask your question on the mailing list. I also cannot see any reason for having duplicate VarianceReason data...
Bilgin
> Creating a Physical Inventory Variance with "Integration" reason generates an exception
> ---------------------------------------------------------------------------------------
>
> Key: OFBIZ-1734
> URL: https://issues.apache.org/jira/browse/OFBIZ-1734
> Project: OFBiz
> Issue Type: Bug
> Components: product
> Affects Versions: SVN trunk
> Environment: Win XP - LocalDerby - SVN Trunk 643479
> Reporter: Bruno Busco
> Fix For: SVN trunk
>
> Attachments: var_integr.patch
>
>
> 1) select Facility -> Facilities -> WebStoreWarehouse -> Inventory Items
> 2) click on first Inventory Id in the list (9005)
> 3) in the Physical Inventory Variance panel at the bottom of the page select "Integration" in the Variance Reason Id field
> 4) insert '1' in the Quantity On Hand Var
> 5) click on 'Add' button
> the following error is shown:
> The Following Errors Occurred:
> Error:Error:ERROR: Could not complete the Create an InventoryItemDetail [file:/F:/ofbiz_trunk/applications/product/script/org/ofbiz/product/inventory/InventoryServices.xml#createInventoryItemDetail] process [problem creating the newEntity value: Error while inserting: [GenericEntity:InventoryItemDetail][availableToPromiseDiff,0.0(java.lang.Double)][createdStamp,2008-04-01 23:35:14.453(java.sql.Timestamp)][createdTxStamp,2008-04-01 23:35:14.343(java.sql.Timestamp)][effectiveDate,2008-04-01 23:35:14.453(java.sql.Timestamp)][inventoryItemDetailSeqId,10016(java.lang.String)][inventoryItemId,9005(java.lang.String)][lastUpdatedStamp,2008-04-01 23:35:14.453(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-01 23:35:14.343(java.sql.Timestamp)][physicalInventoryId,10016(java.lang.String)][quantityOnHandDiff,1.0(java.lang.Double)][reasonEnumId,VAR_INTEGR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVENTORY_ITEM_DETAIL (INVENTORY_ITEM_ID, INVENTORY_ITEM_DETAIL_SEQ_ID, EFFECTIVE_DATE, QUANTITY_ON_HAND_DIFF, AVAILABLE_TO_PROMISE_DIFF, UNIT_COST, ORDER_ID, ORDER_ITEM_SEQ_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_ID, SHIPMENT_ITEM_SEQ_ID, RETURN_ID, RETURN_ITEM_SEQ_ID, WORK_EFFORT_ID, FIXED_ASSET_ID, MAINT_HIST_SEQ_ID, ITEM_ISSUANCE_ID, RECEIPT_ID, PHYSICAL_INVENTORY_ID, REASON_ENUM_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVENTORY_ITEM_DETAIL' caused a violation of foreign key constraint 'INV_ITDTL_REAS' for key (VAR_INTEGR). The statement has been rolled back.))] calling service createInventoryItemDetail in createInventoryItemVariance calling service createInventoryItemVariance in createPhysicalInventoryAndVariance
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (OFBIZ-1734) Creating a Physical Inventory
Variance with "Integration" reason generates an exception
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Le Roux reassigned OFBIZ-1734:
--------------------------------------
Assignee: Jacopo Cappellato
> Creating a Physical Inventory Variance with "Integration" reason generates an exception
> ---------------------------------------------------------------------------------------
>
> Key: OFBIZ-1734
> URL: https://issues.apache.org/jira/browse/OFBIZ-1734
> Project: OFBiz
> Issue Type: Bug
> Components: product
> Affects Versions: SVN trunk
> Environment: Win XP - LocalDerby - SVN Trunk 643479
> Reporter: Bruno Busco
> Assignee: Jacopo Cappellato
> Fix For: SVN trunk
>
> Attachments: var_integr.patch
>
>
> 1) select Facility -> Facilities -> WebStoreWarehouse -> Inventory Items
> 2) click on first Inventory Id in the list (9005)
> 3) in the Physical Inventory Variance panel at the bottom of the page select "Integration" in the Variance Reason Id field
> 4) insert '1' in the Quantity On Hand Var
> 5) click on 'Add' button
> the following error is shown:
> The Following Errors Occurred:
> Error:Error:ERROR: Could not complete the Create an InventoryItemDetail [file:/F:/ofbiz_trunk/applications/product/script/org/ofbiz/product/inventory/InventoryServices.xml#createInventoryItemDetail] process [problem creating the newEntity value: Error while inserting: [GenericEntity:InventoryItemDetail][availableToPromiseDiff,0.0(java.lang.Double)][createdStamp,2008-04-01 23:35:14.453(java.sql.Timestamp)][createdTxStamp,2008-04-01 23:35:14.343(java.sql.Timestamp)][effectiveDate,2008-04-01 23:35:14.453(java.sql.Timestamp)][inventoryItemDetailSeqId,10016(java.lang.String)][inventoryItemId,9005(java.lang.String)][lastUpdatedStamp,2008-04-01 23:35:14.453(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-01 23:35:14.343(java.sql.Timestamp)][physicalInventoryId,10016(java.lang.String)][quantityOnHandDiff,1.0(java.lang.Double)][reasonEnumId,VAR_INTEGR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVENTORY_ITEM_DETAIL (INVENTORY_ITEM_ID, INVENTORY_ITEM_DETAIL_SEQ_ID, EFFECTIVE_DATE, QUANTITY_ON_HAND_DIFF, AVAILABLE_TO_PROMISE_DIFF, UNIT_COST, ORDER_ID, ORDER_ITEM_SEQ_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_ID, SHIPMENT_ITEM_SEQ_ID, RETURN_ID, RETURN_ITEM_SEQ_ID, WORK_EFFORT_ID, FIXED_ASSET_ID, MAINT_HIST_SEQ_ID, ITEM_ISSUANCE_ID, RECEIPT_ID, PHYSICAL_INVENTORY_ID, REASON_ENUM_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVENTORY_ITEM_DETAIL' caused a violation of foreign key constraint 'INV_ITDTL_REAS' for key (VAR_INTEGR). The statement has been rolled back.))] calling service createInventoryItemDetail in createInventoryItemVariance calling service createInventoryItemVariance in createPhysicalInventoryAndVariance
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1734) Creating a Physical Inventory Variance
with "Integration" reason generates an exception
Posted by "Bruno Busco (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bruno Busco updated OFBIZ-1734:
-------------------------------
Attachment: var_integr.patch
Please find attached a patch that solves the issue.
Additionally i would like to ask:
I have seen that the values defined in the entity VarianceReason are exactly matching the ones defined in the Entity Enumeration with enumTypeId="IID_REASON".
Is this by design or may be should one of the two removed?
> Creating a Physical Inventory Variance with "Integration" reason generates an exception
> ---------------------------------------------------------------------------------------
>
> Key: OFBIZ-1734
> URL: https://issues.apache.org/jira/browse/OFBIZ-1734
> Project: OFBiz
> Issue Type: Bug
> Components: product
> Affects Versions: SVN trunk
> Environment: Win XP - LocalDerby - SVN Trunk 643479
> Reporter: Bruno Busco
> Attachments: var_integr.patch
>
>
> 1) select Facility -> Facilities -> WebStoreWarehouse -> Inventory Items
> 2) click on first Inventory Id in the list (9005)
> 3) in the Physical Inventory Variance panel at the bottom of the page select "Integration" in the Variance Reason Id field
> 4) insert '1' in the Quantity On Hand Var
> 5) click on 'Add' button
> the following error is shown:
> The Following Errors Occurred:
> Error:Error:ERROR: Could not complete the Create an InventoryItemDetail [file:/F:/ofbiz_trunk/applications/product/script/org/ofbiz/product/inventory/InventoryServices.xml#createInventoryItemDetail] process [problem creating the newEntity value: Error while inserting: [GenericEntity:InventoryItemDetail][availableToPromiseDiff,0.0(java.lang.Double)][createdStamp,2008-04-01 23:35:14.453(java.sql.Timestamp)][createdTxStamp,2008-04-01 23:35:14.343(java.sql.Timestamp)][effectiveDate,2008-04-01 23:35:14.453(java.sql.Timestamp)][inventoryItemDetailSeqId,10016(java.lang.String)][inventoryItemId,9005(java.lang.String)][lastUpdatedStamp,2008-04-01 23:35:14.453(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-01 23:35:14.343(java.sql.Timestamp)][physicalInventoryId,10016(java.lang.String)][quantityOnHandDiff,1.0(java.lang.Double)][reasonEnumId,VAR_INTEGR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.INVENTORY_ITEM_DETAIL (INVENTORY_ITEM_ID, INVENTORY_ITEM_DETAIL_SEQ_ID, EFFECTIVE_DATE, QUANTITY_ON_HAND_DIFF, AVAILABLE_TO_PROMISE_DIFF, UNIT_COST, ORDER_ID, ORDER_ITEM_SEQ_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_ID, SHIPMENT_ITEM_SEQ_ID, RETURN_ID, RETURN_ITEM_SEQ_ID, WORK_EFFORT_ID, FIXED_ASSET_ID, MAINT_HIST_SEQ_ID, ITEM_ISSUANCE_ID, RECEIPT_ID, PHYSICAL_INVENTORY_ID, REASON_ENUM_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVENTORY_ITEM_DETAIL' caused a violation of foreign key constraint 'INV_ITDTL_REAS' for key (VAR_INTEGR). The statement has been rolled back.))] calling service createInventoryItemDetail in createInventoryItemVariance calling service createInventoryItemVariance in createPhysicalInventoryAndVariance
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.