Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040750Openbravo ERPA. Platformpublic2019-05-02 16:162019-05-09 11:19
Reportershuehner 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR19Q3Fixed in Version3.0PR19Q3 
Merge Request Status
Review Assigned Toshuehner
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040750: Raise minimum supported Oracle database version from 11.1 to 11.2
DescriptionCurrently Openbravo support oracle 11.1 as oldest oracle version.

In some places in the code there is specific code to handle 11.1 differently compared to more modern oracle versions. Recently some bug came up specifically in that code raising the 'what to support question'

Oracle themselves marked 11.1 as end of live already in 2015:
https://www.oracle.com/us/assets/lifetime-support-technology-069183.pdf [^]

Checking Openbravo heartbeat statistics shows only a single installation using 11.1 (and owner is informed to upgrade)

Note that Oracle 11.2 stays as supported version for now as it is still much more widely used
Steps To Reproduce-
Proposed SolutionRaise minimum supported oracle version to 11.2 both in documentation and in the product (buildvalidation: DatabaseVersionCheck.java)
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0040809 acknowledged Triage Platform Base Openbravo ERP allow buildvalidations to be executed during install.source 
depends on backport 00407513.0PR19Q2 closed alostale Openbravo ERP Raise minimum supported Oracle database version from 11.1 to 11.2 
blocks feature request 00407523.0PR19Q4 closed dmiguelez Openbravo ERP Simplify oracle version specific code after no longer supporting Oracle 11.1 
blocks feature request 0040753 new Retail Retail Modules Simplify oracle version specific code after no longer supporting Oracle 11.1 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-05-02 16:16shuehnerNew Issue
2019-05-02 16:16shuehnerAssigned To => platform
2019-05-02 16:16shuehnerModules => Core
2019-05-02 16:16shuehnerTriggers an Emergency Pack => No
2019-05-02 16:17shuehnerStatusnew => scheduled
2019-05-02 16:17shuehnerNote Added: 0111439
2019-05-02 16:25shuehnerRelationship addedblocks 0040752
2019-05-02 16:27shuehnerRelationship addedblocks 0040753
2019-05-02 18:08shuehnerNote Added: 0111447
2019-05-08 12:27hgbotCheckin
2019-05-08 12:27hgbotNote Added: 0111567
2019-05-08 12:27hgbotStatusscheduled => resolved
2019-05-08 12:27hgbotResolutionopen => fixed
2019-05-08 12:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c61f84925352a306472da8b9d7cae7d55427a4f1 [^]
2019-05-08 12:27alostaleAssigned Toplatform => alostale
2019-05-08 12:28alostaleReview Assigned To => shuehner
2019-05-08 12:40alostaleRelationship addedrelated to 0040809
2019-05-09 11:19shuehnerNote Added: 0111590
2019-05-09 11:19shuehnerStatusresolved => closed
2019-05-09 11:19shuehnerFixed in Version => 3.0PR19Q3

Notes
(0111439)
shuehner   
2019-05-02 16:17   
Create backport for 19Q2 as agreement to do this raise of min-version already in Q2 release.
(0111447)
shuehner   
2019-05-02 18:08   
for context:
Recent bug found in is11R2orNewer:
https://code.openbravo.com/erp/pmods/org.openbravo.retail.orderpreparation/rev/1ae05702936e [^]
(0111567)
hgbot   
2019-05-08 12:27   
Repository: erp/devel/pi
Changeset: c61f84925352a306472da8b9d7cae7d55427a4f1
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed May 08 11:09:42 2019 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c61f84925352a306472da8b9d7cae7d55427a4f1 [^]

fixes 40750: raised minimum supported Oracle database version from 11.1 to 11.2

---
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DatabaseVersionCheck.class
M src-util/buildvalidation/src/org/openbravo/buildvalidation/DatabaseVersionCheck.java
M src-util/diagnostic/config/diagnostics.properties
---
(0111590)
shuehner   
2019-05-09 11:19   
Code changes reviewed and fine.
Tested:
- on local oracle 11.2.0.1.0
- ant buildvalidation -> passes fine
- ant diagnostic -> pass check.db part fine
Indirectly in ci:
- int-checks-oracle
- runs with oracle 12.1 and passes fine.

Running tests indirectly also ensures compiled.class file matches sources changes.