Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006402Openbravo ERP01. General setuppublic2008-12-08 22:152009-04-21 12:36
Reporterjreymol 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006402: After creating role in Test Case ID 994 userA cannot log in
DescriptionAfter completing Test Case ID 994 I tried to log in as userA unsuccessfully.

In openbravo.log I can see:

21:05:19 [ajp-8009-3] ERROR org.openbravo.base.exception.OBSecurityException - Entity AD_OrgType is not readable by this user
org.openbravo.base.exception.OBSecurityException: Entity AD_OrgType is not readable by this user
    at org.openbravo.dal.security.EntityAccessChecker.checkReadable(EntityAccessChecker.java:286)
    at org.openbravo.dal.service.OBDal.checkReadAccess(OBDal.java:354)
    at org.openbravo.dal.service.OBDal.checkReadAccess(OBDal.java:349)
    at org.openbravo.dal.service.OBDal.get(OBDal.java:140)
    at org.openbravo.base.secureApp.OrgTreeNode.<init>(OrgTreeNode.java:40)
    at org.openbravo.base.secureApp.OrgTreeNode.createTree(OrgTreeNode.java:64)
    at org.openbravo.base.secureApp.OrgTree.<init>(OrgTree.java:37)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:227)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:27)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:83)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:48)
    at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:89)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:419)
    at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:378)
    at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509)
    at java.lang.Thread.run(Thread.java:619)
21:05:19 [ajp-8009-3] ERROR org.openbravo.base.secureApp.DefaultOptionsData - SQL error in query: SELECT TO_CHAR(MIN(M_WAREHOUSE_ID)) AS DEFAULT_M_WAREHOUSE_ID FROM M_WAREHOUSE WHERE AD_CLIENT_ID = ? AND ISACTIVE = 'Y' AND AD_Org_ID IN() Exception:org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
21:05:19 [ajp-8009-3] ERROR org.openbravo.erpCommon.security.Menu - javax.servlet.ServletException: @CODE=0@ERROR: syntax error at or near ")"
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0006530 closed shuehner userA cannot see General Setup - Security - User 
related to defect 0007002 closed shuehner When changing from a not superuser role to a superuser role changing the role does not work 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-08 22:15jreymolNew Issue
2008-12-08 22:15jreymolAssigned To => rafaroda
2008-12-08 22:15jreymolsf_bug_id0 => 2407583
2008-12-09 12:11jreymolNote Added: 0011049
2008-12-09 12:25pheenanAssigned Torafaroda => pheenan
2008-12-09 12:25pheenanStatusnew => scheduled
2008-12-09 12:25pheenanfix_in_branch => trunk
2008-12-14 20:40jreymolNote Added: 0011324
2009-01-09 15:28rafarodaRelationship addedrelated to 0006530
2009-01-09 15:29rafarodaAssigned Topheenan => shuehner
2009-01-12 17:47svnbotCheckin
2009-01-12 17:47svnbotNote Added: 0012119
2009-01-12 17:47svnbotStatusscheduled => resolved
2009-01-12 17:47svnbotResolutionopen => fixed
2009-01-12 17:47svnbotsvn_revision => 11801
2009-01-19 15:22shuehnerRelationship addedrelated to 0007002
2009-04-21 12:36psarobeStatusresolved => closed

Notes
(0011049)
jreymol   
2008-12-09 12:11   
I have deleted role Sales from userA and now I can login again
(0011324)
jreymol   
2008-12-14 20:40   
With Alpha-R4 I could complete this test case. Also I hit a new issue: 0006530: userA cannot see General Setup - Security - User
(0012119)
svnbot   
2009-01-12 17:47   
Repository: openbravo
Revision: 11801
Author: huehner
Date: 2009-01-12 17:47:24 +0100 (Mon, 12 Jan 2009)

Fixed 6402
Enable admin-mode for system level generation of
accessible organisation, as restricted user account
does not have the required access itself.

---
U trunk/src/org/openbravo/base/secureApp/HttpSecureAppServlet.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=11801&sc=1 [^]