Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018675Openbravo ERPA. Platformpublic2011-10-03 14:182011-10-12 02:01
Reportershuehner 
Assigned Tomarvintm 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP4Fixed in Version 
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
Summary0018675: int-modules-pgsql/1280/ failed with error related to translations & datasets
DescriptionThis job recently fails often (but not always) related to a inserting translation records via a dataset violating a unique constraint.

Example error message:
http://builds.openbravo.com/job/int-modules-pgsql/1280/artifact/SANDBOX/automation/pi/last-results/int-modules-pgsql/screenshots/installModules.png [^]

Relevant part of logfile (20111003101225-apply.log in int-modules-pgsql workspace):
     [java] 174266 [main] INFO org.openbravo.erpCommon.modules.ApplyModule - Importing data from European Union countries module. Dataset: European_Union_Country_Dataset.xml
     [java] 174676 [main] INFO org.openbravo.erpCommon.modules.ApplyModule - Importing data from Translation: Spanish-Spain (es_ES) español-España module. Dataset: Masterdata.xml
     [java] 179471 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into AD_Month_Trl (AD_Month_ID, AD_Language, AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby,
     [java] 179481 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: duplicate key value violates unique constraint "ad_month_trl_month_language_un"
     [java] 179521 [main] ERROR org.openbravo.erpCommon.modules.ApplyModule - isBatchUpdateException:duplicate key value violates unique constraint "ad_month_trl_month_language_un"
     [java] 179536 [main] ERROR org.openbravo.base.exception.OBException - isBatchUpdateException:duplicate key value violates unique constraint "ad_month_trl_month_language_un"
     [java] org.openbravo.base.exception.OBException: isBatchUpdateException:duplicate key value violates unique constraint "ad_month_trl_month_language_un"
     [java] at org.openbravo.erpCommon.modules.ApplyModule.execute(ApplyModule.java:166)
     [java] at org.openbravo.erpCommon.modules.ApplyModuleTask.doExecute(ApplyModuleTask.java:105)
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-10-03 14:18shuehnerNew Issue
2011-10-03 14:18shuehnerAssigned To => marvintm
2011-10-03 14:18shuehnerModules => Core
2011-10-03 16:34hgbotCheckin
2011-10-03 16:34hgbotNote Added: 0041465
2011-10-03 16:34hgbotStatusnew => resolved
2011-10-03 16:34hgbotResolutionopen => fixed
2011-10-03 16:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cdcdc25c1aacdc1514cc7fec5b116291feeff2f1 [^]
2011-10-06 11:12hgbotCheckin
2011-10-06 11:12hgbotNote Added: 0041525
2011-10-11 18:24iperdomoNote Added: 0041594
2011-10-11 18:24iperdomoStatusresolved => closed
2011-10-12 02:01hudsonbotCheckin
2011-10-12 02:01hudsonbotNote Added: 0041748

Notes
(0041465)
hgbot   
2011-10-03 16:34   
Repository: erp/devel/pi
Changeset: cdcdc25c1aacdc1514cc7fec5b116291feeff2f1
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Oct 03 16:33:30 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cdcdc25c1aacdc1514cc7fec5b116291feeff2f1 [^]

Fixed issue 18675. Trl tables will be matched by unique constraint on the DAL reference data import process.

---
M src/org/openbravo/dal/xml/BaseXMLEntityConverter.java
---
(0041525)
hgbot   
2011-10-06 11:12   
Repository: erp/stable/2.50
Changeset: 4ea4016ee815b7b684e9c11d6d5f9119d821c7ba
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Oct 06 11:08:51 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/4ea4016ee815b7b684e9c11d6d5f9119d821c7ba [^]

issue 18675. Trl tables will be matched by unique constraint on the DAL reference data import process.

---
M src/org/openbravo/dal/xml/BaseXMLEntityConverter.java
---
(0041594)
iperdomo   
2011-10-11 18:24   
Tested on pi @ rev 5782da5a0bb8
(0041748)
hudsonbot   
2011-10-12 02:01   
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/9bd2b5c2d982 [^]

Maturity status: Test