Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0005125Openbravo ERP01. General setuppublic2008-09-19 18:262008-12-16 12:37
iperdomo 
cromero 
normalminoralways
closedfixed 
202.6.23-gentoo-r9
pi 
 
Core
No
0005125: *invalid number* error message when accessing Session Variables window
If 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
1. Login in the application
2. Go to: General Setup > Application > Session Variables
No tags attached.
Issue History
2008-09-19 18:26iperdomoNew Issue
2008-09-19 18:26iperdomoAssigned To => cromero
2008-09-19 18:26iperdomosf_bug_id0 => 2119562
2008-09-19 18:26iperdomoRegression testing => No
2008-09-22 13:20svnbotCheckin
2008-09-22 13:20svnbotNote Added: 0009115
2008-09-22 13:20svnbotStatusnew => resolved
2008-09-22 13:20svnbotResolutionopen => fixed
2008-09-22 13:20svnbotsvn_revision => 7634
2008-09-22 13:27svnbotCheckin
2008-09-22 13:27svnbotNote Added: 0009116
2008-09-22 13:27svnbotsvn_revision7634 => 7635
2008-12-16 12:37psarobeStatusresolved => closed

Notes
(0009115)
svnbot   
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   
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 [^]