Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030187Openbravo ERPA. Platformpublic2015-06-16 11:232015-06-22 19:40
Reporteralostale 
Assigned Tocaristu 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q3Fixed in Version3.0PR15Q3 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030187: prevent build in unsupported PG verrsions
DescriptionPrevent system to be built in unsupported PostgreSQL versions [1]

[1] http://wiki.openbravo.com/wiki/System_Requirements [^]
Steps To ReproduceSystem shouldn't be built in unsupported versions, a message should be shown and the build should stop.
Proposed SolutionAdd a build validation to implement it.

Verify with RM team the versions to stop/warn.
Additional Information
TagsNo tags attached.
Relationships
related to feature request 00296753.0PR15Q3 closed caristu check DB and Tomcat have the same time at Tomcat start 
related to defect 00302163.0PR15Q3 closed caristu DatabaseVersionCheck should use org.apache.commons.lang.StringUtils class 
related to defect 0030337 closed alostale New pg version check which should only stop old pg versions fails to parse 9.5ahpha1 and also stop using it 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-06-16 11:23alostaleNew Issue
2015-06-16 11:23alostaleAssigned To => platform
2015-06-16 11:23alostaleModules => Core
2015-06-16 11:23alostaleTriggers an Emergency Pack => No
2015-06-16 11:24alostaleTarget Version => 3.0PR15Q4
2015-06-16 11:24alostaleRelationship addedrelated to 0029675
2015-06-16 11:24alostaleStatusnew => scheduled
2015-06-16 11:24alostaleAssigned Toplatform => caristu
2015-06-16 11:47alostaleTarget Version3.0PR15Q4 => 3.0PR15Q3
2015-06-18 17:01hgbotCheckin
2015-06-18 17:01hgbotNote Added: 0078372
2015-06-18 17:01hgbotStatusscheduled => resolved
2015-06-18 17:01hgbotResolutionopen => fixed
2015-06-18 17:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0609c9593fc7cd34a25959e41230528685f29578 [^]
2015-06-18 17:02caristuReview Assigned To => alostale
2015-06-18 17:02caristuIssue Monitored: alostale
2015-06-18 17:22caristuNote Added: 0078373
2015-06-18 17:23caristuNote Edited: 0078373bug_revision_view_page.php?bugnote_id=0078373#r8849
2015-06-19 11:29alostaleNote Added: 0078389
2015-06-19 11:29alostaleStatusresolved => closed
2015-06-19 11:29alostaleFixed in Version => 3.0PR15Q3
2015-06-19 23:57hudsonbotCheckin
2015-06-19 23:57hudsonbotNote Added: 0078398
2015-06-22 11:26caristuRelationship addedrelated to 0030216
2015-06-22 19:40caristuIssue Monitored: AugustoMauch
2015-06-22 19:40caristuIssue End Monitor: AugustoMauch
2015-07-10 12:16shuehnerRelationship addedrelated to 0030337

Notes
(0078372)
hgbot   
2015-06-18 17:01   
Repository: erp/devel/pi
Changeset: 0609c9593fc7cd34a25959e41230528685f29578
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Thu Jun 18 16:59:22 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0609c9593fc7cd34a25959e41230528685f29578 [^]

Fixes issue 30187: prevent build in unsupported PG versions

---
A src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DatabaseVersionCheck.class
A src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DatabaseVersionCheckData.class
A src-util/buildvalidation/src/org/openbravo/buildvalidation/DatabaseVersionCheck.java
A src-util/buildvalidation/src/org/openbravo/buildvalidation/DatabaseVersionCheck_data.xsql
---
(0078373)
caristu   
2015-06-18 17:22   
(edited on: 2015-06-18 17:23)
This new build validation prevents system to be built in unsupported PostgreSQL (and also Oracle) versions.

Furthermore, it displays a warning message when using a non recommended but still supported database version. Currently it does not contain any of these "warning" versions but they can be added easily when required, into an array already prepared for each database type.
(0078389)
alostale   
2015-06-19 11:29   
code reviewed

tested trying to update an Openbravo instance installed in a 8.4 PG version
(0078398)
hudsonbot   
2015-06-19 23:57   
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/53058d80de1d [^]
Maturity status: Test