Openbravo Issue Tracking System - Openbravo Localizations
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038691Openbravo LocalizationsLocalization Francepublic2018-06-04 10:382020-09-29 10:02
Reporterjoniturralde93 
Assigned To 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutioninvalid 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Support ticket
OBNetwork customerOBPS
Regression introduced in release
Summary0038691: France Professional Localization Pack incompatible with Oracle
DescriptionInstalled module in an Oracle environment and, when rebuilding the system or updating the database, an error is thrown.


Steps To Reproduce- Install France Professional Localization Pack
- Rebuild the system/update database
- Error is thrown
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by feature request 0038705 acknowledged Triage Platform Base Openbravo ERP DB Functions returning CLOB type are not supported in Oracle 
Attached Filestxt errorLogFranceLocalization.txt (606,207) 2018-06-04 12:41
https://issues.openbravo.com/file_download.php?file_id=11824&type=bug
diff patch83.diff (5,835) 2018-08-22 12:23
https://issues.openbravo.com/file_download.php?file_id=12067&type=bug
Issue History
Date ModifiedUsernameFieldChange
2018-06-04 10:38joniturralde93New Issue
2018-06-04 10:38joniturralde93Resolution time => 1529877600
2018-06-04 10:38joniturralde93OBNetwork customer => Yes
2018-06-04 11:25joniturralde93Description Updatedbug_revision_view_page.php?rev_id=17246#r17246
2018-06-04 12:41joniturralde93File Added: errorLogFranceLocalization.txt
2018-06-05 17:42joniturralde93Description Updatedbug_revision_view_page.php?rev_id=17257#r17257
2018-06-06 09:59psanjuanNote Added: 0104968
2018-06-06 09:59psanjuanRelationship addedcaused by 0038705
2018-06-07 16:22psanjuanNote Added: 0105006
2018-06-07 16:22psanjuanNote Added: 0105007
2018-08-22 12:23psanjuanNote Added: 0106442
2018-08-22 12:23psanjuanFile Added: patch83.diff
2018-08-22 12:24psanjuanNote Edited: 0106442bug_revision_view_page.php?bugnote_id=0106442#r17552
2018-08-23 18:07shuehnerNote Added: 0106465
2019-02-15 11:03psanjuanStatusnew => scheduled
2019-02-15 13:39psanjuanNote Added: 0109873
2020-09-25 11:10psanjuanNote Added: 0123376
2020-09-25 11:10psanjuanSeveritymajor => minor
2020-09-25 11:11psanjuanNote Deleted: 0123376
2020-09-29 10:01psanjuanResolution time1529877600 =>
2020-09-29 10:01psanjuanStatusscheduled => resolved
2020-09-29 10:01psanjuanResolutionopen => invalid
2020-09-29 10:02psanjuanNote Added: 0123446
2020-09-29 10:02psanjuanStatusresolved => closed

Notes
(0104968)
psanjuan   
2018-06-06 09:59   
Hi Daniel,

As it seems there is an error in Openbavo you can see below in [1]. We do not support functions that retrieve a concrete type (TEXT) in Oracle.

We have found such fucntion in one of your modules: modules/fr.phidias.localization.france.referencedata.masterdata/src-db/database/model/functions/PHMDF_SPELLNUMERICVALUE.xml

Therefore, is there any option to change/modify that function in your code so it can compile in Oracle?

Thanks and regards,

Patricia.

[1] https://issues.openbravo.com/view.php?id=38705 [^]
(0105006)
psanjuan   
2018-06-07 16:22   
Sorry Daniel,

let me clarify a bit. Would you please adjust that function so it is possible to compile and make it work?

That will give us the right basis to design the changes we would need to do to fix the issue 38705.

Thanks and regards,

Patricia.
(0105007)
psanjuan   
2018-06-07 16:22   
Hi Daniel,

Do you have any news on this?

While researching we have found another issue caused by a component that tries to execute below select: select * from phmdf_recalculate_bank_accno('0')
As far as we know above is select can not be executed that way in Oracle.

Please let me know if the Professional Pack is designed to work on Oracle installations. Can you fix these issues that are related to Oracle?

Let me know if we can support you on this somehow.
(0106442)
psanjuan   
2018-08-22 12:23   
(edited on: 2018-08-22 12:24)
email sent by Phidias dated on July 27th:

Concernant ce problème concernant un environnement de développement, donc d'un niveau trivial, nous allons le corriger dans la future version du pack de localization qui est prévue en octobre.

Un développeur ( Stefan Huehner) de chez Openbravo a modifié le module Phidias de localisation fr.phidias.localization.france.referencedata.masterdata en supprimant la fonction qui posait problème sans autorisation de Phidias. Le correctif est donc chez Openbravo mais voici en pièce jointe le fix à appliquer.

In English:

Regarding this problem concerning a development environment, so a trivial level, we will correct it in the future version of the localization pack that is planned for October.

A developer (Stefan Huehner) from Openbravo modified the phidias module for localization fr.phidias.localization.france.referencedata.masterdata by removing the function that caused problems without permission from Phidias. So the fix is Openbravo but here is the fix to apply.

See file patch83.diff
(0106465)
shuehner   
2018-08-23 18:07   
Hallo Patricia,
quick info here for the record (more already sent per mail).

- That change quoted was done by me with explicit prior ok from Daniel
- It was done in mercurial repository of phidias
- It fixes the oracle problem which is being discussed here
- But the fix was not published which is why installing from MMC still fails
(0109873)
psanjuan   
2019-02-15 13:39   
Issue changed as scheduled for the localizer to update the status of this issue. This issue is already resolved. Please update it properly.
email also sent.
(0123446)
psanjuan   
2020-09-29 10:02   
Resolved as invalid because this issue refers to Phidias professional localization pack do not compiling in Oracle.