Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037294Openbravo ERPA. Platformpublic2017-11-14 13:452017-11-17 15:34
Reportermalsasua 
Assigned Toinigosanchez 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR17Q3.2Fixed in Version3.0PR17Q3.2 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - QA Approved
Regression date2017-04-06
Regression introduced in release3.0PR17Q3
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/c4a5973bba10 [^]
Triggers an Emergency PackNo
Summary0037294: It is not possible to do login using a role if the role has got a deactivated organization
Descriptionwhen a role has got one deactivate organization, in Role > Org Access, it is not possible to do login. Error is returned:
Error occured: org.openbravo.base.exception.OBException: java.lang.IllegalArgumentException: Error when saving default values
Steps To Reproducein F&B:
. do login with user Openbravo
. go to Role:
  . record: F&B España, S.A - Employee
  . go to org access tab:
     . record: F&B España - Región Norte
       active='N'
. change the role to F&B España, S.A - Employee
Error is returned
Proposed SolutionTake into account the "is active" flag in the queries launched by RoleInfo class. Since the changeset[1] it is using a Query instead of an OBQuery to retrieve the role's organization and warehouses data.

[1] https://code.openbravo.com/erp/devel/pi/rev/c4a5973bba10 [^]
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0037289 closed inigosanchez It is not possible to do login using a role if the role has got a deactivated organization 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-11-14 18:22caristuTypedefect => backport
2017-11-14 18:22caristuTarget Version => 3.0PR17Q3.2
2017-11-16 10:12inigosanchezAssigned Toplatform => inigosanchez
2017-11-16 12:36hgbotCheckin
2017-11-16 12:36hgbotNote Added: 0100549
2017-11-16 12:36hgbotStatusscheduled => resolved
2017-11-16 12:36hgbotResolutionopen => fixed
2017-11-16 12:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR17Q3.2/rev/97ccc65883ae6d6fcf9c0f3fe01d14655ca71d3c [^]
2017-11-16 16:45caristuSeveritymajor => minor
2017-11-17 15:34caristuNote Added: 0100596
2017-11-17 15:34caristuStatusresolved => closed
2017-11-17 15:34caristuFixed in Version => 3.0PR17Q3.2

Notes
(0100549)
hgbot   
2017-11-16 12:36   
Repository: erp/backports/3.0PR17Q3.2
Changeset: 97ccc65883ae6d6fcf9c0f3fe01d14655ca71d3c
Author: Inigo Sanchez <inigo.sanchez <at> openbravo.com>
Date: Thu Nov 16 12:36:03 2017 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR17Q3.2/rev/97ccc65883ae6d6fcf9c0f3fe01d14655ca71d3c [^]

Fixed issue 37294: Deactivated orgs are displayed in the user profile widget

The problem was caused by the "Improve scalability of the login process" project. When improving the performance
of the query that return the complete organizations list for the current user, the OBQuery instance used to generate it was
replaced with a Query instance. The first includes by default the filter by is active.

To fix the problem this filter must be added manually in the query. Now the problem has been resolved by take into
account this filter. Besides the same problem is detected in other query related with deactivated warehouses so it is fixed too.

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/navigationbarcomponents/RoleInfo.java
---
(0100596)
caristu   
2017-11-17 15:34   
Code reviewed + tested OK.