Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0013286 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 00. Application dictionary | minor | always | 2010-05-11 10:21 | 2010-06-23 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | harikrishnan | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 3ad7992e914a | ||||
| Projection | none | ETA | none | Target Version | 2.50MP19 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP14 | 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 | 0013286: wrong length on a column of FinancialMgmtAccountingFact application dictionary table | |||||||
| Description | In AD table "FinancialMgmtAccountingFact" there is a column called "DocBaseType", which length is defined as 3 characters. But in physical DB table "fact_acct", it is defined as nvarchar2(40) characters. Due to that difference, some processes (as for example, import client process) that use DAL take that length of this column is 3, so they throw an error. | |||||||
| Steps To Reproduce | Try to export and import a client using "Accruals and Deferrals" module (which has docbasetype=ACCDEF_AD, which is 9 length). Fact_acct entry that has docbasetype=ACCDEF_AD will fail. | |||||||
| Proposed Solution | 1. Modify length of column "DocBaseType" of Application Dictionary table "FinancialMgmtAccountingFact" to 40. 2. Add a validation to check that Application dictionary columns have same length as DB columns. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0028430) hgbot (developer) 2010-06-15 09:02 |
Repository: erp/devel/pi Changeset: 3ad7992e914a73a968eaf3d6d72b8ff3d2a67c36 Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com> Date: Tue Jun 15 12:30:22 2010 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/3ad7992e914a73a968eaf3d6d72b8ff3d2a67c36 [^] Fixes Issue 13286: wrong length on a column of FinancialMgmtAccountingFact application dictionary table. --- M src-db/database/sourcedata/AD_COLUMN.xml --- |
|
(0028447) hudsonbot (viewer) 2010-06-15 14:30 |
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/3ad7992e914a [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/4f4fb246ce7d [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17607.obx [^] |
|
(0028656) arunkumar (viewer) 2010-06-22 12:52 |
Tested working fine |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-05-11 10:21 | networkb | New Issue | |
| 2010-05-11 10:21 | networkb | Assigned To | => alostale |
| 2010-05-11 10:21 | networkb | OBNetwork customer | => Yes |
| 2010-05-13 16:29 | adrianromero | Status | new => scheduled |
| 2010-05-13 16:29 | adrianromero | fix_in_branch | => pi |
| 2010-05-14 08:37 | alostale | Assigned To | alostale => adrianromero |
| 2010-05-24 19:07 | networkb | Target Version | 2.50MP17 => 2.50MP19 |
| 2010-05-24 19:07 | networkb | fix_in_branch | pi => |
| 2010-06-15 09:01 | harikrishnan | Assigned To | adrianromero => harikrishnan |
| 2010-06-15 09:02 | hgbot | Checkin | |
| 2010-06-15 09:02 | hgbot | Note Added: 0028430 | |
| 2010-06-15 09:02 | hgbot | Status | scheduled => resolved |
| 2010-06-15 09:02 | hgbot | Resolution | open => fixed |
| 2010-06-15 09:02 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/3ad7992e914a73a968eaf3d6d72b8ff3d2a67c36 [^] |
| 2010-06-15 14:30 | hudsonbot | Checkin | |
| 2010-06-15 14:30 | hudsonbot | Note Added: 0028447 | |
| 2010-06-22 12:52 | arunkumar | Note Added: 0028656 | |
| 2010-06-22 12:52 | arunkumar | Status | resolved => closed |
| 2010-06-23 00:00 | anonymous | sf_bug_id | 0 => 3019879 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |