Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0014397 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | random | 2010-09-01 19:26 | 2010-09-13 12:38 | |||
| Reporter | jpabloae | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP22 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 86a42dfae94e | ||||
| Projection | none | ETA | none | Target Version | 2.50MP22 | |||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Professional Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | pi | SCM revision | 1d662363a99c | |||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0014397: Disable check constraints before importing the sample data, enable them when it finishes | |||||||
| Description | There 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 | |||||||
| Proposed Solution | Disable the check constraints before importing the sample data and enable them once the process is finished. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0030764) hgbot (developer) 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 (developer) 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 (viewer) 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 (viewer) 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 (viewer) 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. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-09-01 19:26 | jpabloae | New Issue | |
| 2010-09-01 19:26 | jpabloae | Assigned To | => marvintm |
| 2010-09-01 19:26 | jpabloae | OBNetwork customer | => No |
| 2010-09-02 12:19 | jpabloae | Issue Monitored: iciordia | |
| 2010-09-06 08:10 | alostale | Status | new => scheduled |
| 2010-09-07 14:58 | hgbot | Checkin | |
| 2010-09-07 14:58 | hgbot | Note Added: 0030764 | |
| 2010-09-07 14:58 | hgbot | Status | scheduled => resolved |
| 2010-09-07 14:58 | hgbot | Resolution | open => fixed |
| 2010-09-07 14:58 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/86a42dfae94e4b427a6b7fc2b8e638790a0b977d [^] |
| 2010-09-07 16:04 | hgbot | Checkin | |
| 2010-09-07 16:04 | hgbot | Note Added: 0030770 | |
| 2010-09-07 20:20 | hudsonbot | Checkin | |
| 2010-09-07 20:20 | hudsonbot | Note Added: 0030789 | |
| 2010-09-07 20:20 | hudsonbot | Checkin | |
| 2010-09-07 20:20 | hudsonbot | Note Added: 0030791 | |
| 2010-09-08 23:52 | jpabloae | Note Added: 0030873 | |
| 2010-09-08 23:52 | jpabloae | Status | resolved => closed |
| 2010-09-08 23:52 | jpabloae | Fixed in Version | => 2.50MP22 |
| 2010-09-09 00:31 | jpabloae | Relationship added | related to 0014264 |
| 2010-09-09 00:31 | jpabloae | Relationship deleted | related to 0014264 |
| 2010-09-13 12:38 | anonymous | sf_bug_id | 0 => 3065196 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |