0012196: create.database executes postcript before loading data

Description

When create.database is executed the postscript is run before inserting sourcedata. This makes scripts that relying on database data not to work.

Steps To Reproduce

1- 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 Solution

In 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).

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0024204) hgbot (developer) 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 (developer) 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 [^]

Issue History
Date Modified	Username	Field	Change
2010-02-10 09:14	alostale	New Issue
2010-02-10 09:14	alostale	Assigned To	=> marvintm
2010-02-10 09:15	alostale	Status	new => scheduled
2010-02-10 09:15	alostale	fix_in_branch	=> pi
2010-02-12 12:56	hgbot	Checkin
2010-02-12 12:56	hgbot	Note Added: 0024204
2010-02-12 12:56	hgbot	Status	scheduled => resolved
2010-02-12 12:56	hgbot	Resolution	open => fixed
2010-02-12 12:56	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/d54be7cf8fff822b7839b8a0f0ec39ae97ac9ce3 [^]
2010-02-15 17:39	hudsonbot	Checkin
2010-02-15 17:39	hudsonbot	Note Added: 0024359
2010-02-16 08:52	alostale	Status	resolved => closed
2010-02-16 08:52	alostale	Fixed in Version	=> 2.50MP12
2010-02-17 00:01	anonymous	sf_bug_id	0 =>
2010-03-10 18:29	anonymous	sf_bug_id	=> 2968039