Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013298Openbravo ERPY. DBSourceManagerpublic2010-05-11 19:022010-05-18 21:44
Reportermarvintm 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.50MP17 
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
Summary0013298: In Oracle databases, triggers generated without a DECLARE statement are not created correctly in the database
DescriptionWhen a trigger which was created with a DECLARE statement is exported, it has an additional line end at the beginning of the body in the XML file. This additional line is not present in the case of triggers created without a DECLARE statement. When dbsourcemanager tries to create this kind of triggers in the database, it produces statements which contains "DECLAREBEGIN" words, which is obviously wrong.
Steps To ReproduceCreate a trigger without using a DECLARE statement in Oracle. Export it and do update.database. The trigger creation statement will fail
Proposed SolutionDBSM needs to be able to correctly insert triggers created this way.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-05-11 19:02marvintmNew Issue
2010-05-11 19:02marvintmAssigned To => marvintm
2010-05-11 19:04hgbotCheckin
2010-05-11 19:04hgbotNote Added: 0027150
2010-05-11 19:04hgbotStatusnew => resolved
2010-05-11 19:04hgbotResolutionopen => fixed
2010-05-11 19:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5c9a58ec18bccc45754b25292ebcd74d4a4c58f1 [^]
2010-05-14 09:15alostaleStatusresolved => closed
2010-05-14 09:15alostaleFixed in Version => 2.50MP16
2010-05-14 09:15alostaleStatusclosed => new
2010-05-14 09:15alostaleResolutionfixed => open
2010-05-14 09:15alostaleFixed in Version2.50MP16 =>
2010-05-14 09:15alostaleStatusnew => scheduled
2010-05-14 09:15alostalefix_in_branch => pi
2010-05-14 09:16alostaleStatusscheduled => resolved
2010-05-14 09:16alostaleResolutionopen => fixed
2010-05-14 09:16alostaleStatusresolved => closed
2010-05-14 09:16alostaleFixed in Version => 2.50MP17
2010-05-15 00:01anonymoussf_bug_id0 => 3001866
2010-05-18 21:44hudsonbotCheckin
2010-05-18 21:44hudsonbotNote Added: 0027514

Notes
(0027150)
hgbot   
2010-05-11 19:04   
Repository: erp/devel/pi
Changeset: 5c9a58ec18bccc45754b25292ebcd74d4a4c58f1
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue May 11 19:04:02 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5c9a58ec18bccc45754b25292ebcd74d4a4c58f1 [^]

Fixed issue 13298. Triggers created without DECLARE statements will now be created correctly in update.database and create.database.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0027514)
hudsonbot   
2010-05-18 21:44   
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/5c9a58ec18bc [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^]