Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007502Openbravo ERPZ. Otherspublic2009-02-11 14:332009-04-24 00:00
artem 
alostale 
highcriticalalways
closedfixed 
5
pi 
pi 
Core
No
0007502: WindowTreeData generates incorrectly
While log in Openbravo the following exception occurs:

java.lang.ArrayIndexOutOfBoundsException: 0
at org.openbravo.base.secureApp.OrgTree.<init>(OrgTree.java:37)
at org.openbravo.base.secureApp.LoginUtils.fillSessionArguments(LoginUtils.java:70)
at org.openbravo.erpCommon.ad_forms.Role.saveDefaultOptions(Role.java:152)
at org.openbravo.erpCommon.ad_forms.Role.doPost(Role.java:87)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:331)
...

This occurs because WindowTreeData generates incorrectly in part of method selectTreeID():
...
strSql = strSql +
      " SELECT NODE_ID, ID, NAME " +
      " FROM (" +
      " SELECT AD_Client_ID as Node_ID, AD_Tree_ID AS ID, NAME, 1 AS SEQNO" +
      " FROM AD_Tree " +
      " WHERE AD_Client_ID IN (";
    strSql = strSql + ((adClientId==null || adClientId.equals(""))?"":adClientId);
    strSql = strSql + ((adClientId==null || adClientId.equals(""))?"":adClientId);
    strSql = strSql +
      ") " +
...
Please apply patch.
main
has duplicate defect 0007503pi closed rafaroda ArrayIndexOutOfBoundsException on application startup. 
related to defect 0007407pi closed alostale Organization's tree works randomly 
diff WindowTree_data.diff (1,801) 2009-02-11 14:33
https://issues.openbravo.com/file_download.php?file_id=830&type=bug
Issue History
2009-02-11 14:33artemNew Issue
2009-02-11 14:33artemAssigned To => rafaroda
2009-02-11 14:33artemFile Added: WindowTree_data.diff
2009-02-11 14:33artemRegression testing => No
2009-02-11 14:48rafarodaRelationship addedrelated to 0007407
2009-02-11 15:03rafarodaStatusnew => scheduled
2009-02-11 15:03rafarodaAssigned Torafaroda => alostale
2009-02-11 15:03rafarodafix_in_branch => trunk
2009-02-11 15:09svnbotCheckin
2009-02-11 15:09svnbotNote Added: 0013346
2009-02-11 15:09svnbotStatusscheduled => resolved
2009-02-11 15:09svnbotResolutionopen => fixed
2009-02-11 15:09svnbotsvn_revision => 13052
2009-02-11 16:00rafarodaRelationship addedhas duplicate 0007503
2009-04-22 11:24psarobeTag Attached: main
2009-04-23 18:15psarobeStatusresolved => closed
2009-04-24 00:00anonymoussf_bug_id0 => 2779918

Notes
(0013346)
svnbot   
2009-02-11 15:09   
Repository: openbravo
Revision: 13052
Author: alostale
Date: 2009-02-11 15:09:26 +0100 (Wed, 11 Feb 2009)

fixed bug 0007502: WindowTreeData generates incorrectly

---
U trunk/src/org/openbravo/erpCommon/utility/WindowTree_data.xsql
---

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