Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010217Openbravo ERP00. Application dictionarypublic2009-08-10 11:552009-08-21 00:00
ReporterAinhoaPagola 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.4
Product Versionpi 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010217: Unable to install module if a column is added to Application Dictionary table.
DescriptionInstallation of a module that adds columns to application dictionary tables (such as ad_treenode) fails.

The process ends with build succesfull but there are errors in some database tasks.
Steps To ReproduceCreate a module that adds a column to a AD table.

See HCMC module attached. A column is added to AD_TreeNode table.
Check the log.

AD_treenode table is left inconsistent.
Proposed SolutionIf an update.database is performed after the module is installed, the problem is solved and everything works again.
Additional Information
TagsNo tags attached.
Relationships
Attached Files? org.openbravo.hcm.common-0.1.0.obx (232,510) 2009-08-10 11:55
https://issues.openbravo.com/file_download.php?file_id=1631&type=bug
log 20090810112222-apply.log (835,127) 2009-08-10 12:07
https://issues.openbravo.com/file_download.php?file_id=1632&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-08-10 11:55AinhoaPagolaNew Issue
2009-08-10 11:55AinhoaPagolaAssigned To => marvintm
2009-08-10 11:55AinhoaPagolaFile Added: org.openbravo.hcm.common-0.1.0.obx
2009-08-10 11:55AinhoaPagolaOBNetwork customer => No
2009-08-10 12:07AinhoaPagolaFile Added: 20090810112222-apply.log
2009-08-10 12:10AinhoaPagolaDescription Updated
2009-08-10 12:10AinhoaPagolaProposed Solution updated
2009-08-10 12:10AinhoaPagolaSteps to Reproduce Updated
2009-08-10 13:59AinhoaPagolaNote Added: 0018901
2009-08-11 10:36hgbotCheckin
2009-08-11 10:36hgbotNote Added: 0018909
2009-08-11 10:36hgbotStatusnew => resolved
2009-08-11 10:36hgbotResolutionopen => fixed
2009-08-11 10:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e4d0fba3b9988896683030d7ecc3cb25fa7dfa04 [^]
2009-08-11 12:19AinhoaPagolaNote Added: 0018911
2009-08-20 14:37sureshbabuStatusresolved => closed
2009-08-20 14:37sureshbabuNote Added: 0019112
2009-08-20 14:37sureshbabuFixed in Version => pi
2009-08-21 00:00anonymoussf_bug_id0 => 2841463

Notes
(0018901)
AinhoaPagola   
2009-08-10 13:59   
This issue is not reproduceable in Oracle.
(0018909)
hgbot   
2009-08-11 10:36   
Repository: erp/devel/pi
Changeset: e4d0fba3b9988896683030d7ecc3cb25fa7dfa04
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Aug 11 10:35:07 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e4d0fba3b9988896683030d7ecc3cb25fa7dfa04 [^]

Fixed issue 10217. Now there won't be foreign key and trigger related errors when a module adds a column to an Application Dictionary table.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0018911)
AinhoaPagola   
2009-08-11 12:19   
Tested with HCM module and works fine.
(0019112)
sureshbabu   
2009-08-20 14:37   
Tested working fine