Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0002057
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] C. Securityminoralways2007-10-08 19:272008-06-12 09:43
Reporteruser71View Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionout of dateFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0002057: Error Role Org. Access

DescriptionMy 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


TagsNo 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 [^]

- Issue History
Date Modified Username Field Change

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker