Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0002057 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] C. Security | minor | always | 2007-10-08 19:27 | 2008-06-12 09:43 | |||
Reporter | user71 | View Status | public | |||||
Assigned To | alostale | |||||||
Priority | normal | Resolution | out of date | Fixed in Version | pi | |||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0002057: Error Role Org. Access | |||||||
Description | My instalation: Openbravo 2.34 DDBB Oracle 10g Express Edition Windows Vista Apache Ant version 1.6.5 Apache Tomcat 5.5 Java version 1.6.0_01 Steps: 1.-Go to General Setup >> Role 2.-Choose any Role existing 3.-Go to Tab Org Access in relational mode 4.-Double Click in grid at any Org Access existing 5.-Show the next error: Error: The number is not correct.You may check the data And in log the next error appears: 19:25:53 [http-8888-Processor23] ERROR org.openbravo.erpWindows.Role.OrgAccessData - SQL error in query: SELECT AD_Role_OrgAccess.AD_Client_ID, (CASE WHEN AD_Role_OrgAccess.AD_Client_ID IS NULL THEN '' ELSE (TO_CHAR(table1.Name) ) END) AS AD_Client_IDR, AD_Role_OrgAccess.AD_Org_ID, (CASE WHEN AD_Role_OrgAccess.AD_Org_ID IS NULL THEN '' ELSE (TO_CHAR(table2.Name) ) END) AS AD_Org_IDR, AD_Role_OrgAccess.AD_Role_ID, (CASE WHEN AD_Role_OrgAccess.AD_Role_ID IS NULL THEN '' ELSE (TO_CHAR(table3.Name) ) END) AS AD_Role_IDR, COALESCE(AD_Role_OrgAccess.IsActive, 'N') AS IsActive, AD_Role_OrgAccess.Created, AD_Role_OrgAccess.CreatedBy, AD_Role_OrgAccess.Updated, AD_Role_OrgAccess.UpdatedBy, ? AS LANGUAGE FROM AD_Role_OrgAccess left join (select AD_Client_ID, Name from AD_Client) table1 on (AD_Role_OrgAccess.AD_Client_ID = table1.AD_Client_ID) left join (select AD_Org_ID, Name from AD_Org) table2 on (AD_Role_OrgAccess.AD_Org_ID = table2.AD_Org_ID) left join (select AD_Role_ID, Name from AD_Role) table3 on (AD_Role_OrgAccess.AD_Role_ID = table3.AD_Role_ID) WHERE 2=2 AND 1=1 AND AD_Role_OrgAccess.AD_Role_ID = ? AND AD_Role_OrgAccess.AD_Org_ID = ? Exception:java.sql.SQLException: ORA-01722: número no válido 19:25:53 [http-8888-Processor23] ERROR org.openbravo.erpWindows.Role.OrgAccess - Error captured: javax.servlet.ServletException: @CODE=1722@ORA-01722: número no válido | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0002315) user71 2007-10-15 18:04 edited on: 2008-06-12 09:22 |
Logged In: YES user_id=1790723 Originator: YES The same error appears in window "Warehouse and Storage Bins", tab "Accounting": 17:59:10 [http-8888-Processor24] ERROR org.openbravo.erpWindows.WarehouseandStorageBins.AccountingData - SQL error in query: SELECT M_Warehouse_Acct.AD_Client_ID, (CASE WHEN M_Warehouse_Acct.AD_Client_ID IS NULL THEN '' ELSE (TO_CHAR(table1.Name) ) END) AS AD_Client_IDR, M_Warehouse_Acct.AD_Org_ID, (CASE WHEN M_Warehouse_Acct.AD_Org_ID IS NULL THEN '' ELSE (TO_CHAR(table2.Name) ) END) AS AD_Org_IDR, M_Warehouse_Acct.M_Warehouse_ID, (CASE WHEN M_Warehouse_Acct.M_Warehouse_ID IS NULL THEN '' ELSE (TO_CHAR(table3.Name) ) END) AS M_Warehouse_IDR, M_Warehouse_Acct.C_AcctSchema_ID, (CASE WHEN M_Warehouse_Acct.C_AcctSchema_ID IS NULL THEN '' ELSE (TO_CHAR(table4.Name) ) END) AS C_AcctSchema_IDR, COALESCE(M_Warehouse_Acct.IsActive, 'N') AS IsActive, M_Warehouse_Acct.W_Inventory_Acct, M_Warehouse_Acct.W_InvActualAdjust_Acct, M_Warehouse_Acct.W_Differences_Acct, (CASE WHEN M_Warehouse_Acct.W_Differences_Acct IS NULL THEN '' ELSE (TO_CHAR(table5.Combination) ) END) AS W_Differences_AcctR, M_Warehouse_Acct.W_Revaluation_Acct, M_Warehouse_Acct.Created, M_Warehouse_Acct.CreatedBy, M_Warehouse_Acct.Updated, M_Warehouse_Acct.UpdatedBy, ? AS LANGUAGE FROM M_Warehouse_Acct left join (select AD_Client_ID, Name from AD_Client) table1 on (M_Warehouse_Acct.AD_Client_ID = table1.AD_Client_ID) left join (select AD_Org_ID, Name from AD_Org) table2 on (M_Warehouse_Acct.AD_Org_ID = table2.AD_Org_ID) left join (select M_Warehouse_ID, Name from M_Warehouse) table3 on (M_Warehouse_Acct.M_Warehouse_ID = table3.M_Warehouse_ID) left join (select C_AcctSchema_ID, Name from C_AcctSchema) table4 on (M_Warehouse_Acct.C_AcctSchema_ID = table4.C_AcctSchema_ID) left join (select C_ValidCombination_ID, Combination from C_ValidCombination) table5 on (M_Warehouse_Acct.W_Differences_Acct = table5.C_ValidCombination_ID) WHERE 2=2 AND 1=1 AND M_Warehouse_Acct.M_Warehouse_ID = ? AND M_Warehouse_Acct.C_AcctSchema_ID = ? Exception:java.sql.SQLException: ORA-01722: número no válido 17:59:10 [http-8888-Processor24] ERROR org.openbravo.erpWindows.WarehouseandStorageBins.Accounting - Error captured: javax.servlet.ServletException: @CODE=1722@ORA-01722: número no válido |
(0002316) alostale (manager) 2007-12-14 11:13 edited on: 2008-06-12 09:22 |
Logged In: YES user_id=1500722 Originator: NO Already fixed bug |
(0005646) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43 |
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1809631 [^] |
Copyright © 2000 - 2009 MantisBT Group |