Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032292Openbravo ERPA. Platformpublic2016-02-19 13:152016-03-17 10:56
Reportercaristu 
Assigned Tocaristu 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q2 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032292: "OBSERDS_RoleHasNoFieldAccess" error thrown with specific role definition in Field tab
DescriptionIf you define a role with NO access to the Field tab (in Windows, Tabs and Field window) but access to an specific field, the following error is thrown when trying to save the edition:
"Saving failed. ***role*** does not have access to the field Creation Date"
Steps To Reproduce1. Create a System Admin manual role
2. Give read only access to Windows Tabs And Fields > Field
3. Give edit access to Description field
4. Using that role
5. Open any existing Window
6. Edit description for any field where Record Sort No. is empty and save
Proposed SolutionThe problem is caused because the Field tab has a field for the Creation audit column. This field should be removed as audit columns should not have a field in the AD. They are generated automatically.
Additional Information
TagsNo tags attached.
Relationships
related to defect 00322313.0PR16Q2 closed caristu "OBSERDS_RoleHasNoFieldAccess" error thrown with specific role definition and Total Gross Amount with no decimals 
related to defect 0032354 closed alostale field edit access doesn't allow to save if tab contains audit fields in its AD definition 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-02-19 13:15caristuNew Issue
2016-02-19 13:15caristuAssigned To => caristu
2016-02-19 13:15caristuModules => Core
2016-02-19 13:15caristuTriggers an Emergency Pack => No
2016-02-19 13:16caristuRelationship addedrelated to 0032231
2016-02-19 13:23hgbotCheckin
2016-02-19 13:23hgbotNote Added: 0084369
2016-02-19 13:23hgbotStatusnew => resolved
2016-02-19 13:23hgbotResolutionopen => fixed
2016-02-19 13:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e408f8f90401413e81fc2e1be92a997d189deffc [^]
2016-02-19 13:24caristuReview Assigned To => alostale
2016-02-19 13:24caristuIssue Monitored: alostale
2016-02-19 14:34hgbotCheckin
2016-02-19 14:34hgbotNote Added: 0084375
2016-02-26 08:54alostaleRelationship addedrelated to 0032354
2016-02-26 09:07alostaleNote Added: 0084540
2016-02-26 09:07alostaleStatusresolved => closed
2016-02-26 09:07alostaleFixed in Version => 3.0PR16Q2
2016-03-15 15:52hgbotCheckin
2016-03-15 15:52hgbotNote Added: 0084990
2016-03-17 10:56hudsonbotCheckin
2016-03-17 10:56hudsonbotNote Added: 0085158

Notes
(0084369)
hgbot   
2016-02-19 13:23   
Repository: erp/devel/pi
Changeset: e408f8f90401413e81fc2e1be92a997d189deffc
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Fri Feb 19 13:22:52 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e408f8f90401413e81fc2e1be92a997d189deffc [^]

fixes issue 32292: access error in Field tab with specific role when saving

The problem is caused because the Field tab has a field for the Creation audit column. This field should be removed as audit columns should not have a field in the AD. They are generated automatically.

---
M src-db/database/sourcedata/AD_FIELD.xml
---
(0084375)
hgbot   
2016-02-19 14:34   
Repository: erp/devel/api-checks
Changeset: deb4aa37c11c54741b5e91e0b69d9e7d40dc9c93
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Fri Feb 19 14:32:15 2016 +0100
URL: http://code.openbravo.com/erp/devel/api-checks/rev/deb4aa37c11c54741b5e91e0b69d9e7d40dc9c93 [^]

related to issue 32292: remove 'Creation Date' field of 'Field' tab

---
M model/src-db/database/sourcedata/AD_FIELD.xml
---
(0084540)
alostale   
2016-02-26 09:07   
code reviewed


Though the changeset is correct and it's not necessary to explicitly define audit fields in tabs because they are generated in any case and it fix the described problem for this concrete window, a more generic fix has also been implemented in 0032354 to prevent this error to be thrown for any tab in this situation without the need of removing audit fields from AD nor granting edit access to them.
(0084990)
hgbot   
2016-03-15 15:52   
Repository: erp/devel/api-checks
Changeset: c87271eab9e7d697c09182f58490b8ee34843833
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Tue Mar 15 15:51:28 2016 +0100
URL: http://code.openbravo.com/erp/devel/api-checks/rev/c87271eab9e7d697c09182f58490b8ee34843833 [^]

related to issue 32292: remove 'Creation Date' field of 'Field' tab

---
M model/src-db/database/sourcedata/AD_FIELD.xml
---
(0085158)
hudsonbot   
2016-03-17 10:56   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b22fb0500156 [^]
Maturity status: Test