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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008899
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionaryminoralways2009-05-05 11:122009-06-18 00:00
ReporterAinhoaPagolaView Statuspublic 
Assigned Tomtaal 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision10bc8ceffb9a
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseAnyJava version1.5
OS VersionUbuntu 8.4Database versionAnt version1.7
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008899: Column type in Application dictionary different to Database column type - UUID

DescriptionIn bug 0008897 a concrete error was solved: the column named Record_ID in AD_Pinstance table, is defined as an integer in the application dictionary but it is referencing an UUID.

A check should be done all over the application dictionary to check that every table is properly defined.

I would also like to notice that there is some lack of consistency in the default values. There are some columns that take default values at database level, but have no default value set at AP level. This makes causes some trouble when working with DAL, as some parameters need to be defined although it should be possible to leave them blank as they have a default value at database level. Example: qtyreserved in c_orderline. Database level: default=0. AP no default set.
Tags250mp2
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0008897 closedAinhoaPagola Column type in Application dictionary different to Database column type - AD_Pinstance - UUID 
related to defect 0008900pi closedmtaal Inconsistencies between database default values and application dictionary default values 

-  Notes
(0016038)
mtaal (manager)
2009-05-05 11:19

Assigning this issue to myself as I wrote the validation code.

In addition I have entered a new issue related to database and AD inconsistency of default values:
https://issues.openbravo.com/view.php?id=8900 [^]
(0016079)
hgbot (developer)
2009-05-06 09:13

Repository: erp/devel/pi
Changeset: 10bc8ceffb9a01a129bd9959059412b5ee513846
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed May 06 09:13:22 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/10bc8ceffb9a01a129bd9959059412b5ee513846 [^]

Fixes issue 8859: C_TEMP_SELECTION and C_TEMP_SELECTION2 present in the database ant not in the AD
Fixes issue 8899: Column type in Application dictionary different to Database column type - UUID

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src/org/openbravo/service/system/DatabaseValidator.java
---

- Issue History
Date Modified Username Field Change
2009-05-05 11:12 AinhoaPagola New Issue
2009-05-05 11:12 AinhoaPagola Assigned To => rafaroda
2009-05-05 11:12 AinhoaPagola Regression testing => No
2009-05-05 11:12 AinhoaPagola Issue generated from 0008897
2009-05-05 11:12 AinhoaPagola Relationship added related to 0008897
2009-05-05 11:19 mtaal Note Added: 0016038
2009-05-05 11:20 mtaal Relationship added related to 0008900
2009-05-05 11:20 mtaal Assigned To rafaroda => mtaal
2009-05-05 12:02 psarobe Priority normal => urgent
2009-05-05 12:02 psarobe Status new => scheduled
2009-05-05 12:02 psarobe Tag Attached: 250mp2
2009-05-06 09:13 hgbot Checkin
2009-05-06 09:13 hgbot Note Added: 0016079
2009-05-06 09:13 hgbot Status scheduled => resolved
2009-05-06 09:13 hgbot Resolution open => fixed
2009-05-06 09:13 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/10bc8ceffb9a01a129bd9959059412b5ee513846 [^]
2009-06-17 09:57 plujan Status resolved => closed
2009-06-18 00:00 anonymous sf_bug_id 0 => 2807991


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker