Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035492Openbravo ERPY. DBSourceManagerpublic2017-03-13 08:572017-03-17 08:25
Reporteralostale 
Assigned Toalostale 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelPre packaging ( pi )
Regression date2017-01-11
Regression introduced in releasepi
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/47c768943f70d1c674cb0a2701faf29edde3da84 [^]
Triggers an Emergency PackNo
Summary0035492: error checking pl consistency
DescriptionWhen exporting database translation consistency part always produces an error in log.
Steps To ReproduceIn a PG context:
1. Set core in developemnt
2. Export database
  -> Check log output:
      Exporting module: Core
      Checking translation consistency
      Error checking translation consistency
      Translation consistency check finished succesfully in 16135 ms
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by feature request 00346543.0PR17Q2 closed alostale some performance improvements in DBSM tasks 
related to defect 0035493 closed alostale missing log info when check consistency fails 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-03-13 08:57alostaleNew Issue
2017-03-13 08:57alostaleAssigned To => alostale
2017-03-13 08:57alostaleOBNetwork customer => No
2017-03-13 08:57alostaleModules => Core
2017-03-13 08:57alostaleRegression level => Pre packaging ( pi )
2017-03-13 08:57alostaleRegression date => 2017-01-11
2017-03-13 08:57alostaleRegression introduced in release => pi
2017-03-13 08:57alostaleRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/47c768943f70d1c674cb0a2701faf29edde3da84 [^]
2017-03-13 08:57alostaleTriggers an Emergency Pack => No
2017-03-13 08:57alostaleRelationship addedcaused by 0034654
2017-03-13 08:57alostaleSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=14776#r14776
2017-03-13 08:58alostaleReview Assigned To => caristu
2017-03-13 09:17alostaleRelationship addedrelated to 0035493
2017-03-13 09:33shuehnerIssue Monitored: shuehner
2017-03-13 12:12alostaleStatusnew => acknowledged
2017-03-14 09:23hgbotCheckin
2017-03-14 09:23hgbotNote Added: 0094988
2017-03-14 09:23hgbotStatusacknowledged => resolved
2017-03-14 09:23hgbotResolutionopen => fixed
2017-03-14 09:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7e2800bad2ba3ea0f9a48cc28f661e81ba2460ce [^]
2017-03-14 09:25hgbotCheckin
2017-03-14 09:25hgbotNote Added: 0094992
2017-03-14 09:25hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/7e2800bad2ba3ea0f9a48cc28f661e81ba2460ce [^] => http://code.openbravo.com/erp/devel/dbsm-main/rev/8c2f9c7b3ec80c9af6ddd57657e4160546bcd4e2 [^]
2017-03-15 20:22hudsonbotCheckin
2017-03-15 20:22hudsonbotNote Added: 0095294
2017-03-17 08:25caristuNote Added: 0095351
2017-03-17 08:25caristuStatusresolved => closed
2017-03-17 08:25caristuFixed in Version => 3.0PR17Q2

Notes
(0094988)
hgbot   
2017-03-14 09:23   
Repository: erp/devel/pi
Changeset: 7e2800bad2ba3ea0f9a48cc28f661e81ba2460ce
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Mar 14 09:21:07 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7e2800bad2ba3ea0f9a48cc28f661e81ba2460ce [^]

fixed bug 35492, fixed bug 35493: new dbsm

  Includes:
    * 35492 - Fixes PG trigger translation consistency:
               - incorrect casting from Trigger to Function
               - use correct translator for triggers
    * 35493 - Missing log info in export.database:
               - replaced OBLogAppender which is not required by standard
                 ConsoleAppender
               - changed layout so that time and log level (INFO, WARN...) is
                 displayed

---
M src-db/database/lib/dbsourcemanager.jar
---
(0094992)
hgbot   
2017-03-14 09:25   
Repository: erp/devel/dbsm-main
Changeset: 8c2f9c7b3ec80c9af6ddd57657e4160546bcd4e2
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Mar 13 09:26:00 2017 +0100
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/8c2f9c7b3ec80c9af6ddd57657e4160546bcd4e2 [^]

fixed bug 35492: error checking pl consistency

  There were two problems in PG PL concistency checking for triggers:
    * They were incorrectly casted to Function
    * They were not translated with the specific trigger translator

---
M src/org/apache/ddlutils/platform/postgresql/PostgrePLSQLConsistencyChecker.java
---
(0095294)
hudsonbot   
2017-03-15 20:22   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/54e102bef53e [^]
Maturity status: Test
(0095351)
caristu   
2017-03-17 08:25   
Code reviewed + testing OK.