Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036254Openbravo ERPA. Platformpublic2017-06-14 12:352017-06-23 13:14
ReporterAsantos9 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q3 
Merge Request Status
Review Assigned Toinigosanchez
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0036254: An exception is logged with a process request defined as an organization distinct from *
DescriptionDefine a process request as an organization distinct from *. Execute it. When the process is finished, open the last record created on Process Monitor subtab.

Note that the following exception has been logged:

2017-06-14 10:58:55,505 [ajp-bio-127.0.0.1-8009-exec-126] ERROR org.openbravo.base.exception.OBSecurityException - Entity ProcessExecution may only have instances with organization *
org.openbravo.base.exception.OBSecurityException: Entity ProcessExecution may only have instances with organization *
    at org.openbravo.base.validation.AccessLevelChecker.failOnNonZeroOrg(AccessLevelChecker.java:122)
    at org.openbravo.base.validation.AccessLevelChecker$2.checkAccessLevel(AccessLevelChecker.java:66)
    at org.openbravo.base.model.Entity.checkAccessLevel(Entity.java:339)
    at org.openbravo.dal.security.SecurityChecker.checkWriteAccess(SecurityChecker.java:174)
    at org.openbravo.dal.security.SecurityChecker.isWritable(SecurityChecker.java:89)
    at org.openbravo.client.application.window.FormInitializationComponent.buildJSONObject(FormInitializationComponent.java:542)

It seems that the error is related with the data access level defined for the ad_process_run and ad_process_request tables.
Steps To Reproduce1. Log into ERP
2. Go to Process Request window
3. Create a record with an organization distinct from *
4. Execute it
5. Open on form view the last record created on Process Monitor subtab related to the process request created previously.
6. Go to the console log and see that the exception has logged
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks design defect 0036162 acknowledged Triage Platform Base clean up openbravo.log 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-06-14 12:35Asantos9New Issue
2017-06-14 12:35Asantos9Assigned To => platform
2017-06-14 12:35Asantos9Web browser => Google Chrome
2017-06-14 12:35Asantos9Modules => Core
2017-06-14 12:35Asantos9Triggers an Emergency Pack => No
2017-06-14 12:54Asantos9Web browserGoogle Chrome => Google Chrome
2017-06-14 12:54Asantos9Resolution time => 1498600800
2017-06-14 12:55Asantos9Web browserGoogle Chrome => Google Chrome
2017-06-16 11:45alostaleWeb browserGoogle Chrome => Google Chrome
2017-06-16 11:45alostaleSummaryAn exception is thrown with a process request defined as an organization distinct from * => An exception is logged with a process request defined as an organization distinct from *
2017-06-16 11:45alostaleDescription Updatedbug_revision_view_page.php?rev_id=15371#r15371
2017-06-16 11:45alostaleSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15373#r15373
2017-06-16 11:45alostaleAssigned Toplatform => alostale
2017-06-16 11:45alostaleRelationship addedblocks 0036162
2017-06-16 11:47alostaleReview Assigned To => inigosanchez
2017-06-16 11:47alostaleWeb browserGoogle Chrome => Google Chrome
2017-06-16 11:54hgbotCheckin
2017-06-16 11:54hgbotNote Added: 0097439
2017-06-16 11:54hgbotStatusnew => resolved
2017-06-16 11:54hgbotResolutionopen => fixed
2017-06-16 11:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7867fc84869e7ab4ac252333243e66c6b4b16bd5 [^]
2017-06-16 19:02hudsonbotCheckin
2017-06-16 19:02hudsonbotNote Added: 0097461
2017-06-23 13:14inigosanchezNote Added: 0097608
2017-06-23 13:14inigosanchezStatusresolved => closed
2017-06-23 13:14inigosanchezFixed in Version => 3.0PR17Q3

Notes
(0097439)
hgbot   
2017-06-16 11:54   
Repository: erp/devel/pi
Changeset: 7867fc84869e7ab4ac252333243e66c6b4b16bd5
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Jun 16 11:53:16 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7867fc84869e7ab4ac252333243e66c6b4b16bd5 [^]

fixed bug 36254: exception logged for process executions created in non * org

  When a process request is created in a non * organization, it creates an
  AD_Process_Run record in its same organization, which is correct. But when
  opening in form view the corresponding execution an exception was logged.

  The problem was AD_Process_Run and AD_Process_Execution_V where incorrectly
  defined with "System/Client" Data Acces Level even their records can be craeted
  at any level (DAL is not used in this case, so its not prevented).

  Fixed by setting "All" Data Access Level to both.

---
M src-db/database/sourcedata/AD_TABLE.xml
---
(0097461)
hudsonbot   
2017-06-16 19:02   
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/38c05e8441a9 [^]
Maturity status: Test
(0097608)
inigosanchez   
2017-06-23 13:14   
Tested and verified in pi@d816955a96eb