Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012596Openbravo ERPA. Platformpublic2010-03-08 16:102010-04-07 11:30
Reporterplujan 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityrandom
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP1 
Target Version2.50MP14Fixed in Version2.50MP14 
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
Summary0012596: C_TAX_TRG.xml is not activated after an install.source
DescriptionI've performed an install.source. After that, I created a Tax Rate. When navigating to Accounting tab, I saw no accounting.
This behavior was caused when executing an install.source in an Oracle database. It also could be reproduced in Hudson CI environment.
Steps To Reproduce1. In an Oracle database, run an install.source
2. Login as an Admin and go to Financial Management > Accounting > Setup > Tax Rate
3. Create a new tax rate.
4. Move to Accounting tab. There is no data there.
5. Go into the database and check the trigger C_tax_trg. It was not created.
Proposed Solution
Additional Information
TagsRegression
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-03-08 16:10plujanNew Issue
2010-03-08 16:10plujanAssigned To => marvintm
2010-03-08 16:11plujanStatusnew => scheduled
2010-03-08 16:11plujanfix_in_branch => pi
2010-03-08 16:25plujanReproducibilityhave not tried => random
2010-03-08 16:25plujanfix_in_branchpi =>
2010-03-09 20:54plujanNote Added: 0025196
2010-03-11 10:01hgbotCheckin
2010-03-11 10:01hgbotNote Added: 0025232
2010-03-11 10:01hgbotStatusscheduled => resolved
2010-03-11 10:01hgbotResolutionopen => fixed
2010-03-11 10:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/99e483f330eaa4415652e5361b87121168d60de5 [^]
2010-03-12 15:41shuehnerNote Added: 0025296
2010-03-12 15:41shuehnerStatusresolved => closed
2010-03-12 15:41shuehnerFixed in Version => 2.50MP14
2010-03-12 22:41hudsonbotCheckin
2010-03-12 22:41hudsonbotNote Added: 0025424
2010-03-13 00:00anonymoussf_bug_id0 => 2969676
2010-03-17 15:42psarobeTag Attached: Regression
2010-04-07 11:30psarobeversionpi => 2.50MP1

Notes
(0025196)
plujan   
2010-03-09 20:54   
Additional information.
In order to reproduce it, after an install.source you have to follow these steps:
*Activate the instance
*Enable Heartbeat
*Install IDL (requires rebuilding)
*Install Spanish Localization Pack. After rebuilding, trigger is not present anymore.
(0025232)
hgbot   
2010-03-11 10:01   
Repository: erp/devel/pi
Changeset: 99e483f330eaa4415652e5361b87121168d60de5
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Mar 10 17:52:00 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/99e483f330eaa4415652e5361b87121168d60de5 [^]

Fixed issue 12596. Triggers will be loaded in the restricted models, so that if a table not belonging to the updated module is recreated, the triggers are also recreated. Also, done a change so that the same thing doesn't happen with NOT NULL restrictions.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0025296)
shuehner   
2010-03-12 15:41   
Tested steps to reproduce in pi rev: e6ff1e964bd7. After that process and doing export.database no unexpected trigger deletion were noticed.

-> Closing as fixed
(0025424)
hudsonbot   
2010-03-12 22:41   
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/99e483f330ea [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]