Hi @Tracy Norwillo 

Hope following information in techdoc will help you to handle your requirement

Remove Obsolete Objects Section¶

This section should be placed at the end of the UPG file. Here obsolete views, packages, report tables, temporary tables, indexes, constraints and sequences can be dropped. Developers should never 'drop' any columns or tables that could cause data loss for the customer. Instead, there are methods in Database_SYS for obsoleting these two objects, Obsolete_Column and Obsolete_Table. These methods drop constaints etc. and renames them with a certain pattern. Columns are prefixed with OBSOLETE_COLUMN and tables with OBSLETE, but also suffixed with the component name. The removal of the renamed objects should be handled in the <Component-short-name>cl.sql file (clear-script).

https://docs.ifs.com/techdocs/22r2/060_development/027_base_server_dev/007_concepts/200_upgrade_scripts/020_cdb_files/#remove_obsolete_objects

https://docs.ifs.com/techdocs/22r2/060_development/027_base_server_dev/007_concepts/200_upgrade_scripts/010_upg_files/#remove_obsolete_objects_section

/Harshini 

Thanks @hamalk , that makes sense for the database objects. 

Are the “404 Not Found” errors for the examples just a temporary thing or have examples not yet been created for the tech docs?  I was looking for an example of the clear script.

Is there any advice on removing the report model related files like the .rdf, xsd, and report projection?

Hi @Tracy Norwillo 

 “404 Not Found” errors are there for non working links which need to be fixed.

tagging @ChanakaAmarasekara , any comments on following? 

Is there any advice on removing the report model related files like the .rdf, xsd, and report projection?

\

/Harshini

Thanks again @hamalk, I did find an existing clear script to reference on one of our client’s instances.  I also found the database_sys.obsolete_table procedure. 

This isn’t related to my question, but on Cloud 21r2, I could not find the database_sys.obsolete_column procedure that’s referenced in the tech doc.

Hi,

I guess Harshini has pointed you on how you can remove the database objects (table, view and package etc)

To remove the report instance and all related connections like projection, clients, definitions etc. you can use the report_sys.remove_report_definition and pass the report ID as a parameter. This should be in your drop script.

As for the physical files, RDF, XSD, RDL etc. You can obsolete it as the normal way that you would obsolete a file in your repo by replacing it will dummy files.

Eg. proj\source\proj\database\ProjctItemReservedMat.rdf

@hamalk I guess it’s ok to replace the .report  module file with a dummy file as well. If not suggest what to do.

Regards,

Chanaka

@ChanakaAmarasekara , if you want to remove .report model file you can always obsolete the model file using the Navigator RMB option “Obsolete File” in Developer studio tool 

@hamalk  and @ChanakaAmarasekara - Thanks to both of you.