Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0037123
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminorhave not tried2017-10-19 17:442017-10-19 18:21
ReporterplujanView Statuspublic 
Assigned Tovmromanos 
PrioritynormalResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tovmromanos
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0037123: [PR17Q4][AWO] More than one routing matching a reception generates an error

DescriptionI created a Purchase Order and received an error when trying to Receive it.

"The confirmed attribute can not be null for product Damascus Cooking Knife"

The error seems related with the multiple Routing Assignments in the Warehouse Definition window.
Steps To Reproduce1. Having in Warehouse definition, Routing Assignment tab three records:
a. Receipt Purchase Order, Routing: Manual, no filters
b. Receipt Purchase Order, Routing: Automatic, filter: Product Category=Pasta
c. Receipt Purchase Order, Routing: Automatic, filter: BP Category=Internal

2. Create a Purchase order for the BP Vendor (BP Category=Vendor)
3. Create a Line for the product Knife (Product Category=Utensils)
4. Book the order and Click the Receive button. An error is shown.

The Verbosity log shows the following:

  * DEBUG - Request to the Task Generator for Class [class org.openbravo.model.common.order.Order], map of objects [{0DD8C21D5BF5426CA286D770592E5013=null}], action [RCT], userAssignedId [null], taskStatus [null]
  * INFO - AWO flows are granted for Organization ['5EFF95EB540740A3B10510D9814EFAD5' - USA]
  * INFO - Detected Inventory Transaction Type ['CA45D39F9519416DB6989E664352A958' - Receipt Purchase Order]
  * DEBUG - Using Inventory Transaction Type Algorithm [org.openbravo.warehouse.advancedwarehouseoperations.ittalgorithm.implementation.ReceiptPurchaseOrder_ITTAlgorithm@3aa7d1e4]
    * INFO - Calculate Task Requirements for the purchase order reception ['0DD8C21D5BF5426CA286D770592E5013' - Purchase Order - 800011 - 19-10-2017 - Vendor A]
    * INFO - Analyze purchase order line ['2EF2236091D14650AA418FA94AF97B25' - 800011 - 50 - Damascus Cooking Knife - 10Ud - 10Ud - ] to create a task requirement...
    * INFO - Quantity ordered [10]; Quantity detected in previous tasks [0]; Quantity pending to generate task [10]
    * INFO - Creating Task Requirement for quantity [10]
      * INFO - Setting Inventory Transaction Type related info...
      * INFO - Inventory Transaction Type ['CA45D39F9519416DB6989E664352A958' - Receipt Purchase Order]; Action [RCT], Behave as Group [true]
      * INFO - Finished Inventory Transaction Type related info.
      * INFO - Setting Organization and Client related info...
      * INFO - Client ['4028E6C72959682B01295A070852010D' - QA Testing]; Organization ['5EFF95EB540740A3B10510D9814EFAD5' - USA]
      * INFO - Finished Organization and Client related info.
      * INFO - Task Requirement quantity [10]
      * INFO - Setting Product and Product Category related info...
      * INFO - Product ['0FAC7DFDC9484B30B35665ECF3D03BFB' - Damascus Cooking Knife - Services - Ud - Utensils - ]; Product Category ['4028E6C72959682B01295ADC0BB10216' - Services]; Requires Serial No. Split [true]
      * INFO - Finished Product and Product Category related info.
      * INFO - Task Requirement Warehouse ['E78E669949A146A8A826C2D13B6803F4' - Central Warehouse]
      * INFO - Created Task Requirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order]
      * INFO - Setting Business Partner related attributes...
      * INFO - Business Partner ['4028E6C72959682B01295F40BDDF02E3' - Vendor A], Business Partner Category ['4028E6C72959682B01295F40BC2A02E2' - Vendor]
      * INFO - Finished Business Partner related attributes...
    * INFO - Finished analyze purchase order line ['2EF2236091D14650AA418FA94AF97B25' - 800011 - 50 - Damascus Cooking Knife - 10Ud - 10Ud - ] in order to create a task requirement.
    * INFO - Analyze purchase order line ['B15C25A75FEB4F78B9E241695963B812' - 800011 - 40 - Service A - 100d - 4ob - ] to create a task requirement...
    * INFO - Skipping order line ['B15C25A75FEB4F78B9E241695963B812' - 800011 - 40 - Service A - 100d - 4ob - ] because Product is not defined as Item and Stockable
    * INFO - Finished analyze purchase order line ['B15C25A75FEB4F78B9E241695963B812' - 800011 - 40 - Service A - 100d - 4ob - ] in order to create a task requirement.
    * INFO - Analyze purchase order line ['AF1BD81853B94C61AC32C04A0A598137' - 800011 - 10 - Fresh Tuna Fish - 100kg - 5cs - ] to create a task requirement...
    * INFO - Quantity ordered [100]; Quantity detected in previous tasks [100.00]; Quantity pending to generate task [0.00]
    * INFO - There is no need to create a task requirement for this line
    * INFO - Finished analyze purchase order line ['AF1BD81853B94C61AC32C04A0A598137' - 800011 - 10 - Fresh Tuna Fish - 100kg - 5cs - ] in order to create a task requirement.
    * INFO - Analyze purchase order line ['5CE2C407678B44AEA5C17CEF688E1B0D' - 800011 - 20 - Spaghetti - 100kg - 100pk - ] to create a task requirement...
    * INFO - Quantity ordered [100]; Quantity detected in previous tasks [100.00]; Quantity pending to generate task [0.00]
    * INFO - There is no need to create a task requirement for this line
    * INFO - Finished analyze purchase order line ['5CE2C407678B44AEA5C17CEF688E1B0D' - 800011 - 20 - Spaghetti - 100kg - 100pk - ] in order to create a task requirement.
    * INFO - Finished calculate Task Requirements for the purchase order reception ['0DD8C21D5BF5426CA286D770592E5013' - Purchase Order - 800011 - 19-10-2017 - Vendor A]
    INFO -
    * INFO - Creating Tasks...
    * DEBUG - List of Task Requirements: [[Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order]]
    * INFO - Created Batch of Tasks: ['E343DF7FC5834F258C2377FBC33A335D' - 1000002]
    * INFO - Calculating Task Proposals for Task Requirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order]...
      * DEBUG - Getting Routing Assignment for inventoryTransactionTypeId [CA45D39F9519416DB6989E664352A958], warehouseId [E78E669949A146A8A826C2D13B6803F4], productId [0FAC7DFDC9484B30B35665ECF3D03BFB], productCategoryId [4028E6C72959682B01295ADC0BB10216], businessPartnerId [4028E6C72959682B01295F40BDDF02E3], bpartnerCategoryId [4028E6C72959682B01295F40BC2A02E2], storageBinGroupId [null], irareaId [null]
      * DEBUG - Query: [select iras from OBAWO_Internal_Routing_Assi iras inner join iras.internalRouting ir left join ir.internalRoutingAreaFrom irareaf where iras.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and iras.warehouse.id = :warehouseId and (iras.product.id = :productId or iras.product is null) and (iras.productCategory.id = :productCategoryId or iras.productCategory is null) and (iras.businessPartner.id = :businessPartnerId or iras.businessPartner is null) and (iras.businessPartnerCategory.id = :bpartnerCategoryId or iras.businessPartnerCategory is null) and (irareaf.id = :irareafId or irareaf is null) and (iras.storageBinGroup.id = :storageBinGroupId or iras.storageBinGroup is null) and iras.active = true and ir.active = true order by (case when iras.product.id = :productId then 16 else 0 end) + (case when iras.productCategory.id = :productCategoryId then 8 else 0 end) + (case when iras.businessPartner.id = :businessPartnerId then 4 else 0 end) + (case when iras.businessPartnerCategory.id = :bpartnerCategoryId then 2 else 0 end) + (case when iras.storageBinGroup.id = :storageBinGroupId then 1 else 0 end) DESC ]
      * INFO - Detected more than one Routing Assignment, using ['8B9BC55A8C694D5684107F0393E84BAB' - Receipt Purchase Order - to RCT, AutoConf - - - ]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [null], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) ) ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - List of available Storage Bins before applying the logic of the Put Away Algorithms:
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [null], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) ) ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - Storage Bin ['01C6AA505955472FAC0D69ECE9F3BFF4' - DOCK - Docking - DCK - 0%]
      * INFO - Creating Task Proposal Storage Detail...
      * INFO - There is no need to calculate the Storage Detail using PK Algorithms.
      * DEBUG - Created TaskProposalStorageDetail with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order], quantity [10], storageDetailId [null] and pkWarehouseAlgorithmId [null]
      * INFO - Finished creating Task Proposal Storage Detail.
      * INFO - Calculating Task Proposal To-Bin...
      * DEBUG - Getting suitable warehouse algorithms for warehouseId [E78E669949A146A8A826C2D13B6803F4], inventoryTransactionTypeId [CA45D39F9519416DB6989E664352A958], warehouseAlgorithmType [LOCATOR_TO], productId [0FAC7DFDC9484B30B35665ECF3D03BFB], productCategoryId [4028E6C72959682B01295ADC0BB10216], businessPartnerId [4028E6C72959682B01295F40BDDF02E3], bpartnerCategoryId [4028E6C72959682B01295F40BC2A02E2], storageBinGroupId [null]
      * INFO - Detected the following ordered PA Warehouse Algorithms [[53864AE0A9E8478282487A236058C774:org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_MergeWithProductFullLogisticUnit:PA Merge with Product Full Logistic Unit, 45E2A7558C764DC1B459A807A4B02EFE:org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_MergeWithProduct:PA Merge with Product, B6184A47C0D543219225285CCE8BB17D:org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_ByPopCodeFullLogisticUnit:PA By Popularity Code Full Logistic Unit, 0527B369BF364E53BCAC9AFD966600B1:org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_ByPopCode:PA By Popularity Code, C781DDA300E84754B803A489E2423623:org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_RandomValidBin:PA First valid bin]]
      * INFO - Executing Warehouse Algorithm [PA Merge with Product Full Logistic Unit:org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_MergeWithProductFullLogisticUnit]
      * DEBUG - Class [org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_MergeWithProductFullLogisticUnit]
      * INFO - Algorithm description: Returns a list of valid bins in the IRA considering capacity that have already stock for the selected Product, ordered by SBG List Sequence ascending. Quantity returned represents (multiple of) full (primary) logistic unit.
      * DEBUG - Query is being called by PA_MergeWithProduct with extra Parameters: Product Id [0FAC7DFDC9484B30B35665ECF3D03BFB]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ exists (select 1 from MaterialMgmtStorageDetail sd where sd.product.id = :productId and sd.storageBin.id = l.id) ], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [{productId=0FAC7DFDC9484B30B35665ECF3D03BFB}], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) and (COALESCE(l.obawoOccupancy, 0) + COALESCE(l.obawoOccupancyPending, 0) < 100.00) ) ) and ( exists (select 1 from MaterialMgmtStorageDetail sd where sd.product.id = :productId and sd.storageBin.id = l.id) ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * INFO - No Bin have been returned by the PA Warehouse Algorithm.
      * INFO - Executing Warehouse Algorithm [PA Merge with Product:org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_MergeWithProduct]
      * DEBUG - Class [org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_MergeWithProduct]
      * INFO - Algorithm description: Returns a list of valid bins in the IRA considering capacity that have already stock for the selected Product, ordered by SBG List Sequence ascending.
      * DEBUG - Query is being called by PA_MergeWithProduct with extra Parameters: Product Id [0FAC7DFDC9484B30B35665ECF3D03BFB]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ exists (select 1 from MaterialMgmtStorageDetail sd where sd.product.id = :productId and sd.storageBin.id = l.id) ], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [{productId=0FAC7DFDC9484B30B35665ECF3D03BFB}], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) and (COALESCE(l.obawoOccupancy, 0) + COALESCE(l.obawoOccupancyPending, 0) < 100.00) ) ) and ( exists (select 1 from MaterialMgmtStorageDetail sd where sd.product.id = :productId and sd.storageBin.id = l.id) ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * INFO - No Bin have been returned by the PA Warehouse Algorithm.
      * INFO - Executing Warehouse Algorithm [PA By Popularity Code Full Logistic Unit:org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_ByPopCodeFullLogisticUnit]
      * DEBUG - Class [org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_ByPopCodeFullLogisticUnit]
      * INFO - Algorithm description: Returns a list of valid bins in the IRA considering capacity, excluding the bins with a PopularityCode smaller than the Product's PopularityCode, ordered by SBG List Sequence, PopularityCode, Available Capacity ascending. Quantity returned represents (mu
      * DEBUG - Query is being called by PA_ByPopCode with extra Parameters: Max Pop Code [9223372036854775807], Product Pop Code [9223372036854775807]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ COALESCE(l.oBAWOPopularityCode,:maxPopCode) >= :productPopCode ], hqlGroupClause [ COALESCE(l.oBAWOPopularityCode,0) ], hqlOrderByClause [ COALESCE(l.oBAWOPopularityCode,0) asc ], namedParameters [{productPopCode=9223372036854775807, maxPopCode=9223372036854775807}], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) and (COALESCE(l.obawoOccupancy, 0) + COALESCE(l.obawoOccupancyPending, 0) < 100.00) ) ) and ( COALESCE(l.oBAWOPopularityCode,:maxPopCode) >= :productPopCode ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) , COALESCE(l.oBAWOPopularityCode,0) order by coalesce(lgline.sequenceNumber, 9999) asc , COALESCE(l.oBAWOPopularityCode,0) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * INFO - No Bin have been returned by the PA Warehouse Algorithm.
      * INFO - Executing Warehouse Algorithm [PA By Popularity Code:org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_ByPopCode]
      * DEBUG - Class [org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_ByPopCode]
      * INFO - Algorithm description: Returns a list of valid bins in the IRA considering capacity, excluding the bins with a PopularityCode smaller than the Product's PopularityCode, ordered by SBG List Sequence, PopularityCode, Available Capacity ascending
      * DEBUG - Query is being called by PA_ByPopCode with extra Parameters: Max Pop Code [9223372036854775807], Product Pop Code [9223372036854775807]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ COALESCE(l.oBAWOPopularityCode,:maxPopCode) >= :productPopCode ], hqlGroupClause [ COALESCE(l.oBAWOPopularityCode,0) ], hqlOrderByClause [ COALESCE(l.oBAWOPopularityCode,0) asc ], namedParameters [{productPopCode=9223372036854775807, maxPopCode=9223372036854775807}], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) and (COALESCE(l.obawoOccupancy, 0) + COALESCE(l.obawoOccupancyPending, 0) < 100.00) ) ) and ( COALESCE(l.oBAWOPopularityCode,:maxPopCode) >= :productPopCode ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) , COALESCE(l.oBAWOPopularityCode,0) order by coalesce(lgline.sequenceNumber, 9999) asc , COALESCE(l.oBAWOPopularityCode,0) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * INFO - No Bin have been returned by the PA Warehouse Algorithm.
      * INFO - Executing Warehouse Algorithm [PA First valid bin:org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_RandomValidBin]
      * DEBUG - Class [org.openbravo.warehouse.advancedwarehouseoperations.warehousealgorithm.implementation.PA_RandomValidBin]
      * INFO - Algorithm description: Returns a list of valid bins in the IRA; ordered by SBG List Sequence, StorageBin.SearchKey ascending; taking into account the capacity of them.
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [null], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) and (COALESCE(l.obawoOccupancy, 0) + COALESCE(l.obawoOccupancyPending, 0) < 100.00) ) ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - To-Bin Ids returned by the PA Warehouse Algorithm: [[01C6AA505955472FAC0D69ECE9F3BFF4]]
      * INFO - Trying to use bin ['01C6AA505955472FAC0D69ECE9F3BFF4' - DOCK - Docking - DCK - 0%] returned by PA Algorithm
      * DEBUG - Bin To ['01C6AA505955472FAC0D69ECE9F3BFF4' - DOCK - Docking - DCK - 0%] is in a Functional Area, so it can allocate full pending quantity [10]
      * INFO - Allocating [10] Stock in Storage Bin:['01C6AA505955472FAC0D69ECE9F3BFF4' - DOCK - Docking - DCK - 0%]. Pending Stock to be allocated afterwards: [0]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ l.id = :storageBinId ], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) ) ) and ( l.id = :storageBinId ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - Created TaskProposalLocatorTo with parameters: taskProposalStorageDetail [Quantity: 10. Attribute: . TaskRequirement: Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order], qty [10], locatorToId [01C6AA505955472FAC0D69ECE9F3BFF4], paWarehouseAlgorithmId [C781DDA300E84754B803A489E2423623]
      * INFO - Finished calculating Task Proposal To-Bin.
      * DEBUG - Splitting Task Proposal To-Bin...
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ l.id = :storageBinId ], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) ) ) and ( l.id = :storageBinId ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - Created TaskProposalLocatorTo with parameters: taskProposalStorageDetail [Quantity: 10. Attribute: . TaskRequirement: Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order], qty [1], locatorToId [01C6AA505955472FAC0D69ECE9F3BFF4], paWarehouseAlgorithmId [C781DDA300E84754B803A489E2423623]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ l.id = :storageBinId ], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) ) ) and ( l.id = :storageBinId ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - Created TaskProposalLocatorTo with parameters: taskProposalStorageDetail [Quantity: 10. Attribute: . TaskRequirement: Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order], qty [1], locatorToId [01C6AA505955472FAC0D69ECE9F3BFF4], paWarehouseAlgorithmId [C781DDA300E84754B803A489E2423623]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ l.id = :storageBinId ], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) ) ) and ( l.id = :storageBinId ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - Created TaskProposalLocatorTo with parameters: taskProposalStorageDetail [Quantity: 10. Attribute: . TaskRequirement: Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order], qty [1], locatorToId [01C6AA505955472FAC0D69ECE9F3BFF4], paWarehouseAlgorithmId [C781DDA300E84754B803A489E2423623]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ l.id = :storageBinId ], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) ) ) and ( l.id = :storageBinId ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - Created TaskProposalLocatorTo with parameters: taskProposalStorageDetail [Quantity: 10. Attribute: . TaskRequirement: Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order], qty [1], locatorToId [01C6AA505955472FAC0D69ECE9F3BFF4], paWarehouseAlgorithmId [C781DDA300E84754B803A489E2423623]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ l.id = :storageBinId ], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) ) ) and ( l.id = :storageBinId ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - Created TaskProposalLocatorTo with parameters: taskProposalStorageDetail [Quantity: 10. Attribute: . TaskRequirement: Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order], qty [1], locatorToId [01C6AA505955472FAC0D69ECE9F3BFF4], paWarehouseAlgorithmId [C781DDA300E84754B803A489E2423623]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ l.id = :storageBinId ], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) ) ) and ( l.id = :storageBinId ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - Created TaskProposalLocatorTo with parameters: taskProposalStorageDetail [Quantity: 10. Attribute: . TaskRequirement: Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order], qty [1], locatorToId [01C6AA505955472FAC0D69ECE9F3BFF4], paWarehouseAlgorithmId [C781DDA300E84754B803A489E2423623]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ l.id = :storageBinId ], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) ) ) and ( l.id = :storageBinId ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - Created TaskProposalLocatorTo with parameters: taskProposalStorageDetail [Quantity: 10. Attribute: . TaskRequirement: Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order], qty [1], locatorToId [01C6AA505955472FAC0D69ECE9F3BFF4], paWarehouseAlgorithmId [C781DDA300E84754B803A489E2423623]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ l.id = :storageBinId ], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) ) ) and ( l.id = :storageBinId ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - Created TaskProposalLocatorTo with parameters: taskProposalStorageDetail [Quantity: 10. Attribute: . TaskRequirement: Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order], qty [1], locatorToId [01C6AA505955472FAC0D69ECE9F3BFF4], paWarehouseAlgorithmId [C781DDA300E84754B803A489E2423623]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ l.id = :storageBinId ], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) ) ) and ( l.id = :storageBinId ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - Created TaskProposalLocatorTo with parameters: taskProposalStorageDetail [Quantity: 10. Attribute: . TaskRequirement: Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order], qty [1], locatorToId [01C6AA505955472FAC0D69ECE9F3BFF4], paWarehouseAlgorithmId [C781DDA300E84754B803A489E2423623]
      * DEBUG - PA_QueryBuilder with parameters: taskRequirement [Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order],hqlFromClause [null] hqlWhereClause [ l.id = :storageBinId ], hqlGroupClause [null], hqlOrderByClause [null], namedParameters [null], maxResults [null]
      * DEBUG - Query: [ select l.id from Locator l join l.oBAWOLocatorGroup lg join lg.internalRoutingArea irareato left join lg.oBAWOLocatorGroupLineList lgline with lgline.storageBinGroupList.id = :storageBinGroupListId where exists (select 1 from OBAWO_Internal_Routing_Assi irass join irass.internalRouting ir where ir.internalRoutingAreaTo.id = irareato.id and irass.obawoInventoryTransactionType.id = :inventoryTransactionTypeId and irass.internalRouting.id = :internalRoutingId and irass.warehouse.id = :warehouseId ) and (lgline is null or lgline.storageBinGroup.id = lg.id) and l.active = true and ( irareato.functional = true or (irareato.functional = false and lg.id in (:locatorGroupIds) ) ) and ( l.id = :storageBinId ) group by l.id, l.searchKey, coalesce(lgline.sequenceNumber, 9999) order by coalesce(lgline.sequenceNumber, 9999) asc , l.searchKey ]. Parameters: Storage Bin Group List Id [99811BC0C38D43E1975312CA6F97A809], Inventory Transaction Type Id [CA45D39F9519416DB6989E664352A958], Internal Routing Id [02057FB0EAF54435933DAE27C736C3D9], Locator Group Ids [[494546FD29A64DE3A896A8D55FF104ED, 0A7A9224F58E4E968F6B8BD20BDA4902]]
      * DEBUG - Created TaskProposalLocatorTo with parameters: taskProposalStorageDetail [Quantity: 10. Attribute: . TaskRequirement: Warehouse: Central Warehouse. Product: Damascus Cooking Knife. Quantity: 10. Inventory Transaction Type: Receipt Purchase Order], qty [1], locatorToId [01C6AA505955472FAC0D69ECE9F3BFF4], paWarehouseAlgorithmId [C781DDA300E84754B803A489E2423623]
    * INFO - Created task ['0BA8827C5C074E8EB76692C972387269' - Damascus Cooking Knife - 1Ud - - - DOCK] linked to Batch of Tasks ['E343DF7FC5834F258C2377FBC33A335D' - 1000002]
    * DEBUG - Calling ITTAlgoritm postCreateTaskHook for task ['0BA8827C5C074E8EB76692C972387269' - Damascus Cooking Knife - 1Ud - - - DOCK]...
    * INFO - Linking task ['0BA8827C5C074E8EB76692C972387269' - Damascus Cooking Knife - 1Ud - - - DOCK] with order line ['2EF2236091D14650AA418FA94AF97B25' - 800011 - 50 - Damascus Cooking Knife - 10Ud - 10Ud - ]
    * DEBUG - Finished ITTAlgoritm postCreateTaskHook for task ['0BA8827C5C074E8EB76692C972387269' - Damascus Cooking Knife - 1Ud - - - DOCK]
    * INFO - Not autoconfirming individual Task ['0BA8827C5C074E8EB76692C972387269' - Damascus Cooking Knife - 1Ud - - - DOCK] based on the Routing configuration ['02057FB0EAF54435933DAE27C736C3D9' - to RCT, AutoConf - - Docking]
    * INFO - Created task ['B4620B77D90042C6B7CDB84148D35D76' - Damascus Cooking Knife - 1Ud - - - DOCK] linked to Batch of Tasks ['E343DF7FC5834F258C2377FBC33A335D' - 1000002]
    * DEBUG - Calling ITTAlgoritm postCreateTaskHook for task ['B4620B77D90042C6B7CDB84148D35D76' - Damascus Cooking Knife - 1Ud - - - DOCK]...
    * INFO - Linking task ['B4620B77D90042C6B7CDB84148D35D76' - Damascus Cooking Knife - 1Ud - - - DOCK] with order line ['2EF2236091D14650AA418FA94AF97B25' - 800011 - 50 - Damascus Cooking Knife - 10Ud - 10Ud - ]
    * DEBUG - Finished ITTAlgoritm postCreateTaskHook for task ['B4620B77D90042C6B7CDB84148D35D76' - Damascus Cooking Knife - 1Ud - - - DOCK]
    * INFO - Not autoconfirming individual Task ['B4620B77D90042C6B7CDB84148D35D76' - Damascus Cooking Knife - 1Ud - - - DOCK] based on the Routing configuration ['02057FB0EAF54435933DAE27C736C3D9' - to RCT, AutoConf - - Docking]
    * INFO - Created task ['5A5C893B9CEE433F950B642710F7F1BC' - Damascus Cooking Knife - 1Ud - - - DOCK] linked to Batch of Tasks ['E343DF7FC5834F258C2377FBC33A335D' - 1000002]
    * DEBUG - Calling ITTAlgoritm postCreateTaskHook for task ['5A5C893B9CEE433F950B642710F7F1BC' - Damascus Cooking Knife - 1Ud - - - DOCK]...
    * INFO - Linking task ['5A5C893B9CEE433F950B642710F7F1BC' - Damascus Cooking Knife - 1Ud - - - DOCK] with order line ['2EF2236091D14650AA418FA94AF97B25' - 800011 - 50 - Damascus Cooking Knife - 10Ud - 10Ud - ]
    * DEBUG - Finished ITTAlgoritm postCreateTaskHook for task ['5A5C893B9CEE433F950B642710F7F1BC' - Damascus Cooking Knife - 1Ud - - - DOCK]
    * INFO - Not autoconfirming individual Task ['5A5C893B9CEE433F950B642710F7F1BC' - Damascus Cooking Knife - 1Ud - - - DOCK] based on the Routing configuration ['02057FB0EAF54435933DAE27C736C3D9' - to RCT, AutoConf - - Docking]
    * INFO - Created task ['BA5D8475827C49A68F32CE68862AAC93' - Damascus Cooking Knife - 1Ud - - - DOCK] linked to Batch of Tasks ['E343DF7FC5834F258C2377FBC33A335D' - 1000002]
    * DEBUG - Calling ITTAlgoritm postCreateTaskHook for task ['BA5D8475827C49A68F32CE68862AAC93' - Damascus Cooking Knife - 1Ud - - - DOCK]...
    * INFO - Linking task ['BA5D8475827C49A68F32CE68862AAC93' - Damascus Cooking Knife - 1Ud - - - DOCK] with order line ['2EF2236091D14650AA418FA94AF97B25' - 800011 - 50 - Damascus Cooking Knife - 10Ud - 10Ud - ]
    * DEBUG - Finished ITTAlgoritm postCreateTaskHook for task ['BA5D8475827C49A68F32CE68862AAC93' - Damascus Cooking Knife - 1Ud - - - DOCK]
    * INFO - Not autoconfirming individual Task ['BA5D8475827C49A68F32CE68862AAC93' - Damascus Cooking Knife - 1Ud - - - DOCK] based on the Routing configuration ['02057FB0EAF54435933DAE27C736C3D9' - to RCT, AutoConf - - Docking]
    * INFO - Created task ['1FD182F779D54AC1ABD837A52114A77E' - Damascus Cooking Knife - 1Ud - - - DOCK] linked to Batch of Tasks ['E343DF7FC5834F258C2377FBC33A335D' - 1000002]
    * DEBUG - Calling ITTAlgoritm postCreateTaskHook for task ['1FD182F779D54AC1ABD837A52114A77E' - Damascus Cooking Knife - 1Ud - - - DOCK]...
    * INFO - Linking task ['1FD182F779D54AC1ABD837A52114A77E' - Damascus Cooking Knife - 1Ud - - - DOCK] with order line ['2EF2236091D14650AA418FA94AF97B25' - 800011 - 50 - Damascus Cooking Knife - 10Ud - 10Ud - ]
    * DEBUG - Finished ITTAlgoritm postCreateTaskHook for task ['1FD182F779D54AC1ABD837A52114A77E' - Damascus Cooking Knife - 1Ud - - - DOCK]
    * INFO - Not autoconfirming individual Task ['1FD182F779D54AC1ABD837A52114A77E' - Damascus Cooking Knife - 1Ud - - - DOCK] based on the Routing configuration ['02057FB0EAF54435933DAE27C736C3D9' - to RCT, AutoConf - - Docking]
    * INFO - Created task ['588ACA97EE28465B91A5F7A059BB992B' - Damascus Cooking Knife - 1Ud - - - DOCK] linked to Batch of Tasks ['E343DF7FC5834F258C2377FBC33A335D' - 1000002]
    * DEBUG - Calling ITTAlgoritm postCreateTaskHook for task ['588ACA97EE28465B91A5F7A059BB992B' - Damascus Cooking Knife - 1Ud - - - DOCK]...
    * INFO - Linking task ['588ACA97EE28465B91A5F7A059BB992B' - Damascus Cooking Knife - 1Ud - - - DOCK] with order line ['2EF2236091D14650AA418FA94AF97B25' - 800011 - 50 - Damascus Cooking Knife - 10Ud - 10Ud - ]
    * DEBUG - Finished ITTAlgoritm postCreateTaskHook for task ['588ACA97EE28465B91A5F7A059BB992B' - Damascus Cooking Knife - 1Ud - - - DOCK]
    * INFO - Not autoconfirming individual Task ['588ACA97EE28465B91A5F7A059BB992B' - Damascus Cooking Knife - 1Ud - - - DOCK] based on the Routing configuration ['02057FB0EAF54435933DAE27C736C3D9' - to RCT, AutoConf - - Docking]
    * INFO - Created task ['0526F81EFE7B40FFBE55A759623805EC' - Damascus Cooking Knife - 1Ud - - - DOCK] linked to Batch of Tasks ['E343DF7FC5834F258C2377FBC33A335D' - 1000002]
    * DEBUG - Calling ITTAlgoritm postCreateTaskHook for task ['0526F81EFE7B40FFBE55A759623805EC' - Damascus Cooking Knife - 1Ud - - - DOCK]...
    * INFO - Linking task ['0526F81EFE7B40FFBE55A759623805EC' - Damascus Cooking Knife - 1Ud - - - DOCK] with order line ['2EF2236091D14650AA418FA94AF97B25' - 800011 - 50 - Damascus Cooking Knife - 10Ud - 10Ud - ]
    * DEBUG - Finished ITTAlgoritm postCreateTaskHook for task ['0526F81EFE7B40FFBE55A759623805EC' - Damascus Cooking Knife - 1Ud - - - DOCK]
    * INFO - Not autoconfirming individual Task ['0526F81EFE7B40FFBE55A759623805EC' - Damascus Cooking Knife - 1Ud - - - DOCK] based on the Routing configuration ['02057FB0EAF54435933DAE27C736C3D9' - to RCT, AutoConf - - Docking]
    * INFO - Created task ['71B93FC44BA644EEB28A9B85DD45F05B' - Damascus Cooking Knife - 1Ud - - - DOCK] linked to Batch of Tasks ['E343DF7FC5834F258C2377FBC33A335D' - 1000002]
    * DEBUG - Calling ITTAlgoritm postCreateTaskHook for task ['71B93FC44BA644EEB28A9B85DD45F05B' - Damascus Cooking Knife - 1Ud - - - DOCK]...
    * INFO - Linking task ['71B93FC44BA644EEB28A9B85DD45F05B' - Damascus Cooking Knife - 1Ud - - - DOCK] with order line ['2EF2236091D14650AA418FA94AF97B25' - 800011 - 50 - Damascus Cooking Knife - 10Ud - 10Ud - ]
    * DEBUG - Finished ITTAlgoritm postCreateTaskHook for task ['71B93FC44BA644EEB28A9B85DD45F05B' - Damascus Cooking Knife - 1Ud - - - DOCK]
    * INFO - Not autoconfirming individual Task ['71B93FC44BA644EEB28A9B85DD45F05B' - Damascus Cooking Knife - 1Ud - - - DOCK] based on the Routing configuration ['02057FB0EAF54435933DAE27C736C3D9' - to RCT, AutoConf - - Docking]
    * INFO - Created task ['8EB938BFAC3347E8ADAC1FEA7EF2A8C3' - Damascus Cooking Knife - 1Ud - - - DOCK] linked to Batch of Tasks ['E343DF7FC5834F258C2377FBC33A335D' - 1000002]
    * DEBUG - Calling ITTAlgoritm postCreateTaskHook for task ['8EB938BFAC3347E8ADAC1FEA7EF2A8C3' - Damascus Cooking Knife - 1Ud - - - DOCK]...
    * INFO - Linking task ['8EB938BFAC3347E8ADAC1FEA7EF2A8C3' - Damascus Cooking Knife - 1Ud - - - DOCK] with order line ['2EF2236091D14650AA418FA94AF97B25' - 800011 - 50 - Damascus Cooking Knife - 10Ud - 10Ud - ]
    * DEBUG - Finished ITTAlgoritm postCreateTaskHook for task ['8EB938BFAC3347E8ADAC1FEA7EF2A8C3' - Damascus Cooking Knife - 1Ud - - - DOCK]
    * INFO - Not autoconfirming individual Task ['8EB938BFAC3347E8ADAC1FEA7EF2A8C3' - Damascus Cooking Knife - 1Ud - - - DOCK] based on the Routing configuration ['02057FB0EAF54435933DAE27C736C3D9' - to RCT, AutoConf - - Docking]
    * INFO - Created task ['329E31F7A8DA456DB97CEEB960E9995C' - Damascus Cooking Knife - 1Ud - - - DOCK] linked to Batch of Tasks ['E343DF7FC5834F258C2377FBC33A335D' - 1000002]
    * DEBUG - Calling ITTAlgoritm postCreateTaskHook for task ['329E31F7A8DA456DB97CEEB960E9995C' - Damascus Cooking Knife - 1Ud - - - DOCK]...
    * INFO - Linking task ['329E31F7A8DA456DB97CEEB960E9995C' - Damascus Cooking Knife - 1Ud - - - DOCK] with order line ['2EF2236091D14650AA418FA94AF97B25' - 800011 - 50 - Damascus Cooking Knife - 10Ud - 10Ud - ]
    * DEBUG - Finished ITTAlgoritm postCreateTaskHook for task ['329E31F7A8DA456DB97CEEB960E9995C' - Damascus Cooking Knife - 1Ud - - - DOCK]
    * INFO - Not autoconfirming individual Task ['329E31F7A8DA456DB97CEEB960E9995C' - Damascus Cooking Knife - 1Ud - - - DOCK] based on the Routing configuration ['02057FB0EAF54435933DAE27C736C3D9' - to RCT, AutoConf - - Docking]
    * DEBUG - Calling ITTAlgoritm transformFromReservedToAvailableHook...
    * DEBUG - Finished ITTAlgoritm transformFromReservedToAvailableHook
    * DEBUG - Calling ITTAlgoritm postProcessHook...
    * DEBUG - Updated task property [receptionList] with value ['BEDA6DBD0E544F2B97F94D8FD8D3A401' - Reception List - RECLST1000002] in Batch of Tasks ['E343DF7FC5834F258C2377FBC33A335D' - 1000002]. Affected tasks: [10]
    * INFO - Created Document ['BEDA6DBD0E544F2B97F94D8FD8D3A401' - Reception List - RECLST1000002] with [10] task(s)
    * DEBUG - Finished ITTAlgoritm postProcessHook
    * DEBUG - Autoconfirming tasks linked to an auto-confirm Routing (if any)
    * DEBUG - Autoconfirming tasks: [0BA8827C5C074E8EB76692C972387269,B4620B77D90042C6B7CDB84148D35D76,5A5C893B9CEE433F950B642710F7F1BC,BA5D8475827C49A68F32CE68862AAC93,1FD182F779D54AC1ABD837A52114A77E,588ACA97EE28465B91A5F7A059BB992B,0526F81EFE7B40FFBE55A759623805EC,71B93FC44BA644EEB28A9B85DD45F05B,8EB938BFAC3347E8ADAC1FEA7EF2A8C3,329E31F7A8DA456DB97CEEB960E9995C]...
  * ERROR - Error detected in Central Broker: ERROR DETECTED: The confirmed attribute can not be null for product Damascus Cooking Knifeorg.openbravo.base.exception.OBException: The confirmed attribute can not be null for product Damascus Cooking Knife
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.TaskValidator.checkConfirmedAttributeIsProvidedIfRequired(TaskValidator.java:119)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.TaskValidator.validate(TaskValidator.java:59)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.TaskConfirmator.prevalidateProcessTask(TaskConfirmator.java:56)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.GroupOfTasksConfirmator.validateTasksAndAddLinesToTransactionDoc(GroupOfTasksConfirmator.java:247)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.GroupOfTasksConfirmator.addTasksToTransactionDocLinesAndProcessIt(GroupOfTasksConfirmator.java:221)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.GroupOfTasksConfirmator.processGroupOfTasks(GroupOfTasksConfirmator.java:123)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.GroupOfTasksConfirmator.processGroupOfTasksDocument(GroupOfTasksConfirmator.java:103)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.CentralBroker.processGroupOfTasks(CentralBroker.java:234)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.AutoConfirmatorBehaveAsGroupTasks.confirmEachGroupOfTasks(AutoConfirmatorBehaveAsGroupTasks.java:94)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.AutoConfirmatorBehaveAsGroupTasks.autoConfirmBehaveAsGroupTaskBasedOnRoutingConfiguration(AutoConfirmatorBehaveAsGroupTasks.java:52)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.AutoConfirmatorBehaveAsGroupTasks.run(AutoConfirmatorBehaveAsGroupTasks.java:41)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.InventoryTransactionTypeAlgorithm.executeAlgorithm(InventoryTransactionTypeAlgorithm.java:246)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.BatchOfTasksGenerator.createBatchOfTasksUsingItt(BatchOfTasksGenerator.java:183)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.BatchOfTasksGenerator.createBatchOfTasksIfIttAlgorithmInstanceFound(BatchOfTasksGenerator.java:138)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.BatchOfTasksGenerator.run(BatchOfTasksGenerator.java:104)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.CentralBroker.doTheStuff(CentralBroker.java:155)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.CentralBroker.doTheStuff(CentralBroker.java:105)
    at org.openbravo.warehouse.advancedwarehouseoperations.handler.GenerateReceptionOrIssueListFromOrderHandler.exec(GenerateReceptionOrIssueListFromOrderHandler.java:34)
    at org.openbravo.warehouse.advancedwarehouseoperations.handler.OBAWO_BaseProcessActionHandler.doExecute(OBAWO_BaseProcessActionHandler.java:43)
    at org.openbravo.client.application.process.BaseProcessActionHandler.execute(BaseProcessActionHandler.java:148)
    at org.openbravo.client.kernel.BaseActionHandler.execute(BaseActionHandler.java:73)
    at org.openbravo.client.kernel.KernelServlet.processActionRequest(KernelServlet.java:314)
    at org.openbravo.client.kernel.KernelServlet.doGet(KernelServlet.java:206)
    at org.openbravo.client.kernel.KernelServlet.doPost(KernelServlet.java:287)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:228)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:462)
    at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:87)
    at org.openbravo.client.kernel.BaseKernelServlet.service(BaseKernelServlet.java:58)
    at org.openbravo.client.kernel.KernelServlet.service(KernelServlet.java:168)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
    at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
    at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:193)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)
    at java.lang.Thread.run(Thread.java:748)

  * INFO - Rollback successfully executed
 * INFO - Total time spent: 1271 ms
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0099969)
vmromanos (manager)
2017-10-19 18:21

 The system behaves properly.

