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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0038806
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Advanced Warehouse Operationsmajoralways2018-06-21 13:062018-09-17 08:32
ReportergorkaionView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisioncb617b609f11
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned Todmiguelez
Regression introduced in release
Summary

0038806: ADSequence not accessible error when creating Picking Tasks for DO Issue

DescriptionWhen using a role with user level Organization it is not possible to generate the Picking Tasks of a DO Issue if the ADSequence to be used is created in the * organization.


This is the stacktrace from the logs:

2018-06-19 14:49:08,380 [ajp-bio-127.0.0.1-8009-exec-1] ERROR org.openbravo.warehouse.advancedwarehouseoperations.handler.OBAWO_BaseProcessActionHandler - Error in a OBAWO_BaseProcessActionHandler process
org.openbravo.base.exception.OBSecurityException: Organization 0 of object (ADSequence(FEECADC07DC647EE9DCD83925B838F07) (name: Issue List Sequence)) is not present in OrganizationList [4E17B96D63184BC3A4208DA4A9FD85CA, 2577FC4107D04AC18B5C8C29F464D179]
        at org.openbravo.dal.security.SecurityChecker.checkWriteAccess(SecurityChecker.java:166)
        at org.openbravo.dal.security.SecurityChecker.checkWriteAccess(SecurityChecker.java:105)
        at org.openbravo.dal.core.OBInterceptor.doEvent(OBInterceptor.java:350)
        at org.openbravo.dal.core.OBInterceptor.onFlushDirty(OBInterceptor.java:186)
        at org.hibernate.event.def.DefaultFlushEntityEventListener.invokeInterceptor(DefaultFlushEntityEventListener.java:372)
        at org.hibernate.event.def.DefaultFlushEntityEventListener.handleInterception(DefaultFlushEntityEventListener.java:349)
        at org.hibernate.event.def.DefaultFlushEntityEventListener.scheduleUpdate(DefaultFlushEntityEventListener.java:287)
        at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:155)
        at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:219)
        at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:99)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
        at org.openbravo.dal.service.OBDal.flush(OBDal.java:260)
        at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.InventoryTransactionTypeAlgorithm.updatesTasksProperty(InventoryTransactionTypeAlgorithm.java:322)
        at org.openbravo.warehouse.advancedwarehouseoperations.ittalgorithm.ReceiptOrIssue_ITT.createReceptionOrIssueList(ReceiptOrIssue_ITT.java:60)
        at org.openbravo.warehouse.advancedwarehouseoperations.ittalgorithm.ReceiptOrIssue_ITT.postCreateTasksHook(ReceiptOrIssue_ITT.java:47)
        at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.PostCreateTasksHookRunner.callPostCreatesTaskHook(PostCreateTasksHookRunner.java:43)
        at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.PostCreateTasksHookRunner.postProcessHookInternal(PostCreateTasksHookRunner.java:32)
        at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.PostCreateTasksHookRunner.run(PostCreateTasksHookRunner.java:27)
        at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.InventoryTransactionTypeAlgorithm.executeAlgorithm(InventoryTransactionTypeAlgorithm.java:227)
        at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.BatchOfTasksGenerator.createBatchOfTasksUsingItt(BatchOfTasksGenerator.java:193)
        at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.BatchOfTasksGenerator.createBatchOfTasksIfIttAlgorithmInstanceFound(BatchOfTasksGenerator.java:148)
        at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.BatchOfTasksGenerator.run(BatchOfTasksGenerator.java:114)
        at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.CentralBroker.doTheStuff(CentralBroker.java:156)
        at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.CentralBroker.doTheStuff(CentralBroker.java:106)
        at org.openbravo.warehouse.advancedwarehouseoperations.distributionorders.handler.GenerateReceptionOrIssueListFromDistributionOrderHandler.exec(GenerateReceptionOrIssueListFromDistributionOrderHandler.java:37)
        at org.openbravo.warehouse.advancedwarehouseoperations.handler.OBAWO_BaseProcessActionHandler.doExecute(OBAWO_BaseProcessActionHandler.java:43)
        at org.openbravo.client.application.process.BaseProcessActionHandler.execute(BaseProcessActionHandler.java:149)
        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)
Steps To ReproduceCreate a DO Issue and try to create the Picking Tasks using a role with user level Organization.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0038778 closeddmiguelez n.p.e when creating Picking Tasks for DO Issue with more than 100 lines 

-  Notes
(0105680)
Sandrahuguet (developer)
2018-07-09 16:01

