Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010707
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-09-23 10:042009-10-16 00:00
Reportereduardo_ArgalView Statuspublic 
Assigned Toeduardo_Argal 
PriorityhighResolutionfixedFixed in Version2.50MP7
StatusclosedFix in branchpiFixed in SCM revision9434157dc8fb
ProjectionnoneETAnoneTarget Version2.50MP7
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010707: Wrong column data type definition in Fact_Acct: DocBaseType

DescriptionWrong column data type definition in Fact_Acct: DocBaseType

Now a days it is char(3), and this prevents modularity to create new docbasetypes as the DB Prefix has to be included
Steps To ReproduceGo to database and mind the datatype for DocBaseType column Char(3)
Proposed SolutionGo to database and modify the datatype for DocBaseType column from Char(3) to NVARCHAR (40)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0010939 closeddalsasua API check build 171 fails - part1 

-  Notes
(0020307)
hgbot (developer)
2009-09-23 11:59

Repository: erp/devel/pi
Changeset: 9434157dc8fb81424824c0980d75dc58fbc9a9c5
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Sep 23 10:06:09 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9434157dc8fb81424824c0980d75dc58fbc9a9c5 [^]

Fixes issue 0010707: Wrong column data type definition in Fact_Acct: DocBaseType

---
M src-db/database/model/tables/FACT_ACCT.xml
---
(0020503)
hgbot (developer)
2009-09-29 14:17

Repository: erp/devel/pi-pageddatagrid
Changeset: 9434157dc8fb81424824c0980d75dc58fbc9a9c5
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Sep 23 10:06:09 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/9434157dc8fb81424824c0980d75dc58fbc9a9c5 [^]

Fixes issue 0010707: Wrong column data type definition in Fact_Acct: DocBaseType

---
M src-db/database/model/tables/FACT_ACCT.xml
---
(0020844)
sureshbabu (reporter)
2009-10-07 13:40

change is reflecting only in Orcale database not in Postgres.
(0021025)
dalsasua (reporter)
2009-10-15 09:30

It's working fine, for me, in Postgresql as well.
(0021026)
sureshbabu (reporter)
2009-10-15 09:45

Retested, working fine in both the context.

- Issue History
Date Modified Username Field Change
2009-09-23 10:04 eduardo_Argal New Issue
2009-09-23 10:04 eduardo_Argal Assigned To => eduardo_Argal
2009-09-23 10:06 eduardo_Argal Status new => scheduled
2009-09-23 10:06 eduardo_Argal fix_in_branch => pi
2009-09-23 11:59 hgbot Checkin
2009-09-23 11:59 hgbot Note Added: 0020307
2009-09-23 11:59 hgbot Status scheduled => resolved
2009-09-23 11:59 hgbot Resolution open => fixed
2009-09-23 11:59 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9434157dc8fb81424824c0980d75dc58fbc9a9c5 [^]
2009-09-23 16:11 psarobe Target Version pi => 2.50MP6
2009-09-23 16:12 psarobe Tag Attached: 250mp6
2009-09-25 10:52 psarobe Tag Detached: 250mp6
2009-09-25 10:53 psarobe Target Version 2.50MP6 => 2.50MP7
2009-09-25 10:53 psarobe fix_in_branch pi =>
2009-09-29 14:17 hgbot Checkin
2009-09-29 14:17 hgbot Note Added: 0020503
2009-09-29 14:17 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/9434157dc8fb81424824c0980d75dc58fbc9a9c5 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/9434157dc8fb81424824c0980d75dc58fbc9a9c5 [^]
2009-10-07 13:40 sureshbabu Status resolved => new
2009-10-07 13:40 sureshbabu Resolution fixed => open
2009-10-07 13:40 sureshbabu Note Added: 0020844
2009-10-09 13:46 psarobe Status new => scheduled
2009-10-09 13:46 psarobe fix_in_branch => pi
2009-10-13 10:39 shuehner Relationship added related to 0010939
2009-10-15 09:30 dalsasua Status scheduled => resolved
2009-10-15 09:30 dalsasua Fixed in Version => pi
2009-10-15 09:30 dalsasua Resolution open => fixed
2009-10-15 09:30 dalsasua Note Added: 0021025
2009-10-15 09:45 sureshbabu Status resolved => closed
2009-10-15 09:45 sureshbabu Note Added: 0021026
2009-10-15 09:45 sureshbabu Fixed in Version pi => 2.50MP7
2009-10-16 00:00 anonymous sf_bug_id 0 => 2880176


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker