Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0037123Openbravo ERP04. Warehouse managementpublic2017-10-19 17:442017-10-19 18:21
plujan 
vmromanos 
normalminorhave not tried
closedno change required 
5
 
 
vmromanos
Core
No
0037123: [PR17Q4][AWO] More than one routing matching a reception generates an error
I 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.
1. 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
No tags attached.
Issue History
2017-10-19 17:44plujanNew Issue
2017-10-19 17:44plujanAssigned To => Triage Finance
2017-10-19 17:44plujanModules => Core
2017-10-19 17:44plujanTriggers an Emergency Pack => No
2017-10-19 18:16vmromanosAssigned ToTriage Finance => vmromanos
2017-10-19 18:16vmromanosStatusnew => scheduled
2017-10-19 18:21vmromanosReview Assigned To => vmromanos
2017-10-19 18:21vmromanosNote Added: 0099969
2017-10-19 18:21vmromanosStatusscheduled => closed
2017-10-19 18:21vmromanosResolutionopen => no change required

Notes
(0099969)
vmromanos   
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