Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040751Openbravo ERPA. Platformpublic2019-05-02 16:162019-05-09 11:19
Reportershuehner 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR19Q2Fixed in Version3.0PR19Q2 
Merge Request Status
Review Assigned Toshuehner
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040751: 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
blocks feature request 00407503.0PR19Q3 closed alostale Raise minimum supported Oracle database version from 11.1 to 11.2 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-05-02 16:18shuehnerTypefeature request => backport
2019-05-02 16:18shuehnerTarget Version3.0PR19Q3 => 3.0PR19Q2
2019-05-08 12:29hgbotCheckin
2019-05-08 12:29hgbotNote Added: 0111568
2019-05-08 12:29hgbotStatusscheduled => resolved
2019-05-08 12:29hgbotResolutionopen => fixed
2019-05-08 12:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR19Q2/rev/c03ee8a6a9c9502d23d18514dd873c4fc7dd2ecc [^]
2019-05-08 12:29alostaleAssigned Toplatform => alostale
2019-05-08 12:29alostaleReview Assigned To => shuehner
2019-05-09 11:19shuehnerNote Added: 0111588
2019-05-09 11:19shuehnerNote Deleted: 0111588
2019-05-09 11:19shuehnerNote Added: 0111589
2019-05-09 11:19shuehnerStatusresolved => closed
2019-05-09 11:19shuehnerFixed in Version => 3.0PR19Q2

Notes
(0111568)
hgbot   
2019-05-08 12:29   
Repository: erp/backports/3.0PR19Q2
Changeset: c03ee8a6a9c9502d23d18514dd873c4fc7dd2ecc
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed May 08 11:09:42 2019 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR19Q2/rev/c03ee8a6a9c9502d23d18514dd873c4fc7dd2ecc [^]

fixes 40751: 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
---
(0111589)
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.