Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008899Openbravo ERP00. Application dictionarypublic2009-05-05 11:122009-06-18 00:00
ReporterAinhoaPagola 
Assigned Tomtaal 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.4
Product Version 
Target VersionFixed 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
Summary0008899: 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.
Steps To Reproduce
Proposed Solution
Additional Information
Tags250mp2
Relationships
related to defect 0008897 closed AinhoaPagola Column type in Application dictionary different to Database column type - AD_Pinstance - UUID 
related to defect 0008900pi closed mtaal Inconsistencies between database default values and application dictionary default values 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-05-05 11:12AinhoaPagolaNew Issue
2009-05-05 11:12AinhoaPagolaAssigned To => rafaroda
2009-05-05 11:12AinhoaPagolaRegression testing => No
2009-05-05 11:12AinhoaPagolaIssue generated from0008897
2009-05-05 11:12AinhoaPagolaRelationship addedrelated to 0008897
2009-05-05 11:19mtaalNote Added: 0016038
2009-05-05 11:20mtaalRelationship addedrelated to 0008900
2009-05-05 11:20mtaalAssigned Torafaroda => mtaal
2009-05-05 12:02psarobePrioritynormal => urgent
2009-05-05 12:02psarobeStatusnew => scheduled
2009-05-05 12:02psarobeTag Attached: 250mp2
2009-05-06 09:13hgbotCheckin
2009-05-06 09:13hgbotNote Added: 0016079
2009-05-06 09:13hgbotStatusscheduled => resolved
2009-05-06 09:13hgbotResolutionopen => fixed
2009-05-06 09:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/10bc8ceffb9a01a129bd9959059412b5ee513846 [^]
2009-06-17 09:57plujanStatusresolved => closed
2009-06-18 00:00anonymoussf_bug_id0 => 2807991

Notes
(0016038)
mtaal   
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   
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
---