Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0054709Openbravo ERPA. Platformpublic2024-02-19 14:432024-03-15 14:11
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR24Q2 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0054709: Oracle Cleanup: Remove Recompile db objects (dba_recompile) and dba_afterimport
DescriptionWith oracle support removed those oracle specific pl-functions can be removed as well

Specifically:
a.) pl function dba_recompile
and its ad_process entry 185 (Recompile DB Objects)
b.) dba_afterimport pl-function
- not called anywhere
- but calling a.) itself
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks feature request 0053658 new shuehner Tracking issue: Code cleanup after removing Oracle support 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2024-02-19 14:43shuehnerNew Issue
2024-02-19 14:43shuehnerAssigned To => shuehner
2024-02-19 14:43shuehnerModules => Core
2024-02-19 14:43shuehnerTriggers an Emergency Pack => No
2024-02-19 14:43shuehnerIssue generated from0053661
2024-02-19 14:43shuehnerRelationship addedblocks 0053658
2024-02-19 14:50shuehnerSummaryOracle Cleanup: Remove Recompile db objects (dba_recompile) => Oracle Cleanup: Remove Recompile db objects (dba_recompile) and dba_afterimport
2024-02-19 14:50shuehnerDescription Updatedbug_revision_view_page.php?rev_id=27550#r27550
2024-02-19 15:04hgbotNote Added: 0160916
2024-02-19 17:09hgbotNote Added: 0160940
2024-03-15 14:10hgbotNote Added: 0162237
2024-03-15 14:10hgbotNote Added: 0162238
2024-03-15 14:11hgbotNote Added: 0162239
2024-03-15 14:11hgbotResolutionopen => fixed
2024-03-15 14:11hgbotStatusnew => closed
2024-03-15 14:11hgbotFixed in Version => PR24Q2
2024-03-15 14:11hgbotNote Added: 0162240

Notes
(0160916)
hgbot   
2024-02-19 15:04   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1147 [^]
(0160940)
hgbot   
2024-02-19 17:09   
Merge Request created: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/64 [^]
(0162237)
hgbot   
2024-03-15 14:10   
Repository: https://gitlab.com/openbravo/ci/backoffice-api [^]
Changeset: 15a8a6196c8452e45ca157a7d5a32416d995e541
Author: Stefan Huehner <stefan.huehner@openbravo.com>
Date: 14-03-2024 16:26:19
URL: https://gitlab.com/openbravo/ci/backoffice-api/-/commit/15a8a6196c8452e45ca157a7d5a32416d995e541 [^]

ISSUE-54709: Remove oracle specific dba_recompile process

---
M java/reference/java.japi.gz
M model/src-db/database/sourcedata/AD_MENU.xml
M model/src-db/database/sourcedata/AD_PROCESS.xml
M model/src-db/database/sourcedata/AD_TREENODE.xml
---
(0162238)
hgbot   
2024-03-15 14:10   
Merge request merged: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/64 [^]
(0162239)
hgbot   
2024-03-15 14:11   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1147 [^]
(0162240)
hgbot   
2024-03-15 14:11   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 9209c5535554086bdf739f87ef02e76f698e054e
Author: Stefan Huehner <stefan.huehner@openbravo.com>
Date: 14-03-2024 15:56:31
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/9209c5535554086bdf739f87ef02e76f698e054e [^]

Fixes ISSUE-54709: Remove oracle specific dba_recompile,dba_afterimport

- dba_aftermport pl function was defined in postscript-Oracle but never
  called.
- dba_recompile was called at the end of postscript-Oracle (on oracle
  only) and was also callable via menu item "Recompile DB Objects".

Remove both as leftovers from old oracle support

---
M src-db/database/model/excludeFilter.xml
M src-db/database/model/postscript-Oracle.sql
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_PROCESS.xml
M src-db/database/sourcedata/AD_TREENODE.xml
---