Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014193Openbravo ERPY. DBSourceManagerpublic2010-08-16 10:002010-08-17 13:02
Reportermarvintm 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
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
Summary0014193: Oncreatedefault for column commercial_tier in ad_module is illegal, because it references other columns
DescriptionCurrently, oncreatedefaults which make a reference to other columns do not work, due to an issue in dbsourcemanager:

https://issues.openbravo.com/view.php?id=14020 [^]

As the fix for this issue was just recently reverted, the oncreatedefault will no longer work. Therefore, it needs to be removed.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0014020 scheduled marvintm oncreatedefaults which reference other columns from the same record are not correctly executed 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-08-16 10:00marvintmNew Issue
2010-08-16 10:00marvintmAssigned To => alostale
2010-08-16 10:01marvintmRelationship addedrelated to 0014020
2010-08-16 11:00hgbotCheckin
2010-08-16 11:00hgbotNote Added: 0029993
2010-08-16 11:00hgbotStatusnew => resolved
2010-08-16 11:00hgbotResolutionopen => fixed
2010-08-16 11:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c1409977273ee79d628b799fa3fb1db7416ea556 [^]
2010-08-16 14:16hgbotCheckin
2010-08-16 14:16hgbotNote Added: 0030019
2010-08-16 14:19hgbotCheckin
2010-08-16 14:19hgbotNote Added: 0030020
2010-08-16 16:39marvintmNote Added: 0030026
2010-08-16 16:39marvintmStatusresolved => closed
2010-08-17 00:00anonymoussf_bug_id0 => 3046651
2010-08-17 08:39hgbotCheckin
2010-08-17 08:39hgbotNote Added: 0030041
2010-08-17 13:02hudsonbotCheckin
2010-08-17 13:02hudsonbotNote Added: 0030055
2010-08-17 13:02hudsonbotCheckin
2010-08-17 13:02hudsonbotNote Added: 0030057
2010-08-17 13:02hudsonbotCheckin
2010-08-17 13:02hudsonbotNote Added: 0030058
2010-08-17 13:02hudsonbotCheckin
2010-08-17 13:02hudsonbotNote Added: 0030061

Notes
(0029993)
hgbot   
2010-08-16 11:00   
Repository: erp/devel/pi
Changeset: c1409977273ee79d628b799fa3fb1db7416ea556
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Aug 16 10:59:33 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c1409977273ee79d628b799fa3fb1db7416ea556 [^]

fixed issue 14193: Oncreatedefault for column commercial_tier in ad_module is illegal

  Removed mandatoriness from ad_module.commercial_tier column, now when it is first created
  it takes null by default so oncreate default clause is not needed anymore

---
M src-db/database/model/tables/AD_MODULE.xml
M src-db/database/model/triggers/AD_MODULE_VERSION_TRG.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
---
(0030019)
hgbot   
2010-08-16 14:16   
Repository: erp/devel/pi
Changeset: 9eed83e933e426be8174621cca8a12d6edb3b270
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Aug 16 14:16:06 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9eed83e933e426be8174621cca8a12d6edb3b270 [^]

related to issue 14193: Removed NA from ad_module_install

---
M src-db/database/model/tables/AD_MODULE_INSTALL.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0030020)
hgbot   
2010-08-16 14:19   
Repository: erp/devel/pi
Changeset: 121cde4dd41ba320397e417de3490b8401ab10a9
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Aug 16 14:18:54 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/121cde4dd41ba320397e417de3490b8401ab10a9 [^]

related to issue 14193: Removed NA from ad_module_install

---
M src-db/database/model/tables/AD_MODULE_INSTALL.xml
---
(0030026)
marvintm   
2010-08-16 16:39   
Verified that after the change modules can be installed correctly (even if they don't include tier information), and that newly created modules are still subject to the correct commercial restrictions (if a module is created and defined as commercial, a tier needs to be specified).
(0030041)
hgbot   
2010-08-17 08:39   
Repository: erp/devel/pi
Changeset: 0ceda0be723b087e62ae0cd3ba22f1559ef61d86
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Aug 17 08:39:01 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0ceda0be723b087e62ae0cd3ba22f1559ef61d86 [^]

related to issue 14193: Check tier only when updating commercial info

---
M src-db/database/model/triggers/AD_MODULE_VERSION_TRG.xml
---
(0030055)
hudsonbot   
2010-08-17 13:02   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/c1409977273e [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/4443754d9476 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18173.obx [^]
(0030057)
hudsonbot   
2010-08-17 13:02   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/9eed83e933e4 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/4443754d9476 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18173.obx [^]
(0030058)
hudsonbot   
2010-08-17 13:02   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/121cde4dd41b [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/4443754d9476 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18173.obx [^]
(0030061)
hudsonbot   
2010-08-17 13:02   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/0ceda0be723b [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/4443754d9476 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18173.obx [^]