Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029506Retail ModulesDiscounts and Promotionspublic2015-04-07 11:312015-05-29 11:30
Reporteradrianromero 
Assigned Tomalsasua 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in VersionRR15Q3 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029506: Compilation fails when the modules org.openbravo.retail.discounts and org.openbravo.retail.discounts.bytotal are instaled
DescriptionWhen the application is recompiled the build fails if these two modules are installed
Steps To Reproduce* Update the application from repositories including org.openbravo.retail.discounts and org.openbravo.retail.discounts.bytotal
* Build the application: ant smartbuild -Dlocal=no
* See that the application fails:

     [java] 151319 WARN - SQL Command failed with: ERROR: inserción o actualización en la tabla «ad_column» v
iola la llave foránea «ad_element_ad_column»
     [java] Detail: La llave (ad_element_id)=(E7767EB374444AE18FA65E1311A24EE3) no está presente en la tabla
 «ad_element».
     [java] 151325 WARN - -- END
     [java] ALTER TABLE AD_COLUMN
     [java] ADD CONSTRAINT AD_ELEMENT_AD_COLUMN FOREIGN KEY (AD_ELEMENT_ID) REFERENCES AD_ELEMENT (AD_ELEM
ENT_ID)

Proposed SolutionThe problem is that changeset :https://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts/rev/739cae2c8d6a [^] removes a register in org.openbravo.retail.discounts that is used in org.openbravo.retail.discounts.es_ES and org.openbravo.retail.discounts.bytotal

So the solution is to move the AD_ELEMENT register from org.openbravo.retail.discounts to org.openbravo.retail.discounts.bytotal and the translation from org.openbravo.retail.discounts.es_ES to org.openbravo.retail.discounts.bytotal.es_ES
Additional Information
TagsNo tags attached.
Relationships
caused by defect 0029493 closed malsasua dbconsistency process if failing for retail module 
related to defect 0029834 closed malsasua Discount rules for Retail by total module 1.0.1 is not compatible with PR15Q2 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-04-07 11:31adrianromeroNew Issue
2015-04-07 11:31adrianromeroAssigned To => malsasua
2015-04-07 11:31adrianromeroTriggers an Emergency Pack => No
2015-04-07 11:32adrianromeroRelationship addedcaused by 0029493
2015-04-07 13:43hgbotCheckin
2015-04-07 13:43hgbotNote Added: 0076364
2015-04-07 13:43hgbotStatusnew => resolved
2015-04-07 13:43hgbotResolutionopen => fixed
2015-04-07 13:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts.bytotal.es_ES/rev/e86b6040777bd7568dc700ff06e02c2c9a965862 [^]
2015-04-07 13:44hgbotCheckin
2015-04-07 13:44hgbotNote Added: 0076365
2015-04-07 13:44hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts.bytotal.es_ES/rev/e86b6040777bd7568dc700ff06e02c2c9a965862 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts.bytotal/rev/ad00af4ef331d60fa76f2c11ab2dd72e7c310904 [^]
2015-04-07 13:47hgbotCheckin
2015-04-07 13:47hgbotNote Added: 0076366
2015-04-07 13:47hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts.bytotal/rev/ad00af4ef331d60fa76f2c11ab2dd72e7c310904 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts.es_ES/rev/59b39d6f6ac319a6a78ee5efc3baa282fcc1702f [^]
2015-04-07 16:51adrianromeroReview Assigned To => adrianromero
2015-04-07 16:51adrianromeroNote Added: 0076372
2015-04-07 16:51adrianromeroStatusresolved => closed
2015-05-11 10:57alostaleRelationship addedrelated to 0029834
2015-05-21 12:54hgbotCheckin
2015-05-21 12:54hgbotNote Added: 0077622
2015-05-21 12:54hgbotStatusclosed => resolved
2015-05-21 12:54hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts.es_ES/rev/59b39d6f6ac319a6a78ee5efc3baa282fcc1702f [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts.bytotal/rev/e3cc0506dae8483f5264d5fbefa90338fbfadf3f [^]
2015-05-29 11:30marvintmReview Assigned Toadrianromero => marvintm
2015-05-29 11:30marvintmStatusresolved => closed
2015-05-29 11:30marvintmFixed in Version => RR15Q3

Notes
(0076364)
hgbot   
2015-04-07 13:43   
Repository: erp/pmods/org.openbravo.retail.discounts.bytotal.es_ES
Changeset: e86b6040777bd7568dc700ff06e02c2c9a965862
Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com>
Date: Tue Apr 07 13:43:39 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts.bytotal.es_ES/rev/e86b6040777bd7568dc700ff06e02c2c9a965862 [^]

fixed issue 29506: moved to this module element trl from retail.discounts.es_ES module

---
M referencedata/translation/es_ES/AD_ELEMENT_TRL_es_ES.xml
---
(0076365)
hgbot   
2015-04-07 13:44   
Repository: erp/pmods/org.openbravo.retail.discounts.bytotal
Changeset: ad00af4ef331d60fa76f2c11ab2dd72e7c310904
Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com>
Date: Tue Apr 07 13:44:34 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts.bytotal/rev/ad00af4ef331d60fa76f2c11ab2dd72e7c310904 [^]

fixed issue 29506: moved element to this module from retail.discounts module

---
M src-db/database/sourcedata/AD_ELEMENT.xml
---
(0076366)
hgbot   
2015-04-07 13:47   
Repository: erp/pmods/org.openbravo.retail.discounts.es_ES
Changeset: 59b39d6f6ac319a6a78ee5efc3baa282fcc1702f
Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com>
Date: Tue Apr 07 13:47:20 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts.es_ES/rev/59b39d6f6ac319a6a78ee5efc3baa282fcc1702f [^]

fixed issue 29506: removed element trl becaouse it was moved from retail.discounts module to retail.discounts.bytotal module

---
M referencedata/translation/es_ES/AD_ELEMENT_TRL_es_ES.xml
---
(0076372)
adrianromero   
2015-04-07 16:51   
Verified. The AD_ELEMENT register is now in the right module and the build ends successfully.
(0077622)
hgbot   
2015-05-21 12:54   
Repository: erp/pmods/org.openbravo.retail.discounts.bytotal
Changeset: e3cc0506dae8483f5264d5fbefa90338fbfadf3f
Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com>
Date: Thu May 21 12:54:08 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts.bytotal/rev/e3cc0506dae8483f5264d5fbefa90338fbfadf3f [^]

fixed issue 29506: removed element moved in chageset 32 and created a new element similar + updated version

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_MODULE.xml
---