0006402: After creating role in Test Case ID 994 userA cannot log in

Description

After 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 ")"

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

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

Notes
(0011049) jreymol (reporter) 2008-12-09 12:11	I have deleted role Sales from userA and now I can login again

(0011324) jreymol (reporter) 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 (reporter) 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 [^]

Issue History
Date Modified	Username	Field	Change
2008-12-08 22:15	jreymol	New Issue
2008-12-08 22:15	jreymol	Assigned To	=> rafaroda
2008-12-08 22:15	jreymol	sf_bug_id	0 => 2407583
2008-12-09 12:11	jreymol	Note Added: 0011049
2008-12-09 12:25	pheenan	Assigned To	rafaroda => pheenan
2008-12-09 12:25	pheenan	Status	new => scheduled
2008-12-09 12:25	pheenan	fix_in_branch	=> trunk
2008-12-14 20:40	jreymol	Note Added: 0011324
2009-01-09 15:28	rafaroda	Relationship added	related to 0006530
2009-01-09 15:29	rafaroda	Assigned To	pheenan => shuehner
2009-01-12 17:47	svnbot	Checkin
2009-01-12 17:47	svnbot	Note Added: 0012119
2009-01-12 17:47	svnbot	Status	scheduled => resolved
2009-01-12 17:47	svnbot	Resolution	open => fixed
2009-01-12 17:47	svnbot	svn_revision	=> 11801
2009-01-19 15:22	shuehner	Relationship added	related to 0007002
2009-04-21 12:36	psarobe	Status	resolved => closed