Openbravo Issue Tracking System - Openbravo ERP | |||||||||||||||||||
| View Issue Details | |||||||||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||||||||
| 0006530 | Openbravo ERP | 01. General setup | public | 2008-12-14 20:19 | 2009-01-09 19:41 | ||||||||||||||
| Reporter | jreymol | ||||||||||||||||||
| Assigned To | shuehner | ||||||||||||||||||
| Priority | normal | Severity | major | Reproducibility | have not tried | ||||||||||||||
| Status | closed | Resolution | duplicate | ||||||||||||||||
| Platform | OS | 20 | OS Version | rPath Linux | |||||||||||||||
| Product Version | 2.50alpha-r4 | ||||||||||||||||||
| Target Version | Fixed in Version | ||||||||||||||||||
| Merge Request Status | |||||||||||||||||||
| Review Assigned To | |||||||||||||||||||
| OBNetwork customer | |||||||||||||||||||
| Web browser | |||||||||||||||||||
| Modules | Core | ||||||||||||||||||
| Support ticket | |||||||||||||||||||
| Regression level | |||||||||||||||||||
| Regression date | |||||||||||||||||||
| Regression introduced in release | |||||||||||||||||||
| Regression introduced by commit | |||||||||||||||||||
| Triggers an Emergency Pack | No | ||||||||||||||||||
| Summary | 0006530: userA cannot see General Setup - Security - User | ||||||||||||||||||
| Description | Just after creating userA as indicated in Test Case ID 992 I logged in as userA and went to General Setup - Security - User. There I saw a list of about five users and began to loosely browse them without modifying nothing. In some moment a pop up said me that something could not be saved automatically and by confirming leaving window I will lose all changes. Not having modified nothing I confirmed leaving. From then on every time I try to enter General Setup - Security - User I get an empty window with only a red message saying: Error: ERROR: more than one row returned by a subquery used as an expression and a back command button. On /var/log/tomcat/openbravo.log I see: 19:00:32 [ajp-8009-5] ERROR org.openbravo.erpWindows.User.UserData - SQL error in query: SELECT AD_User.AD_Client_ID, (CASE WHEN AD_User.AD_Client_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table1.Name), ''))),'') ) END) AS AD_Client_IDR, AD_User.AD_Org_ID, (CASE WHEN AD_User.AD_Org_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table2.Name), ''))),'') ) END) AS AD_Org_IDR, AD_User.Firstname, AD_User.Lastname, AD_User.Name, AD_User.Description, AD_User.Comments, COALESCE(AD_User.IsActive, 'N') AS IsActive, AD_User.C_BPartner_ID, (CASE WHEN AD_User.C_BPartner_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table3.Name), ''))),'') ) END) AS C_BPartner_IDR, AD_User.C_BPartner_Location_ID, (CASE WHEN AD_User.C_BPartner_Location_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table4.Name), ''))),'') ) END) AS C_BPartner_Location_IDR, AD_User.Email, AD_User.UserName, AD_User.Password, AD_User.Title, AD_User.Birthday, AD_User.Phone, AD_User.Phone2, AD_User.Fax, AD_User.EmailUser, AD_User.EmailUserPW, AD_User.Supervisor_ID, (CASE WHEN AD_User.Supervisor_ID IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table5.Name), ''))),'') ) END) AS Supervisor_IDR, AD_User.AD_OrgTrx_ID, AD_User.C_Greeting_ID, (CASE WHEN AD_User.C_Greeting_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR((CASE WHEN tableTRL6.Name IS NULL THEN TO_CHAR(table6.Name) ELSE TO_CHAR(tableTRL6.Name) END)), ''))),'') ) END) AS C_Greeting_IDR, AD_User.LastContact, AD_User.LastResult, AD_User.Default_Ad_Role_ID, (CASE WHEN AD_User.Default_Ad_Role_ID IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table7.Name), ''))),'') ) END) AS Default_Ad_Role_IDR, AD_User.Default_Ad_Language, (CASE WHEN AD_User.Default_Ad_Language IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table8.Name), ''))),'') ) END) AS Default_Ad_LanguageR, AD_User.Default_Ad_Client_ID, (CASE WHEN AD_User.Default_Ad_Client_ID IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table9.Name), ''))),'') ) END) AS Default_Ad_Client_IDR, AD_User.Default_Ad_Org_ID, (CASE WHEN AD_User.Default_Ad_Org_ID IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table10.Name), ''))),'') ) END) AS Default_Ad_Org_IDR, AD_User.Default_M_Warehouse_ID, (CASE WHEN AD_User.Default_M_Warehouse_ID IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table11.Name), ''))),'') ) END) AS Default_M_Warehouse_IDR, AD_User.Processing, AD_User.AD_User_ID, AD_User.Created, (SELECT NAME FROM AD_USER WHERE AD_USER_ID = AD_User.CreatedBy) as CreatedByR, AD_User.Updated, AD_User.UpdatedBy, (SELECT NAME FROM AD_USER WHERE AD_USER_ID = AD_User.UpdatedBy) as UpdatedByR, ? AS LANGUAGE FROM AD_User left join (select AD_Client_ID, Name from AD_Client) table1 on (AD_User.AD_Client_ID = table1.AD_Client_ID) left join (select AD_Org_ID, Name from AD_Org) table2 on (AD_User.AD_Org_ID = table2.AD_Org_ID) left join (select C_BPartner_ID, Name from C_BPartner) table3 on (AD_User.C_BPartner_ID = table3.C_BPartner_ID) left join (select C_BPartner_Location_ID, Name from C_BPartner_Location) table4 on (AD_User.C_BPartner_Location_ID = table4.C_BPartner_Location_ID) left join (select AD_User_ID, Name from AD_User) table5 on (AD_User.Supervisor_ID = table5.AD_User_ID) left join (select C_Greeting_ID, Name from C_Greeting) table6 on (AD_User.C_Greeting_ID = table6.C_Greeting_ID) left join (select C_Greeting_ID,AD_Language, Name from C_Greeting_TRL) tableTRL6 on (table6.C_Greeting_ID = tableTRL6.C_Greeting_ID and tableTRL6.AD_Language = ?) left join (select AD_Role_ID, Name from AD_Role) table7 on (AD_User.Default_Ad_Role_ID = table7.AD_Role_ID) left join (select AD_Language, Name from AD_Language) table8 on (AD_User.Default_Ad_Language = table8.AD_Language) left join (select AD_Client_ID, Name from AD_Client) table9 on (AD_User.Default_Ad_Client_ID = table9.AD_Client_ID) left join (select AD_Org_ID, Name from AD_Org) table10 on (AD_User.Default_Ad_Org_ID = table10.AD_Org_ID) left join (select M_Warehouse_ID, Name from M_Warehouse) table11 on (AD_User.Default_M_Warehouse_ID = table11.M_Warehouse_ID) WHERE 2=2 AND 1=1 AND AD_User.AD_User_ID = ? AND AD_User.AD_Client_ID IN ('0','114092746EB34838BF215D1BD8C65A1F') AND AD_User.AD_Org_ID IN ('0','6B90DD8BE75A4C679A7557CABBE37B03') Exception:org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression 19:00:32 [ajp-8009-5] ERROR org.openbravo.erpWindows.User.User - Error captured: javax.servlet.ServletException: @CODE=0@ERROR: more than one row returned by a subquery used as an expression | ||||||||||||||||||
| Steps To Reproduce | |||||||||||||||||||
| Proposed Solution | |||||||||||||||||||
| Additional Information | |||||||||||||||||||
| Tags | No tags attached. | ||||||||||||||||||
| Relationships |
| ||||||||||||||||||
| Attached Files | |||||||||||||||||||
| Issue History | |||||||||||||||||||
| Date Modified | Username | Field | Change | ||||||||||||||||
| 2008-12-14 20:19 | jreymol | New Issue | |||||||||||||||||
| 2008-12-14 20:19 | jreymol | Assigned To | => rafaroda | ||||||||||||||||
| 2008-12-14 20:19 | jreymol | sf_bug_id | 0 => 2428889 | ||||||||||||||||
| 2009-01-09 15:28 | rafaroda | Relationship added | related to 0006402 | ||||||||||||||||
| 2009-01-09 15:29 | rafaroda | Assigned To | rafaroda => shuehner | ||||||||||||||||
| 2009-01-09 19:41 | psarobe | Regression testing | => No | ||||||||||||||||
| 2009-01-09 19:41 | psarobe | Relationship added | duplicate of 0006760 | ||||||||||||||||
| 2009-01-09 19:41 | psarobe | Status | new => closed | ||||||||||||||||
| 2009-01-09 19:41 | psarobe | Duplicate ID | 0 => 6760 | ||||||||||||||||
| 2009-01-09 19:41 | psarobe | Resolution | open => duplicate | ||||||||||||||||
| There are no notes attached to this issue. |