It detects 2 Routing Assignments:
1. The one with Product Category filter
2. The one without filters

It takes the first routing assignment because it matches the Product Category "Services". See the verbosity log:
 * INFO - Setting Product and Product Category related info...
      * INFO - Product ['0FAC7DFDC9484B30B35665ECF3D03BFB' - Damascus Cooking Knife - Services - Ud - Utensils - ]; Product Category ['4028E6C72959682B01295ADC0BB10216' - Services]; Requires Serial No. Split [true]


This Routing Assignment is set to Automatic Confirmation, so the system generates and confirms the tasks.
However, since this product requires an attribute, the confirmation fails and the task generation is rollback.

Here you have 2 possible solutions:
1. Set a Routing Assignment with a Manual confirmation routing, so you can specify the attribute before confirming the task.

2. Set a default attribute to the product

- Issue History
Date Modified Username Field Change
2017-10-19 17:44 plujan New Issue
2017-10-19 17:44 plujan Assigned To => Triage Finance
2017-10-19 17:44 plujan Modules => Core
2017-10-19 17:44 plujan Triggers an Emergency Pack => No
2017-10-19 18:16 vmromanos Assigned To Triage Finance => vmromanos
2017-10-19 18:16 vmromanos Status new => scheduled
2017-10-19 18:21 vmromanos Review Assigned To => vmromanos
2017-10-19 18:21 vmromanos Note Added: 0099969
2017-10-19 18:21 vmromanos Status scheduled => closed
2017-10-19 18:21 vmromanos Resolution open => no change required

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker