Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012196Openbravo ERPA. Platformpublic2010-02-10 09:142010-03-10 18:29
Reporteralostale 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version2.50MP12Fixed in Version2.50MP12 
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
Summary0012196: create.database executes postcript before loading data
DescriptionWhen create.database is executed the postscript is run before inserting sourcedata. This makes scripts that relying on database data not to work.
Steps To Reproduce1- Copy sources of a module that has not been updated to the latest modularity rules (prior to mp9) having tabs and windows to the modules directory.
2- Run install.source
3- Check that in the compilation log appears errors in the following entry: Errors for Validation type: HTML Mapping
4- Run in DB the posscript piece that fixes it:
    alter table ad_tab disable trigger ad_tab_mod_trg;
    update ad_tab set name = 'M'||name where ad_module_id != '0';
    update ad_tab set name = substr(name,2) where ad_module_id != '0';
    alter table ad_tab enable trigger ad_tab_mod_trg;
5- Run ant validate.wad and check now there're no errors
 
Proposed SolutionIn create.database execute postscript after importing data, as it is done in update.database.

After this fix, in step 3 there shouldn't be HTML mapping errors (4 and 5 wouldn't be longer required).
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-10 09:14alostaleNew Issue
2010-02-10 09:14alostaleAssigned To => marvintm
2010-02-10 09:14alostaleOBNetwork customer => No
2010-02-10 09:15alostaleStatusnew => scheduled
2010-02-10 09:15alostalefix_in_branch => pi
2010-02-12 12:56hgbotCheckin
2010-02-12 12:56hgbotNote Added: 0024204
2010-02-12 12:56hgbotStatusscheduled => resolved
2010-02-12 12:56hgbotResolutionopen => fixed
2010-02-12 12:56hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d54be7cf8fff822b7839b8a0f0ec39ae97ac9ce3 [^]
2010-02-15 17:39hudsonbotCheckin
2010-02-15 17:39hudsonbotNote Added: 0024359
2010-02-16 08:52alostaleStatusresolved => closed
2010-02-16 08:52alostaleFixed in Version => 2.50MP12
2010-02-17 00:01anonymoussf_bug_id0 =>
2010-03-10 18:29anonymoussf_bug_id => 2968039

Notes
(0024204)
hgbot   
2010-02-12 12:56   
Repository: erp/devel/pi
Changeset: d54be7cf8fff822b7839b8a0f0ec39ae97ac9ce3
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Fri Feb 12 12:56:29 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d54be7cf8fff822b7839b8a0f0ec39ae97ac9ce3 [^]

Fixed issue 12196. Postscript will be also executed at the end of create.database.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0024359)
hudsonbot   
2010-02-15 17:39   
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/d54be7cf8fff [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/2596487a564c [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16391.obx [^]