Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041075Retail ModulesStoreServerpublic2019-06-12 10:052019-06-12 23:01
ReporterAugustoMauch 
Assigned ToAugustoMauch 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomtaal
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0041075: Missing entry in excludeFilter results in update.database error
DescriptionFunctions used by SymmetricDS triggers start with the faa_sym_ prefix. SymmetricDS database components must be included in the excludeFilter.xml [1] file, because they must be ignored by dbsourcemanager, due to them being managed outside the import/export Openbravo flow.

They way the excludeFilter is defined now, when a table with symmetricds triggers is removed, the update.database command fails with the following erorr message:

     [java] 28402 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - SQL Command failed with: ERROR: function faa_sym_best_po_cttermialtyp_u() does not exist
     [java] 28411 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - -- -----------------------------------------------------------------------
     [java] -- FUNCTION FAA_SYM_BEST_PO_CTTERMIALTYP_U
     [java] -- -----------------------------------------------------------------------
     [java] DROP FUNCTION FAA_SYM_BEST_PO_CTTERMIALTYP_U()
     [java] 28420 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - SQL Command failed with: ERROR: function faa_sym_best_po_cttermialtyp_i() does not exist
     [java] 28429 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - -- END
     [java] -- -----------------------------------------------------------------------
     [java] -- FUNCTION FAA_SYM_BEST_PO_CTTERMIALTYP_I
     [java] -- -----------------------------------------------------------------------
     [java] DROP FUNCTION FAA_SYM_BEST_PO_CTTERMIALTYP_I()
     [java] 28439 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - SQL Command failed with: ERROR: function faa_sym_best_po_cttermialtyp_d() does not exist
     [java] 28448 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - -- END
     [java] -- -----------------------------------------------------------------------
     [java] -- FUNCTION FAA_SYM_BEST_PO_CTTERMIALTYP_D
     [java] -- -----------------------------------------------------------------------
     [java] DROP FUNCTION FAA_SYM_BEST_PO_CTTERMIALTYP_D()



[1] https://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/file/c618902eb69b/src-db/database/model/excludeFilter.xml [^]
Steps To ReproduceIn a multiserver environment:
- Modify the XML model to remove a table that is configured to be synchronized
- Execute update.database. An error similiar to the one shown in the description will be shown in the log
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-06-12 10:05AugustoMauchNew Issue
2019-06-12 10:05AugustoMauchAssigned To => AugustoMauch
2019-06-12 10:05AugustoMauchTriggers an Emergency Pack => No
2019-06-12 10:13hgbotCheckin
2019-06-12 10:13hgbotNote Added: 0112598
2019-06-12 10:13hgbotStatusnew => resolved
2019-06-12 10:13hgbotResolutionopen => fixed
2019-06-12 10:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/c2ff03c953d25747e753b4490ecc5656075d2e53 [^]
2019-06-12 20:26mtaalReview Assigned To => mtaal
2019-06-12 23:01mtaalNote Added: 0112761
2019-06-12 23:01mtaalStatusresolved => closed

Notes
(0112598)
hgbot   
2019-06-12 10:13   
Repository: erp/pmods/org.openbravo.replication.symmetricds
Changeset: c2ff03c953d25747e753b4490ecc5656075d2e53
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed Jun 12 10:13:05 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/c2ff03c953d25747e753b4490ecc5656075d2e53 [^]

Fixes issue 41075: Adds proper exclude filter for SymmetricDS trigger functions

The previous exclude filter for trigger functions has not been removed, to decrease the risk
of regressions.

---
M src-db/database/model/excludeFilter.xml
---
(0112761)
mtaal   
2019-06-12 23:01   
reviewed