Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013286Openbravo ERP00. Application dictionarypublic2010-05-11 10:212010-06-23 00:00
Reporternetworkb 
Assigned Toharikrishnan 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP14 
Target Version2.50MP19Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0013286: wrong length on a column of FinancialMgmtAccountingFact application dictionary table
DescriptionIn 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 ReproduceTry 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 Solution1. 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.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-05-11 10:21networkbNew Issue
2010-05-11 10:21networkbAssigned To => alostale
2010-05-13 16:29adrianromeroStatusnew => scheduled
2010-05-13 16:29adrianromerofix_in_branch => pi
2010-05-14 08:37alostaleAssigned Toalostale => adrianromero
2010-05-24 19:07networkbTarget Version2.50MP17 => 2.50MP19
2010-05-24 19:07networkbfix_in_branchpi =>
2010-06-15 09:01harikrishnanAssigned Toadrianromero => harikrishnan
2010-06-15 09:02hgbotCheckin
2010-06-15 09:02hgbotNote Added: 0028430
2010-06-15 09:02hgbotStatusscheduled => resolved
2010-06-15 09:02hgbotResolutionopen => fixed
2010-06-15 09:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3ad7992e914a73a968eaf3d6d72b8ff3d2a67c36 [^]
2010-06-15 14:30hudsonbotCheckin
2010-06-15 14:30hudsonbotNote Added: 0028447
2010-06-22 12:52arunkumarNote Added: 0028656
2010-06-22 12:52arunkumarStatusresolved => closed
2010-06-23 00:00anonymoussf_bug_id0 => 3019879

Notes
(0028430)
hgbot   
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   
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   
2010-06-22 12:52   
Tested working fine