Detailed steps to reproduce required
(0105746)
dmiguelez (developer)
2018-07-16 11:22

Steps to reproduce:

With AWO and AWO SampleData installed

Log in as AWO QA Admin

Go to Role Window and select the record with name: FE_West_Users
Change the User Level from Client+Organization to Organization

Go to Distribution Order Issue Window and create a new record with:
  - Organization: US West Coast
  - Warehouse Issue: US West Coast
  - Warehouse Receipt: US East Coast
Move to lines and create a new record with:
  - Product: Ale Beer
  - Operative Quantity: 10
Book the Document

In the Front End log in as AWO_US_W/openbravo
Click on Pick and set the DocumentNo from the previously created DO Issue.
There is an error and the tasks are not created.

To reproduce the same problem in the BackEnd:
Go to Role Window and select the record with name: FE_West_Users
Move the Window Access and create a new record with:
  - Window: Distribution Order Issue
  - Editable Field: Yes

Log in as AWO_US_W/openbravo
Go to Distribution Order Issue Window and select the previously created record.
Click on Pick button.
(0105904)
hgbot (developer)
2018-07-24 12:06

Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: a99e808fcec1f38d942cb0cf5cc12f5cbab81a46
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jul 24 12:06:23 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/a99e808fcec1f38d942cb0cf5cc12f5cbab81a46 [^]

Fixes Issue 38806. Added setAdminMode(false) when creating the different Lists
(Pick, Inventory, Issue and Reception)

Since the list can be created for an organization that the user has not
explicit access, it is needed to use the setAdminMode without enforcing
the Organization access check.

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/Count_ITT.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/Picking_ITT.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/ReceiptOrIssue_ITT.java
---
(0105905)
dmiguelez (developer)
2018-07-24 12:08

Test Plan:

With AWO and AWO SampleData installed

Log in as AWO QA Admin

Go to Role Window and select the record with name: FE_West_Users
Change the User Level from Client+Organization to Organization

Go to Distribution Order Issue Window and create a new record with:
  - Organization: US West Coast
  - Warehouse Issue: US West Coast
  - Warehouse Receipt: US East Coast
Move to lines and create a new record with:
  - Product: Ale Beer
  - Operative Quantity: 10
Book the Document

In the Front End log in as AWO_US_W/openbravo
Click on Pick and set the DocumentNo from the previously created DO Issue.
The Tasks are created.

To reproduce the same problem in the BackEnd:
Go to Role Window and select the record with name: FE_West_Users
Move the Window Access and create a new record with:
  - Window: Distribution Order Issue
  - Editable Field: Yes

Log in as AWO_US_W/openbravo
Go to Distribution Order Issue Window and select the previously created record.
Click on Pick button.
Tasks are created if they were not previously
(0105906)
dmiguelez (developer)
2018-07-24 12:08

Code Review + Testing Ok
(0105907)
hgbot (developer)
2018-07-24 12:24

Repository: retail/backports/AWO/3.0RR18Q1/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: d959802ff1a33ee5efad28e373b7706463a3954c
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jul 24 12:06:23 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q1/org.openbravo.warehouse.advancedwarehouseoperations/rev/d959802ff1a33ee5efad28e373b7706463a3954c [^]

Related to Issue 38806. Added setAdminMode(false) when creating the different Lists
(Pick, Inventory, Issue and Reception)

Since the list can be created for an organization that the user has not
explicit access, it is needed to use the setAdminMode without enforcing
the Organization access check.

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/Count_ITT.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/Picking_ITT.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/ReceiptOrIssue_ITT.java
---
(0105908)
hgbot (developer)
2018-07-24 12:24

Repository: retail/backports/AWO/3.0RR17Q4/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: 991c8b69b89594f93c2606cc48fc02baa1972269
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jul 24 12:06:23 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR17Q4/org.openbravo.warehouse.advancedwarehouseoperations/rev/991c8b69b89594f93c2606cc48fc02baa1972269 [^]

Related to Issue 38806. Added setAdminMode(false) when creating the different Lists
(Pick, Inventory, Issue and Reception)

Since the list can be created for an organization that the user has not
explicit access, it is needed to use the setAdminMode without enforcing
the Organization access check.

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/Count_ITT.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/Picking_ITT.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/ReceiptOrIssue_ITT.java
---
(0106531)
hgbot (developer)
2018-08-30 10:19

Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: cb617b609f113b8189b91a8e92cc6db90d33fe97
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jul 24 12:06:23 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/cb617b609f113b8189b91a8e92cc6db90d33fe97 [^]

Fixes Issue 38806. Added setAdminMode(false) when creating the different Lists
(Pick, Inventory, Issue and Reception)

Since the list can be created for an organization that the user has not
explicit access, it is needed to use the setAdminMode without enforcing
the Organization access check.

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/Count_ITT.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/Picking_ITT.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/ReceiptOrIssue_ITT.java
---
(0106779)
hgbot (developer)
2018-09-14 14:56

Repository: retail/backports/AWO/3.0RR18Q3/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: cb617b609f113b8189b91a8e92cc6db90d33fe97
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jul 24 12:06:23 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q3/org.openbravo.warehouse.advancedwarehouseoperations/rev/cb617b609f113b8189b91a8e92cc6db90d33fe97 [^]

Fixes Issue 38806. Added setAdminMode(false) when creating the different Lists
(Pick, Inventory, Issue and Reception)

Since the list can be created for an organization that the user has not
explicit access, it is needed to use the setAdminMode without enforcing
the Organization access check.

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/Count_ITT.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/Picking_ITT.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/ittalgorithm/ReceiptOrIssue_ITT.java
---
(0106793)
dmiguelez (developer)
2018-09-17 08:32

Code Review + Testing Ok

- Issue History
Date Modified Username Field Change
2018-06-21 13:06 gorkaion New Issue
2018-06-21 13:06 gorkaion Assigned To => dmiguelez
2018-06-21 13:06 gorkaion Resolution time => 1531346400
2018-06-21 13:06 gorkaion Issue generated from 0038778
2018-06-21 13:06 gorkaion Relationship added related to 0038778
2018-07-04 08:39 Sandrahuguet Assigned To dmiguelez => AtulOpenbravo
2018-07-05 21:57 AtulOpenbravo Status new => scheduled
2018-07-09 16:01 Sandrahuguet Note Added: 0105680
2018-07-09 16:01 Sandrahuguet Assigned To AtulOpenbravo => gorkaion
2018-07-09 16:01 Sandrahuguet Status scheduled => feedback
2018-07-11 09:53 Sandrahuguet Resolution time 1531346400 => 1531951200
2018-07-12 08:39 Sandrahuguet Assigned To gorkaion => AtulOpenbravo
2018-07-16 11:22 dmiguelez Note Added: 0105746
2018-07-16 11:24 aferraz Status feedback => new
2018-07-19 10:21 AtulOpenbravo Status new => scheduled
2018-07-24 12:06 hgbot Checkin
2018-07-24 12:06 hgbot Note Added: 0105904
2018-07-24 12:06 hgbot Status scheduled => resolved
2018-07-24 12:06 hgbot Resolution open => fixed
2018-07-24 12:06 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/a99e808fcec1f38d942cb0cf5cc12f5cbab81a46 [^]
2018-07-24 12:08 dmiguelez Note Added: 0105905
2018-07-24 12:08 dmiguelez Review Assigned To => dmiguelez
2018-07-24 12:08 dmiguelez Note Added: 0105906
2018-07-24 12:08 dmiguelez Status resolved => closed
2018-07-24 12:24 hgbot Checkin
2018-07-24 12:24 hgbot Note Added: 0105907
2018-07-24 12:24 hgbot Checkin
2018-07-24 12:24 hgbot Note Added: 0105908
2018-08-30 10:19 hgbot Checkin
2018-08-30 10:19 hgbot Note Added: 0106531
2018-08-30 10:19 hgbot Status closed => resolved
2018-08-30 10:19 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/a99e808fcec1f38d942cb0cf5cc12f5cbab81a46 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/cb617b609f113b8189b91a8e92cc6db90d33fe97 [^]
2018-08-31 14:59 Sandrahuguet Status resolved => closed
2018-09-14 14:56 hgbot Checkin
2018-09-14 14:56 hgbot Note Added: 0106779
2018-09-14 14:56 hgbot Status closed => resolved
2018-09-14 14:56 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/cb617b609f113b8189b91a8e92cc6db90d33fe97 [^] => http://code.openbravo.com/retail/backports/AWO/3.0RR18Q3/org.openbravo.warehouse.advancedwarehouseoperations/rev/cb617b609f113b8189b91a8e92cc6db90d33fe97 [^]
2018-09-17 08:32 dmiguelez Note Added: 0106793
2018-09-17 08:32 dmiguelez Status resolved => closed
2022-09-06 17:18 caristu Category Advance Warehouse Operations => Advanced Warehouse Operations


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker