Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007562Openbravo ERPA. Platformpublic2009-02-13 17:372009-04-22 00:00
mtaal 
marvintm 
highmajorhave not tried
closedfixed 
5
pi 
pi2.50beta 
Core
No
0007562: Update of module status fails resulting in difficult to understand issues later in the build process
The status of modules is updated in the beginning of the buildprocess:
in the database.postupdate step. If this fails (see below [1]) then this results in the following unpredictable behavior:
- the status of the core module is not set to P
- in the apply module step later in the build the referencedata of the module is not imported (this is the referencedata/standard/Masterdata.xml) because the core module does not have the correct status
- the import of sample data fails because it misses data, the error message of the import.sample.data is:
[importsampledata] org.openbravo.base.exception.OBException: org.hibernate.PropertyValueException: not-null property references a null or transient value: Currency.iSOCode

[1]
      [sql] Failed to execute: UPDATE AD_MODULE SET ISINDEVELOPMENT='N', ISDEFAULT='N', SEQNO=NULL, STATUS='P', UPDATE_AVAILABLE=NULL, ISREGISTERED='N' WHERE STATUS IS NULL OR STATUS='I'
      [sql] org.postgresql.util.PSQLException: ERROR: The version has to be formatted like x.y.z where x, y and z are integers.
      [sql] 9 of 10 SQL statements executed successfully


Proposed solution:
- perform the update statement for each module separately
- let the build fail if the update statements do not finish correctly
Modularity
Issue History
2009-02-13 17:37mtaalNew Issue
2009-02-13 17:37mtaalAssigned To => rafaroda
2009-02-13 17:37mtaalRegression testing => No
2009-02-13 17:39mtaalAssigned Torafaroda => marvintm
2009-02-17 18:23rafarodaPrioritynormal => high
2009-02-17 18:23rafarodaStatusnew => scheduled
2009-02-17 18:33rafarodaTag Attached: Modularity
2009-02-18 12:45svnbotCheckin
2009-02-18 12:45svnbotNote Added: 0013637
2009-02-18 12:45svnbotStatusscheduled => resolved
2009-02-18 12:45svnbotResolutionopen => fixed
2009-02-18 12:45svnbotsvn_revision => 13307
2009-04-21 10:33psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777939

Notes
(0013637)
svnbot   
2009-02-18 12:45   
Repository: openbravo
Revision: 13307
Author: marvintm
Date: 2009-02-18 12:45:42 +0100 (Wed, 18 Feb 2009)

Fixed issue 7562. Now build will fail if postcreate or postupdate tasks fail. This will ensure that import of masterdata and sampledata do not fail later on in the process.

---
U trunk/src-db/database/build-create.xml
U trunk/src-db/database/build.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13307&sc=1 [^]