Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0037322
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionaryminorhave not tried2017-11-18 13:172017-12-14 13:19
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0037322: Remove technically useless ad_process entries

DescriptionThe ad_process table as a few rows which are technically useless because they call into one of the 3 following classes:

a.) as they do not contain either of:
- matching ad_model_object row
- procedurename value
- javaclass value
- jrname value

b.) They do contain a procedurename but no pl function with that name exists
Note: Manually excluded dba_recompile which is created only on oracle db

c.) They do contain a javaclass but that javaclass does not exist

That mean that they are technically not useful for anything and can be removed.
Steps To Reproducea.)
select p.isactive,p.ad_process_id, p.name, p.procedurename, p.classname, p.jrname from ad_process p where not exists (select 1 from ad_model_object mo where mo.ad_process_id = p.ad_process_id) and not exists (select 1 from information_schema.routines r where r.routine_schema = 'public' and r.routine_name ilike p.procedurename) and p.procedurename is null and p.classname is null and p.jrname is null order by p.ad_process_id

b.)
select p.isactive,p.ad_process_id, p.name, p.procedurename, p.classname, p.jrname from ad_process p where not exists (select 1 from ad_model_object mo where mo.ad_process_id = p.ad_process_id) and not exists (select 1 from information_schema.routines r where r.routine_schema = 'public' and r.routine_name ilike p.procedurename) and p.procedurename is not null and p.procedurename <> 'DBA_Recompile' and p.classname is null and p.jrname is null;
Proposed SolutionDouble-check the argumentation above delete those useless ad_process entries and their related rows (ad_menu, ad_treenode related to the menu entries, ad_process_access)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0037478 newTriage Finance Modules Replace ad_element reference to core for a to be removed element with a new custom one in the module 
related to defect 0037441 newshuehner Retail Modules Retail part of erp issue 37322, cleanup of unused ad_process entries 
blocks design defect 0032688 acknowledgedplatform Openbravo ERP remove unused resources 

-  Notes
(0100603)
shuehner (administrator)
2017-11-18 14:44

Stats for removal:

select isactive, count(*) from ad_process group by 1;
 isactive | count
----------+-------
 Y | 324 -> 273
 N | 21 -> 21


select isactive, count(*) from ad_menu group by 1;
 isactive | count
----------+-------
 Y | 375 -> 375
 N | 65 -> 33

- Issue History
Date Modified Username Field Change
2017-11-18 13:17 shuehner New Issue
2017-11-18 13:17 shuehner Assigned To => shuehner
2017-11-18 13:17 shuehner Modules => Core
2017-11-18 13:17 shuehner Triggers an Emergency Pack => No
2017-11-18 13:17 shuehner Relationship added blocks 0032688
2017-11-18 13:25 shuehner Description Updated View Revisions
2017-11-18 13:25 shuehner Steps to Reproduce Updated View Revisions
2017-11-18 14:44 shuehner Note Added: 0100603
2017-12-10 16:35 shuehner Relationship added related to 0037441
2017-12-14 13:19 shuehner Relationship added related to 0037478


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker