Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039122ModulesAdvanced Warehouse Operationspublic2018-08-13 09:332018-09-11 08:12
ReporterVictorVillar 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Tovmromanos
Support ticket
OBNetwork customer
Regression introduced in release
Summary0039122: Wrong message: 'Session closed' message autoconfirming an issue task
DescriptionWrong message: 'Session closed' message autoconfirming an issue task
Steps To ReproduceWarehouse definitio (for issue tasks)
IRA: Shipping
SBG: SHP
Storage bin: SHP0001
Routing: From SHP. Autoconfirmation.
Routing Assignment: Issue Sales Order

Set up a business partner: on hold for shipments, not for orders.

Create a sales order for this business partner.
Create and complete the Picking tasks.

Create the issue task.
You receive an error message: Session is Closed!

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0039356 closed vmromanos Session is closed error when issuing partial sales order line with attribute set and without reservation (automatic task) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-08-13 09:33VictorVillarNew Issue
2018-08-13 09:33VictorVillarAssigned To => dmiguelez
2018-08-13 10:09gorkaionResolution time => 1535925600
2018-08-20 11:27martinsdanIssue Monitored: martinsdan
2018-09-03 10:08ngarciaIssue Monitored: ngarcia
2018-09-05 17:11ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=17605#r17605
2018-09-06 16:33dmiguelezNote Added: 0106628
2018-09-06 16:34dmiguelezNote Added: 0106629
2018-09-06 16:43hgbotCheckin
2018-09-06 16:43hgbotNote Added: 0106630
2018-09-06 16:43hgbotStatusnew => resolved
2018-09-06 16:43hgbotResolutionopen => fixed
2018-09-06 16:43hgbotFixed in SCM revision => http://code.openbravo.com/retail/backports/AWO/3.0RR18Q3/org.openbravo.warehouse.advancedwarehouseoperations/rev/528aea86ad2752e26fe9785e9a667ed6310f7919 [^]
2018-09-11 08:12vmromanosReview Assigned To => vmromanos
2018-09-11 08:12vmromanosNote Added: 0106677
2018-09-11 08:12vmromanosStatusresolved => closed
2018-09-27 12:30vmromanosRelationship addedhas duplicate 0039356
2022-09-06 17:18caristuCategoryAdvance Warehouse Operations => Advanced Warehouse Operations

Notes
(0106628)
dmiguelez   
2018-09-06 16:33   
This issue is no longer reproducible in the latest code of AWO, after the upgrade to hibernate 5.3
(0106629)
dmiguelez   
2018-09-06 16:34   
Test Plan:

With AWO and AWO SampleData installed (Q3 version)

Sales:

Go to Warehouse Definition Window and select US West Coast Warehouse
Move to Routing Tab and find the record with the name From SHP, ManConf
Change the Confirmation to Automatic

Go to Sales Order Window and create a new record with:
  - Organization: US West Coast
  - Business Partner: Healthy Food Supermarkets
  - Warehouse: US West Coast
Move to lines and create a new record with:
  - Product: Ale Beer
  - Operative Quantity: 10
Book the Order

Click on Pick button and done.
Move to the Task Tab under the Lines and confirm the Picking Task

Go to Business Partner Window and select the Business Partner With name Healthy Food Supermarkets, Co.
Move to Customer Tab and check the On Hold check

Go back to the Sales Order
Click on issue button and done.
An error message is shown:
org.openbravo.base.exception.OBException: The business partner Healthy Food Supermarkets, Co. is on hold for this document, therefore it is not possible to complete it.


Purchase:

Go to Warehouse Definition Window and select US West Coast Warehouse
Move to Routing Tab and find the record with the name To RCT, ManConf
Change the Confirmation to Automatic
Select the record with the name RCT to STGn, ManConf
Change the Confirmation to Automatic

Go to Product Window and create a new record with:
  - SearchKey: Test
  - Name: Test
  - Storage Bin Group List: Food SBGL
Move to Price tab and create a new record with:
  - Price List Version: Be Soft Drinker Price List
  - Unit Price: 10
  - List Price: 10

Go to Purchase Order window and create a new record with:
  - Organization: US West Coast
  - Business Partner: Be Soft Drinker
  - Warehouse: US West Coast
Move to Lines and create a new record with:
  - Product: test
  - Operative Quantity: 10
Book the Order

Click on receive and done

Go to Warehouse Operations Window
Look for the record that has the Product Test in RCT201 Bin
Click on Put-Away
An error message is shown:
The confirmed to bin to can not be null.
(0106630)
hgbot   
2018-09-06 16:43   
Repository: retail/backports/AWO/3.0RR18Q3/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: 528aea86ad2752e26fe9785e9a667ed6310f7919
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Sep 06 16:36:17 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q3/org.openbravo.warehouse.advancedwarehouseoperations/rev/528aea86ad2752e26fe9785e9a667ed6310f7919 [^]

Fixes Issue 39122. Checks if the Dal Session is open
before attempting to close the scrollable results.

This is only necessary on versions of hibernate
previous to the upgrade to 5.3

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/centralbroker/AutoConfirmatorBehaveAsGroupTasks.java
---
(0106677)
vmromanos   
2018-09-11 08:12   
Code review + testing OK