Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008897Openbravo ERP00. Application dictionarypublic2009-05-05 10:102009-07-26 22:11
AinhoaPagola 
AinhoaPagola 
urgentmajoralways
closedfixed 
20Ubuntu 8.4
 
2.50MP3 
Core
No
0008897: Column type in Application dictionary different to Database column type - AD_Pinstance - UUID
The column named Record_ID in AD_Pinstance table, is defined as an integer in the application dictionary but it is referencing an UUID.

This creates a lot of trouble because DAL created the objects based in their description in the Application Dictionary. Being this table so important, this bugs makes impossible to call stored procedures which requires this column.

This concrete mistake should be fixed asap, but moreover, a check should be done all over the application dictionary to check that every table is properly defined.

Another bug has been inserted for the general case.
250MP1, 250MP3releasecandidate
related to defect 0008900pi closed mtaal Inconsistencies between database default values and application dictionary default values 
related to defect 0008899 closed mtaal Column type in Application dictionary different to Database column type - UUID 
Issue History
2009-05-05 10:10AinhoaPagolaNew Issue
2009-05-05 10:10AinhoaPagolaAssigned To => rafaroda
2009-05-05 10:10AinhoaPagolaRegression testing => No
2009-05-05 10:38plujanStatusnew => scheduled
2009-05-05 10:38plujanAssigned Torafaroda => AinhoaPagola
2009-05-05 10:38plujanfix_in_branch => pi
2009-05-05 10:38plujanTag Attached: 250MP1
2009-05-05 10:39plujanPrioritynormal => urgent
2009-05-05 10:39plujanfix_in_branchpi =>
2009-05-05 11:12AinhoaPagolaIssue cloned0008899
2009-05-05 11:12AinhoaPagolaRelationship addedrelated to 0008899
2009-05-05 11:13AinhoaPagolaSteps to Reproduce Updated
2009-05-05 11:20mtaalRelationship addedrelated to 0008900
2009-05-05 12:01hgbotCheckin
2009-05-05 12:01hgbotNote Added: 0016042
2009-05-05 12:01hgbotStatusscheduled => resolved
2009-05-05 12:01hgbotResolutionopen => fixed
2009-05-05 12:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ce3c0e6ad8603eb0ebcb7b63de08ccfee19d883a [^]
2009-05-07 23:26psarobeStatusresolved => closed
2009-05-08 00:00anonymoussf_bug_id0 => 2788667
2009-07-03 13:14hgbotCheckin
2009-07-03 13:14hgbotNote Added: 0017867
2009-07-03 13:14hgbotStatusclosed => resolved
2009-07-03 13:14hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/ce3c0e6ad8603eb0ebcb7b63de08ccfee19d883a [^] => http://code.openbravo.com/erp/devel/pi/rev/f3a95e88176ec0c12f644dfb863538a7c987f642 [^]
2009-07-21 16:24psarobeFixed in Version2.50MP1 => 2.50MP3
2009-07-21 16:26psarobeTag Attached: 250MP3releasecandidate
2009-07-26 22:11psarobeStatusresolved => closed

Notes
(0016042)
hgbot   
2009-05-05 12:01   
Repository: erp/devel/pi
Changeset: ce3c0e6ad8603eb0ebcb7b63de08ccfee19d883a
Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com>
Date: Tue May 05 12:01:00 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ce3c0e6ad8603eb0ebcb7b63de08ccfee19d883a [^]

Fixes bug 0008897: Column type in Application dictionary different to Database column type - AD_Pinstance - UUID

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0017867)
hgbot   
2009-07-03 13:14   
Repository: erp/devel/pi
Changeset: f3a95e88176ec0c12f644dfb863538a7c987f642
Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com>
Date: Tue May 05 12:01:00 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f3a95e88176ec0c12f644dfb863538a7c987f642 [^]

Fixes bug 0008897: Column type in Application dictionary different to Database column type - AD_Pinstance - UUID

---
M src-db/database/sourcedata/AD_COLUMN.xml
---