Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0006211 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 00. Application dictionary | major | always | 2008-11-26 14:06 | 2008-12-11 14:55 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | pheenan | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 11010 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.35MP9 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0006211: If you fill a field with the maximum length permited and one of the character is special it fails when saving | |||||||
| Description | If you fill a field with the maximum length permitted and one of the character is special, you get the following error: ORA-12899: value too large for column "TAD_BRANCH_R23X_DEMO"."M_PRODUCT"."UPC" (actual: 31, maximum: 30) | |||||||
| Steps To Reproduce | 1-Go to the product window 2-Fill the upc field with ppppppppppppppppppppppppppppp (30 characcteres) 3-Save. 4- You get the error. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0010735) rafaroda (viewer) 2008-11-26 17:57 |
This issue has been tested both in Oracle and PostgreSQL. In PostgreSQL it was not able to reproduce when testing in branch 2.3x, branch 2.40 and trunk. In Oracle it was possible to reproduce in branch 2.3x, branch 2.40 and trunk. |
|
(0010759) pheenan (viewer) 2008-11-27 10:51 |
udpate column type. |
|
(0010997) pheenan (viewer) 2008-12-05 12:52 |
Having tested the possibility of changing the column to nvarchar this is not going to be a posible solution. The data becomes corrupted. Proposed solution is to update DBSourceManager to cast string fields. This will be tested and confirmed before continuing with the modification to DBSourceManager. |
|
(0011005) svnbot (viewer) 2008-12-05 17:19 |
Repository: openbravo Revision: 11008 Author: pheenan Date: 2008-12-05 17:19:12 +0100 (Fri, 05 Dec 2008) Fixed issue 6211. Updated columns to NVARCHAR from VARCHAR. This will enable the field to hold the maximum number of characters including special characters. --- U trunk/src-db/database/model/tables/M_PRODUCT.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=11008&sc=1 [^] |
|
(0011006) svnbot (viewer) 2008-12-05 17:20 |
Repository: openbravo Revision: 11009 Author: pheenan Date: 2008-12-05 17:20:48 +0100 (Fri, 05 Dec 2008) Fixed issue 6211. Updated columns to NVARCHAR from VARCHAR. This will enable the field to hold the maximum number of characters including special characters. --- U branches/r2.3x/database/model/tables/M_PRODUCT.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=11009&sc=1 [^] |
|
(0011007) svnbot (viewer) 2008-12-05 17:24 |
Repository: openbravo Revision: 11010 Author: pheenan Date: 2008-12-05 17:24:25 +0100 (Fri, 05 Dec 2008) Fixed issue 6211. Updated columns to NVARCHAR from VARCHAR. This will enable the field to hold the maximum number of characters including special characters. --- U branches/r2.40/src-db/database/model/tables/M_PRODUCT.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=11010&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-11-26 14:06 | networkb | New Issue | |
| 2008-11-26 14:06 | networkb | Assigned To | => rafaroda |
| 2008-11-26 14:06 | networkb | sf_bug_id | 0 => 2350781 |
| 2008-11-26 14:06 | networkb | OBNetwork customer | => Yes |
| 2008-11-26 14:06 | networkb | Regression testing | => No |
| 2008-11-26 14:42 | pjuvara | Sticky Issue | No => Yes |
| 2008-11-26 14:42 | pjuvara | Sticky Issue | Yes => No |
| 2008-11-26 17:57 | rafaroda | Note Added: 0010735 | |
| 2008-11-26 18:34 | rafaroda | Assigned To | rafaroda => pheenan |
| 2008-11-27 10:51 | pheenan | Status | new => scheduled |
| 2008-11-27 10:51 | pheenan | Note Added: 0010759 | |
| 2008-11-27 10:51 | pheenan | fix_in_branch | => trunk |
| 2008-11-27 19:19 | pnuding | Issue Monitored: pnuding | |
| 2008-12-05 12:52 | pheenan | Note Added: 0010997 | |
| 2008-12-05 17:19 | svnbot | Checkin | |
| 2008-12-05 17:19 | svnbot | Note Added: 0011005 | |
| 2008-12-05 17:19 | svnbot | Status | scheduled => resolved |
| 2008-12-05 17:19 | svnbot | Resolution | open => fixed |
| 2008-12-05 17:19 | svnbot | svn_revision | => 11008 |
| 2008-12-05 17:20 | svnbot | Checkin | |
| 2008-12-05 17:20 | svnbot | Note Added: 0011006 | |
| 2008-12-05 17:20 | svnbot | svn_revision | 11008 => 11009 |
| 2008-12-05 17:24 | svnbot | Checkin | |
| 2008-12-05 17:24 | svnbot | Note Added: 0011007 | |
| 2008-12-05 17:24 | svnbot | svn_revision | 11009 => 11010 |
| 2008-12-07 09:34 | jpabloae | Relationship added | related to 0006390 |
| 2008-12-11 14:55 | krishna | Status | resolved => closed |
| 2008-12-12 11:22 | pheenan | Relationship added | related to 0006505 |
| 2008-12-12 11:25 | pheenan | Relationship added | related to 0006507 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |