Product Discontinuation Service error in POS

[Evangelina Bowman]

When we try to finish a sale in POS, we get this message in the console and the service (checkProductInventoryDiscontinuation***) never completes. It runs for a long time until we manually stop the POS.

2008-05-23 12:08:32,307 (Thread-26) [ GenericDAO.java:775:DEBUG] Ran query in 243 milli-seconds: SELECT INVENTORY_ITEM_ID, INVENTORY_ITEM_DETAIL_SEQ_ID, QUANTITY_ON_HAND_DIFF, AVAILABLE_TO_PROMISE_DIFF, ORDER_ID, ORDER_ITEM_SEQ_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_ID, SHIPMENT_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 FROM public.INVENTORY_ITEM_DETAIL WHERE (INVENTORY_ITEM_ID = ?)
2008-05-23 12:08:32,720 (Thread-26) [ EntityEcaRule.java:114:INFO ] Running Entity ECA Service: updateInventoryItemFromDetail, triggered by rule on Entity: InventoryItemDetail
2008-05-23 12:08:33,530 (Thread-26) [ EntityEcaRule.java:114:INFO ] Running Entity ECA Service: checkProductInventoryDiscontinuation, triggered by rule on Entity: InventoryItem
2008-05-23 12:08:33,544 (Thread-26) [ ServiceDispatcher.java:491:DEBUG] [[ASync service started...- total:0.0,since last(Begin):0.0]] - 'entity-default / checkProductInventoryDiscontinuation'

*** This service was added to trunk on January 11. Revision r611121. http://www.nabble.com/svn-commit%3A-r611121---in--ofbiz-trunk-applications-product%3A-script-org-ofbiz-product-inventory-InventoryServices.xml-servicedef-services_view.xml-src-org-ofbiz-product-product-ProductServices.java-tt14752407.html#a14752407


Would anyone know what could be happening?

Thanks,
Evangelina Bowman

[Scott Gray]

Hi Eva

You're best bet would be to try and reproduce the problem on a demo install,
then create a jira with steps to reproduce.

Regards
Scott

2008/5/24 Evangelina Bowman <[hidden email]>:

>
> When we try to finish a sale in POS, we get this message in the console and
> the service (checkProductInventoryDiscontinuation***) never completes. It
> runs for a long time until we manually stop the POS.
>
> 2008-05-23 12:08:32,307 (Thread-26) [ GenericDAO.java:775:DEBUG] Ran query
> in 243 milli-seconds: SELECT INVENTORY_ITEM_ID,
> INVENTORY_ITEM_DETAIL_SEQ_ID, QUANTITY_ON_HAND_DIFF,
> AVAILABLE_TO_PROMISE_DIFF, ORDER_ID, ORDER_ITEM_SEQ_ID, SHIP_GROUP_SEQ_ID,
> SHIPMENT_ID, SHIPMENT_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 FROM public.INVENTORY_ITEM_DETAIL WHERE
> (INVENTORY_ITEM_ID = ?)
> 2008-05-23 12:08:32,720 (Thread-26) [ EntityEcaRule.java:114:INFO ] Running
> Entity ECA Service: updateInventoryItemFromDetail, triggered by rule on
> Entity: InventoryItemDetail
> 2008-05-23 12:08:33,530 (Thread-26) [ EntityEcaRule.java:114:INFO ] Running
> Entity ECA Service: checkProductInventoryDiscontinuation, triggered by rule
> on Entity: InventoryItem
> 2008-05-23 12:08:33,544 (Thread-26) [ ServiceDispatcher.java:491:DEBUG]
> [[ASync service started...- total:0.0,since last(Begin):0.0]] -
> 'entity-default / checkProductInventoryDiscontinuation'
>
> *** This service was added to trunk on January 11. Revision r611121.
>
> http://www.nabble.com/svn-commit%3A-r611121---in--ofbiz-trunk-applications-product%3A-script-org-ofbiz-product-inventory-InventoryServices.xml-servicedef-services_view.xml-src-org-ofbiz-product-product-ProductServices.java-tt14752407.html#a14752407
>
>
> Would anyone know what could be happening?
>
> Thanks,
> Evangelina Bowman
> --
> View this message in context:
> http://www.nabble.com/Product-Discontinuation-Service-error-in-POS-tp17440960p17440960.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>