[jira] [Commented] (OFBIZ-9908) Quick Add button for shopping list on Orderentry screen is not working
[ https://issues.apache.org/jira/browse/OFBIZ-9908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16789519#comment-16789519 ] Jacques Le Roux commented on OFBIZ-9908: Thanks Ankush, I'll have a look ASAP, which should not be "very soon" though, I'll appreciate all other reviews and comment... > Quick Add button for shopping list on Orderentry screen is not working > -- > > Key: OFBIZ-9908 > URL: https://issues.apache.org/jira/browse/OFBIZ-9908 > Project: OFBiz > Issue Type: Bug > Components: order >Reporter: Garima jain >Assignee: Rohit Hukkeri >Priority: Major > Time Spent: 72h > Remaining Estimate: 0h > > steps to generate > 1. Navigate to https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderentry > 2. Press continue on sales order screen. > 3. Add any finished good product to the sales order > 4. In 'Add Order Items to Shopping List' section, select 'new shopping list' > from the drop down and click on 'Add to shopping list' button > 5. you navigate to 'addBulkToShoppingList' screen, click on 'Quick Add' > button. > Issue: The quick add button is not working. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (OFBIZ-9908) Quick Add button for shopping list on Orderentry screen is not working
[
https://issues.apache.org/jira/browse/OFBIZ-9908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16788671#comment-16788671
]
Ankush Upadhyay commented on OFBIZ-9908:
[~rohit.hukkeri], [~jacques.le.roux],
At first glance, it seems that ShoppingList entity is getting locked by service
*createShoppingList* that does not released when service
*checkShoppingListItemSecurity* which is calling from *createShoppingListItem*
service def and that causing *A lock could not be obtained within the time
requested* issue and failure of *checkShoppingListItemSecurity*.
Here are the logs:
{code}
===shoppingListId===
2019-03-09 18:31:29,224 |jsse-nio-8443-exec-6 |Log |I|
[ShoppingListServices.xml#checkShoppingListSecurity line 242]
enter===checkShoppingListSecurity=
2019-03-09 18:31:29,226 |jsse-nio-8443-exec-6 |Log |I|
[ShoppingListServices.xml#checkShoppingListSecurity line 262]
done===checkShoppingListSecurity=
2019-03-09 18:31:29,227 |jsse-nio-8443-exec-6 |ServiceDispatcher |T| Sync
service [order/checkShoppingListSecurity] finished in [23] milliseconds
2019-03-09 18:31:29,227 |jsse-nio-8443-exec-6 |ServiceEcaCondition |I| From
Field (shippingMethodString) is not found in context for createShoppingList,
defaulting to null.
2019-03-09 18:31:29,227 |jsse-nio-8443-exec-6 |ServiceEcaRule |I| For Service
ECA [createShoppingList] on [in-validate] got false for condition:
[shippingMethodString][is-not-empty][true][String]
2019-03-09 18:31:29,227 |jsse-nio-8443-exec-6 |ServiceEcaCondition |I| From
Field (frequency) is not found in context for createShoppingList, defaulting to
null.
2019-03-09 18:31:29,227 |jsse-nio-8443-exec-6 |ServiceEcaRule |I| For Service
ECA [createShoppingList] on [in-validate] got false for condition:
[frequency][is-not-empty][true][String]
2019-03-09 18:31:29,288 |jsse-nio-8443-exec-6 |SequenceUtil |I| Got bank of
sequenced IDs for [ShoppingList]; curSeqId=10130, maxSeqId=10140, bankSize=10
2019-03-09 18:31:29,357 |jsse-nio-8443-exec-6 |ServiceDispatcher |T| Sync
service [order/createShoppingList] finished in [153] milliseconds
2019-03-09 18:31:29,357 |jsse-nio-8443-exec-6 |ShoppingListEvents |I| Adding
cart item to shopping list [10130], allowPromo=true, item.getIsPromo()=false,
item.getProductId()=GZ-2644, item.getQuantity()=2.00
2019-03-09 18:31:29,358 |jsse-nio-8443-exec-6 |NoModule |O|
=ctx===\{userLogin=[GenericEntity:UserLogin][createdStamp,2019-03-09
10:37:23.13(java.sql.Timestamp)][createdTxStamp,2019-03-09
10:37:23.096(java.sql.Timestamp)][currentPassword,{SHA}47b56994cbc2b6d10aa1be30f70165adb305a41a(java.lang.String)][disabledBy,null()][disabledDateTime,null()][enabled,Y(java.lang.String)][externalAuthId,null()][hasLoggedOut,N(java.lang.String)][isSystem,null()][lastCurrencyUom,null()][lastLocale,en(java.lang.String)][lastTimeZone,Asia/Calcutta(java.lang.String)][lastUpdatedStamp,2019-03-09
17:32:29.011(java.sql.Timestamp)][lastUpdatedTxStamp,2019-03-09
17:32:29.011(java.sql.Timestamp)][partyId,admin(java.lang.String)][passwordHint,null()][requirePasswordChange,null()][successiveFailedLogins,null()][userLdapDn,null()][userLoginId,admin(java.lang.String)],
quantity=2.00, reservLength=0, shoppingListId=10130, productId=GZ-2644,
reservPersons=0, reservStart=null}
2019-03-09 18:31:29,363 |jsse-nio-8443-exec-6 |Log |I|
[ShoppingListServices.xml#checkShoppingListItemSecurity line 267]
===entercheckShoppingListItemSecurity=
2019-03-09 18:32:29,374 |jsse-nio-8443-exec-6 |EntityListIterator |W| Warning:
auto-closed EntityListIterator because of exception:
java.sql.SQLTransactionRollbackException: A lock could not be obtained within
the time requested
2019-03-09 18:32:29,374 |jsse-nio-8443-exec-6 |EntityListIterator |W| This
EntityListIterator for Entity [ShoppingList] has already been closed, not
closing again.
2019-03-09 18:32:29,375 |jsse-nio-8443-exec-6 |GenericDelegator |E| Failure in
findByCondition operation for entity [ShoppingList]:
org.apache.ofbiz.entity.GenericEntityException: Error getting the next result
(A lock could not be obtained within the time requested). Rolling back
transaction.
org.apache.ofbiz.entity.GenericEntityException: Error getting the next result
(A lock could not be obtained within the time requested)
at
org.apache.ofbiz.entity.util.EntityListIterator.getCompleteList(EntityListIterator.java:429)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1581)
[ofbiz.jar:?]
at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:451)
[ofbiz.jar:?]
at org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:381)
[ofbiz.jar:?]
at org.apache.ofbiz.entity.util.EntityQuery.queryOne(EntityQuery.java:423)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.finder.PrimaryKeyFinder.runFind(PrimaryKeyFinder.java:152)
[jira] [Commented] (OFBIZ-9908) Quick Add button for shopping list on Orderentry screen is not working
[ https://issues.apache.org/jira/browse/OFBIZ-9908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16774943#comment-16774943 ] Jacques Le Roux commented on OFBIZ-9908: Thanks Rohit, I suggest to create a thread on the dev ML... > Quick Add button for shopping list on Orderentry screen is not working > -- > > Key: OFBIZ-9908 > URL: https://issues.apache.org/jira/browse/OFBIZ-9908 > Project: OFBiz > Issue Type: Bug > Components: order >Reporter: Garima jain >Assignee: Rohit Hukkeri >Priority: Major > Time Spent: 72h > Remaining Estimate: 0h > > steps to generate > 1. Navigate to https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderentry > 2. Press continue on sales order screen. > 3. Add any finished good product to the sales order > 4. In 'Add Order Items to Shopping List' section, select 'new shopping list' > from the drop down and click on 'Add to shopping list' button > 5. you navigate to 'addBulkToShoppingList' screen, click on 'Quick Add' > button. > Issue: The quick add button is not working. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (OFBIZ-9908) Quick Add button for shopping list on Orderentry screen is not working
[ https://issues.apache.org/jira/browse/OFBIZ-9908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16774790#comment-16774790 ] Rohit Hukkeri commented on OFBIZ-9908: -- 1.Followed the steps to regenerate the issue. 2.When we try to add the order items to the shopping list by selecting new shopping list there is a database specific issue with Derby database: It takes long time to go to the 'addBulkToShoppingList' screen resulting a error in adding cart items to the shopping list. 3.When we change the configuration to MySQL it is working fine as the steps given up to adding cart items to the shopping list still it is not displaying shopping list items on 'addBulkToShoppingList' screen. 4.Here we can make sure that items are added in shopping list or not by going to the shortcut section and click on Shopping List button. 5.This needs to be fixed along with the previously spotted issue which still needs to be fixed. 6.This issue needs to be discussed further. > Quick Add button for shopping list on Orderentry screen is not working > -- > > Key: OFBIZ-9908 > URL: https://issues.apache.org/jira/browse/OFBIZ-9908 > Project: OFBiz > Issue Type: Bug > Components: order >Reporter: Garima jain >Assignee: Rohit Hukkeri >Priority: Major > > steps to generate > 1. Navigate to https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderentry > 2. Press continue on sales order screen. > 3. Add any finished good product to the sales order > 4. In 'Add Order Items to Shopping List' section, select 'new shopping list' > from the drop down and click on 'Add to shopping list' button > 5. you navigate to 'addBulkToShoppingList' screen, click on 'Quick Add' > button. > Issue: The quick add button is not working. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (OFBIZ-9908) Quick Add button for shopping list on Orderentry screen is not working
[ https://issues.apache.org/jira/browse/OFBIZ-9908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16774787#comment-16774787 ] Rohit Hukkeri commented on OFBIZ-9908: -- 1.Followed the steps to regenerate the issue. 2.When we try to add the order items to the shopping list by selecting new shopping list there is a database specific issue with Derby database: It takes long time to go to the '+addBulkToShoppingList' screen resulting a error in adding cart items to the shopping list. 3.When we change the configuration to MySQL it is working fine as the steps given up to adding cart items to the shopping list still it is not displaying shopping list items on '+addBulkToShoppingList+' screen. 4.Here we can make sure that items are added in shopping list or not by going to the shortcut section and click on Shopping List button. 5.This needs to be fixed along with the previously spotted issue which still needs to be fixed. 6.This issue needs to be discussed further. > Quick Add button for shopping list on Orderentry screen is not working > -- > > Key: OFBIZ-9908 > URL: https://issues.apache.org/jira/browse/OFBIZ-9908 > Project: OFBiz > Issue Type: Bug > Components: order >Reporter: Garima jain >Assignee: Rohit Hukkeri >Priority: Major > > steps to generate > 1. Navigate to https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderentry > 2. Press continue on sales order screen. > 3. Add any finished good product to the sales order > 4. In 'Add Order Items to Shopping List' section, select 'new shopping list' > from the drop down and click on 'Add to shopping list' button > 5. you navigate to 'addBulkToShoppingList' screen, click on 'Quick Add' > button. > Issue: The quick add button is not working. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (OFBIZ-9908) Quick Add button for shopping list on Orderentry screen is not working
[ https://issues.apache.org/jira/browse/OFBIZ-9908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16771042#comment-16771042 ] Jacques Le Roux commented on OFBIZ-9908: Ha indeed, thanks Rohit > Quick Add button for shopping list on Orderentry screen is not working > -- > > Key: OFBIZ-9908 > URL: https://issues.apache.org/jira/browse/OFBIZ-9908 > Project: OFBiz > Issue Type: Bug > Components: order >Reporter: Garima jain >Assignee: Rohit Hukkeri >Priority: Minor > > steps to generate > 1. Navigate to https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderentry > 2. Press continue on sales order screen. > 3. Add any finished good product to the sales order > 4. In 'Add Order Items to Shopping List' section, select 'new shopping list' > from the drop down and click on 'Add to shopping list' button > 5. you navigate to 'addBulkToShoppingList' screen, click on 'Quick Add' > button. > Issue: The quick add button is not working. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (OFBIZ-9908) Quick Add button for shopping list on Orderentry screen is not working
[ https://issues.apache.org/jira/browse/OFBIZ-9908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16771020#comment-16771020 ] Rohit Hukkeri commented on OFBIZ-9908: -- Hi Jacques, The issue in OFBIZ-10836 was to add an individual item to the cart, while the issue reported here is to add bulk products i.e. all the products in the shopping list to add quickly in the cart. Thanks. > Quick Add button for shopping list on Orderentry screen is not working > -- > > Key: OFBIZ-9908 > URL: https://issues.apache.org/jira/browse/OFBIZ-9908 > Project: OFBiz > Issue Type: Bug > Components: order >Reporter: Garima jain >Assignee: Rohit Hukkeri >Priority: Minor > > steps to generate > 1. Navigate to https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderentry > 2. Press continue on sales order screen. > 3. Add any finished good product to the sales order > 4. In 'Add Order Items to Shopping List' section, select 'new shopping list' > from the drop down and click on 'Add to shopping list' button > 5. you navigate to 'addBulkToShoppingList' screen, click on 'Quick Add' > button. > Issue: The quick add button is not working. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (OFBIZ-9908) Quick Add button for shopping list on Orderentry screen is not working
[ https://issues.apache.org/jira/browse/OFBIZ-9908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16771000#comment-16771000 ] Jacques Le Roux commented on OFBIZ-9908: Hi Rohit, I guess you want to close here after OFBIZ-10836? > Quick Add button for shopping list on Orderentry screen is not working > -- > > Key: OFBIZ-9908 > URL: https://issues.apache.org/jira/browse/OFBIZ-9908 > Project: OFBiz > Issue Type: Bug > Components: order >Reporter: Garima jain >Assignee: Rohit Hukkeri >Priority: Minor > > steps to generate > 1. Navigate to https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderentry > 2. Press continue on sales order screen. > 3. Add any finished good product to the sales order > 4. In 'Add Order Items to Shopping List' section, select 'new shopping list' > from the drop down and click on 'Add to shopping list' button > 5. you navigate to 'addBulkToShoppingList' screen, click on 'Quick Add' > button. > Issue: The quick add button is not working. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (OFBIZ-9908) Quick Add button for shopping list on Orderentry screen is not working
[ https://issues.apache.org/jira/browse/OFBIZ-9908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16265637#comment-16265637 ] Jacques Le Roux commented on OFBIZ-9908: Hi, This is an old bug also reproductible on old demo (that we now longer support, just to say), thanks! > Quick Add button for shopping list on Orderentry screen is not working > -- > > Key: OFBIZ-9908 > URL: https://issues.apache.org/jira/browse/OFBIZ-9908 > Project: OFBiz > Issue Type: Bug > Components: order >Reporter: Garima jain >Assignee: Yogesh Naroliya >Priority: Minor > > steps to generate > 1. Navigate to https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderentry > 2. Press continue on sales order screen. > 3. Add any finished good product to the sales order > 4. In 'Add Order Items to Shopping List' section, select 'new shopping list' > from the drop down and click on 'Add to shopping list' button > 5. you navigate to 'addBulkToShoppingList' screen, click on 'Quick Add' > button. > Issue: The quick add button is not working. -- This message was sent by Atlassian JIRA (v6.4.14#64029)
