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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005125
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupminoralways2008-09-19 18:262008-12-16 12:37
ReporteriperdomoView Statuspublic 
Assigned Tocromero 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision7635
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.5.0_15
OS Version2.6.23-gentoo-r9Database versionXE - 10.2.0.1.0Ant version1.7.0
Product VersionpiSCM revision7528 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005125: *invalid number* error message when accessing Session Variables window

DescriptionIf you want to use the Session Info window you get an error: 'invalid number'

Below you'll find the error message logged

17:47:09 [ajp-8009-2] ERROR org.openbravo.erpCommon.ad_forms.ShowSessionVariablesData - SQL error in query: SELECT AD_WINDOW_ID AS ID, NAME FROM AD_WINDOW WHERE ISACTIVE='Y' AND AD_WINDOW.AD_WINDOW_ID IN (109, 1002100000, 201, 153, 160, 105, 142, 131, 800084, 102, 800029, 800080, 800018, 800025, 800007, 800014, 800003, 181, 276, 258, 265, 272, 247, 254, 158, 250, 147, 232, 184, 191, 129, 118, 125, 210, 107, 114, 800067, 103, 800052, 800027, 800023, 800030, 800012, 800001, 189, 281, 178, 270, 167, 252, 204, 149, 138, 800098, 127, 134, 141, 800094, 116, 123, 800069, 130, 800076, 800083, 112, 800072, 101, 800032, 800021, 257, 246, 800010, 198, 283, 228, 235, 187, 194, 169, 176, 183, 165, 172, 161, 143, 150, 800096, 132, 800085, 800092, 121, 800074, 800081, 800019, 800026, 110, 800063, 800070, 800008, 800015, 800100, 800004, 277, 259, 248, 1005400002, 237, 244, 233, 192, 137, 174, 1002100003, 800079, 163, 170, 108, 115, 200, 800068, 152, 104, 800090, 800028, 800035, 800017, 800024, 800006, 800013, 800020, 279, 286, 800002, 268, 275, 282, 264, 168, 260, 242, 139, 146, 800099, 128, 135, 220, 800088, 117, 800077, 1004400000, 106, 113, 120, 800066, 800048, 800051, 800022, 291, 800000, 236, 262, 207, 251, 203, 162, 144, 151, 800097, 140, 800086, 122, 800075, 800082, 111, 800064, 800071, 800016, 100, 800053, 800060, 800005, 278, 800031, 267, 256, 1005400003, 245, 197, 227, 234, 193, 223, 175, 1002100004) ORDER BY NAMEException:java.sql.SQLException: ORA-01722: invalid number

17:47:09 [ajp-8009-2] ERROR org.openbravo.erpCommon.ad_forms.ShowSessionVariables - Error captured: javax.servlet.ServletException: @CODE=1722@ORA-01722: invalid number
Steps To Reproduce1. Login in the application
2. Go to: General Setup > Application > Session Variables
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0009115)
svnbot (reporter)
2008-09-22 13:20

 Repository: openbravo
Revision: 7634
Author: cromeroherrero
Date: 2008-09-22 13:20:08 +0200 (Mon, 22 Sep 2008)

Fixed bug 5125: *invalid number* error message when accessing Session Variables window. Now with UUID identifiers are not more numeric, so we have to change the creation to concatenate strings and not numbers

---
U trunk/src/org/openbravo/erpCommon/ad_forms/ShowSessionVariables.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=7634&sc=1 [^]
(0009116)
svnbot (reporter)
2008-09-22 13:27

 Repository: openbravo
Revision: 7635
Author: cromeroherrero
Date: 2008-09-22 13:27:34 +0200 (Mon, 22 Sep 2008)

Fixed bug 5125: *invalid number* error message when accessing Session Variables window. Now with UUID identifiers are not more numeric, so we have also removed unneeded Integer validation

---
U trunk/src/org/openbravo/erpCommon/ad_forms/ShowSessionVariables.java
---

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

- Issue History
Date Modified Username Field Change
2008-09-19 18:26 iperdomo New Issue
2008-09-19 18:26 iperdomo Assigned To => cromero
2008-09-19 18:26 iperdomo sf_bug_id 0 => 2119562
2008-09-19 18:26 iperdomo Regression testing => No
2008-09-22 13:20 svnbot Checkin
2008-09-22 13:20 svnbot Note Added: 0009115
2008-09-22 13:20 svnbot Status new => resolved
2008-09-22 13:20 svnbot Resolution open => fixed
2008-09-22 13:20 svnbot svn_revision => 7634
2008-09-22 13:27 svnbot Checkin
2008-09-22 13:27 svnbot Note Added: 0009116
2008-09-22 13:27 svnbot svn_revision 7634 => 7635
2008-12-16 12:37 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker