Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014397Openbravo ERPA. Platformpublic2010-09-01 19:262010-09-13 12:38
Reporterjpabloae 
Assigned Tomarvintm 
PriorityurgentSeverityminorReproducibilityrandom
StatusclosedResolutionfixed 
PlatformOS30OS VersionProfessional Appliance
Product Versionpi 
Target Version2.50MP22Fixed in Version2.50MP22 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014397: Disable check constraints before importing the sample data, enable them when it finishes
DescriptionThere are cases in which Hibernate is not able to insert the data in a way that it complies with all the check constraints. For example with the combination of pi at 1d662363a99c and BigBazaar.xml. Example:

BUILD FAILED
/tmp/oberp.2.50MP21/OpenbravoERP/build.xml:652: The following error occurred while executing this line:
/tmp/oberp.2.50MP21/OpenbravoERP/build.xml:565: The following error occurred while executing this line:
/tmp/oberp.2.50MP21/OpenbravoERP/src/build.xml:238: org.openbravo.base.exception.OBException: Exception
(org.postgresql.util.PSQLException: ERROR: new row for relation c_debt_payment" violates check constraint "c_debt_payment_isdirectpos_chk") while importing from file /tmp/oberp.2.50MP21/OpenbravoERP/referencedata/sampledata/BigBazaar.xml
Steps To Reproduce
Proposed SolutionDisable the check constraints before importing the sample data and enable them once the process is finished.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-09-01 19:26jpabloaeNew Issue
2010-09-01 19:26jpabloaeAssigned To => marvintm
2010-09-01 19:26jpabloaeOBNetwork customer => No
2010-09-02 12:19jpabloaeIssue Monitored: iciordia
2010-09-06 08:10alostaleStatusnew => scheduled
2010-09-07 14:58hgbotCheckin
2010-09-07 14:58hgbotNote Added: 0030764
2010-09-07 14:58hgbotStatusscheduled => resolved
2010-09-07 14:58hgbotResolutionopen => fixed
2010-09-07 14:58hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/86a42dfae94e4b427a6b7fc2b8e638790a0b977d [^]
2010-09-07 16:04hgbotCheckin
2010-09-07 16:04hgbotNote Added: 0030770
2010-09-07 20:20hudsonbotCheckin
2010-09-07 20:20hudsonbotNote Added: 0030789
2010-09-07 20:20hudsonbotCheckin
2010-09-07 20:20hudsonbotNote Added: 0030791
2010-09-08 23:52jpabloaeNote Added: 0030873
2010-09-08 23:52jpabloaeStatusresolved => closed
2010-09-08 23:52jpabloaeFixed in Version => 2.50MP22
2010-09-09 00:31jpabloaeRelationship addedrelated to 0014264
2010-09-09 00:31jpabloaeRelationship deletedrelated to 0014264
2010-09-13 12:38anonymoussf_bug_id0 => 3065196

Notes
(0030764)
hgbot   
2010-09-07 14:58   
Repository: erp/devel/pi
Changeset: 86a42dfae94e4b427a6b7fc2b8e638790a0b977d
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Sep 07 11:55:32 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/86a42dfae94e4b427a6b7fc2b8e638790a0b977d [^]

Fixed issue 14397. Check constraints will be disabled when importing reference data

---
M src-db/database/lib/dbsourcemanager.jar
M src/org/openbravo/service/db/ImportReferenceDataTask.java
---
(0030770)
hgbot   
2010-09-07 16:04   
Repository: erp/devel/pi
Changeset: 09b82e443ae8836730aa78ff7784424332eb1b37
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Sep 07 15:54:09 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/09b82e443ae8836730aa78ff7784424332eb1b37 [^]

Related to issue 14397. Checks will not be disabled while disabling not nulls.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0030789)
hudsonbot   
2010-09-07 20:20   
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/86a42dfae94e [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/d96658b2e9bd [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18356.obx [^]
(0030791)
hudsonbot   
2010-09-07 20:20   
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/09b82e443ae8 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/d96658b2e9bd [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18356.obx [^]
(0030873)
jpabloae   
2010-09-08 23:52   
Verified by running a full build with the BigBazaar.xml sampledata. Previously it failed, as explained in the issue report summary. Now the build is succesful, so I'm closing the issue.