Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020342Openbravo ERP00. Application dictionarypublic2012-04-24 20:082012-05-25 12:12
Reportermirurita 
Assigned ToSandrahuguet 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version3.0MP12 
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
Summary0020342: 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
Additional Information
TagsNo tags attached.
Relationships
related to defect 0020470 closed Sandrahuguet API Change: Change username column to NVARCHAR type in ad_user table 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-04-24 20:08miruritaNew Issue
2012-04-24 20:08miruritaAssigned To => vmromanos
2012-04-24 20:08miruritaModules => Core
2012-04-24 20:08miruritaOBNetwork customer => No
2012-05-09 15:10SandrahuguetAssigned Tovmromanos => Sandrahuguet
2012-05-09 16:28SandrahuguetStatusnew => scheduled
2012-05-09 16:28Sandrahuguetfix_in_branch => pi
2012-05-11 09:05SandrahuguetRelationship addedrelated to 0020470
2012-05-17 18:14hgbotCheckin
2012-05-17 18:14hgbotNote Added: 0048745
2012-05-17 18:14hgbotStatusscheduled => resolved
2012-05-17 18:14hgbotResolutionopen => fixed
2012-05-17 18:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8345a6b7c7595e0593b7ef87b608c39f0c8044b0 [^]
2012-05-17 18:37miruritaNote Added: 0048748
2012-05-17 18:37miruritaStatusresolved => closed
2012-05-17 18:37miruritaFixed in Version => 3.0MP12
2012-05-25 12:12hudsonbotCheckin
2012-05-25 12:12hudsonbotNote Added: 0049159

Notes
(0048745)
hgbot   
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   
2012-05-17 18:37   
code review + testing OK
(0049159)
hudsonbot   
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