| 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 |
Relationships [ Relation Graph ]
[ Dependency Graph ]
Relationships 