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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0020342
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionaryminoralways2012-04-24 20:082012-05-25 12:12
ReportermiruritaView Statuspublic 
Assigned ToSandrahuguet 
PrioritynormalResolutionfixedFixed in Version3.0MP12
StatusclosedFix in branchpiFixed in SCM revision8345a6b7c759
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0020342: Error when creating an user (in oracle) with username of 60 character long (containing special characters as @, _, ...)

DescriptionIt only fails in Oracle.

Username column is defined as VARCHAR(60)

You cannot enter a 60 character long username in oracle containing special characters as @, _, ñ, ...
Steps To Reproduce[in oracle]
1) Go to User window
2) Enter a 60 character long username containing at least one special character
@bcdefghijklmñopqrstuvwzyz_abcdefghijklmnopqrstuvwzyz2345679
3) Try to save the record

Error
Saving failed. ORA-12899: value too large for column "INT_FULL_ORACLE"."AD_USER"."USERNAME" (actual: 61, maximum: 60)

1) Login as System Administrator
2) Go to Initial Client Setup window
3) Enter a 60 character long Client Username containing at least one special character
@bcdefghijklmñopqrstuvwzyz_abcdefghijklmnopqrstuvwzyz2345679
4) Fill other mandatory fields
5) Click on OK button

Error
Saving failed. ORA-12899: value too large for column "INT_FULL_ORACLE"."AD_USER"."USERNAME" (actual: 61, maximum: 60)
Proposed SolutionChange column definition to NVARCHAR

It is an API change because

before this scenario worked
select COALESCE(TO_CHAR(name), username) from ad_user

if you change to nvarchar it fails
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0020470 closedSandrahuguet API Change: Change username column to NVARCHAR type in ad_user table 

-  Notes
(0048745)
hgbot (developer)
2012-05-17 18:14

 Repository: erp/devel/pi
Changeset: 8345a6b7c7595e0593b7ef87b608c39f0c8044b0
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed May 09 16:32:42 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8345a6b7c7595e0593b7ef87b608c39f0c8044b0 [^]

Fixed bug 20342 Change username column to NVARCHAR type in ad_user

---
M src-db/database/model/tables/AD_USER.xml
---
(0048748)
mirurita (viewer)
2012-05-17 18:37

 code review + testing OK
(0049159)
hudsonbot (viewer)
2012-05-25 12:12

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5401e185a8b0 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2012-04-24 20:08 mirurita New Issue
2012-04-24 20:08 mirurita Assigned To => vmromanos
2012-04-24 20:08 mirurita Modules => Core
2012-04-24 20:08 mirurita OBNetwork customer => No
2012-05-09 15:10 Sandrahuguet Assigned To vmromanos => Sandrahuguet
2012-05-09 16:28 Sandrahuguet Status new => scheduled
2012-05-09 16:28 Sandrahuguet fix_in_branch => pi
2012-05-11 09:05 Sandrahuguet Relationship added related to 0020470
2012-05-17 18:14 hgbot Checkin
2012-05-17 18:14 hgbot Note Added: 0048745
2012-05-17 18:14 hgbot Status scheduled => resolved
2012-05-17 18:14 hgbot Resolution open => fixed
2012-05-17 18:14 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8345a6b7c7595e0593b7ef87b608c39f0c8044b0 [^]
2012-05-17 18:37 mirurita Note Added: 0048748
2012-05-17 18:37 mirurita Status resolved => closed
2012-05-17 18:37 mirurita Fixed in Version => 3.0MP12
2012-05-25 12:12 hudsonbot Checkin
2012-05-25 12:12 hudsonbot Note Added: 0049159

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker