Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0012212 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | always | 2010-02-10 16:54 | 2010-03-12 22:41 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.50MP14 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 33950fa7447d | |||
| Projection | none | ETA | none | Target Version | 2.50MP14 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP11 | 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 | 0012212: update database fails when object name is longer than 30 characters | |||||||
| Description | When the name of your object is longer than 30 characters, export.database works fine but update.database fails. | |||||||
| Steps To Reproduce | I attach a module defined as: * dependent of core * DB prefix of 4 characters length (MDRTG) which adds column "Potentiallifetimevalue" (located in table c_bpartner) to table ad_alert. As DBColumnName should be "EM_Mdrtg_Potentiallifetimevalue" (31 characters long), if you try to install the module you will get the error. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  org.openbravo.retegi-1.0.0.obx [^] (5,182 bytes) 2010-02-10 16:54 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0024823) marvintm (viewer) 2010-02-25 17:07 |
The real issue is not that update.database didn't work with an object which is more than 30 characters. Openbravo doesn't support more than 30 characters for a database object, because the Oracle database doesn't allow it. The issue is that export.database didn't complain when the object was exported in the first place. The validation in export.database is going to be changed to detect this problem. |
|
(0024825) hgbot (developer) 2010-02-25 17:40 |
Repository: erp/devel/pi Changeset: 33950fa7447d42ab0d953c9d83cee18893c684e2 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Thu Feb 25 17:10:53 2010 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/33950fa7447d42ab0d953c9d83cee18893c684e2 [^] Fixed issue 12212. Validation was changed so that if somebody tries to export a database object which is more than 30 characters long, an error will be raised. --- M src/org/openbravo/service/system/DatabaseValidator.java M src/org/openbravo/service/system/SystemValidationResult.java --- |
|
(0025184) hgbot (developer) 2010-03-09 17:36 |
Repository: erp/devel/pi Changeset: 2b0ab921b30adb4fdfb802d18408848fe227c4dd Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Tue Mar 09 17:41:29 2010 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/2b0ab921b30adb4fdfb802d18408848fe227c4dd [^] Related to issue 12212. Fixed corner case (column belonging to one module added to a table which belongs to a different module). The messages will also show the table name when relevant. --- M src/org/openbravo/service/system/DatabaseValidator.java --- |
|
(0025185) shuehner (administrator) 2010-03-09 17:59 |
oracle won't allow db-objects with name >30chars, but now the export.database validates this length constraint and stops with an error, so case won't happen for new developments/modules. |
|
(0025324) hudsonbot (viewer) 2010-03-12 22:39 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/33950fa7447d [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^] Tests: http://builds.openbravo.com/view/devel-int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^] |
|
(0025411) hudsonbot (viewer) 2010-03-12 22:41 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/2b0ab921b30a [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^] Tests: http://builds.openbravo.com/view/devel-int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-02-10 16:54 | networkb | New Issue | |
| 2010-02-10 16:54 | networkb | Assigned To | => alostale |
| 2010-02-10 16:54 | networkb | File Added: org.openbravo.retegi-1.0.0.obx | |
| 2010-02-10 16:54 | networkb | OBNetwork customer | => Yes |
| 2010-02-11 11:20 | alostale | Status | new => scheduled |
| 2010-02-11 11:20 | alostale | Assigned To | alostale => marvintm |
| 2010-02-11 11:20 | alostale | fix_in_branch | => pi |
| 2010-02-25 17:07 | marvintm | Note Added: 0024823 | |
| 2010-02-25 17:40 | hgbot | Checkin | |
| 2010-02-25 17:40 | hgbot | Note Added: 0024825 | |
| 2010-02-25 17:40 | hgbot | Status | scheduled => resolved |
| 2010-02-25 17:40 | hgbot | Resolution | open => fixed |
| 2010-02-25 17:40 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/33950fa7447d42ab0d953c9d83cee18893c684e2 [^] |
| 2010-03-08 16:06 | jpabloae | Target Version | 2.50MP13 => 2.50MP14 |
| 2010-03-09 17:36 | hgbot | Checkin | |
| 2010-03-09 17:36 | hgbot | Note Added: 0025184 | |
| 2010-03-09 17:59 | shuehner | Note Added: 0025185 | |
| 2010-03-09 17:59 | shuehner | Status | resolved => closed |
| 2010-03-09 17:59 | shuehner | Fixed in Version | => 2.50MP14 |
| 2010-03-10 17:23 | anonymous | sf_bug_id | 0 => |
| 2010-03-10 18:29 | anonymous | sf_bug_id | => 2968045 |
| 2010-03-12 22:39 | hudsonbot | Checkin | |
| 2010-03-12 22:39 | hudsonbot | Note Added: 0025324 | |
| 2010-03-12 22:41 | hudsonbot | Checkin | |
| 2010-03-12 22:41 | hudsonbot | Note Added: 0025411 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |