Maximo Open Forum

View Only

Back to discussions

Expand all | Collapse all

How to delete deprecated view from maximo

Amar Msaid06-22-2023 15:27

We have a view that is not used yet. i want to delete this view because when i change the configuration ...

Prashant Sharma06-23-2023 09:32

Replace <VIEWNAME> with view that you want to delete and run below queries- DELETE FROM ...

1. How to delete deprecated view from maximo

Like
Amar Msaid
Posted 06-22-2023 15:27

Reply Reply Privately
We have a view that is not used yet. i want to delete this view because when i change the configuration of fields in the object that is extended by this view, the view is marked as changed and when i apply changes there is errors in the database configuration. i can't correct the sql of the view because it reference a dblink to a server that has been removed from our organization.

so the question is: is it possible to delete a view from the database configuration application or by using sql requests ?

Thank you for helping.

#EverythingMaximo

------------------------------
Amar Msaid
Societe des traversiers de Quebec (STQ)
------------------------------
2. RE: How to delete deprecated view from maximo

Like
Prashant Sharma
Posted 06-23-2023 09:32

Reply Reply Privately
Replace <VIEWNAME> with view that you want to delete and run below queries-

DELETE FROM MAXOBJECT WHERE OBJECTNAME ='<VIEWNAME>'

DELETE FROM MAXOBJECTCFG WHERE OBJECTNAME ='<VIEWNAME>'

DELETE FROM MAXVIEW WHERE VIEWNAME ='<VIEWNAME>'

DELETE FROM MAXVIEWCFG WHERE VIEWNAME ='<VIEWNAME>'

DELETE FROM MAXATTRIBUTE WHERE OBJECTNAME ='<VIEWNAME>'

DELETE FROM MAXATTRIBUTECFG WHERE OBJECTNAME ='<VIEWNAME>'

Restart Maximo server after deletion.

------------------------------
Prashant Sharma
Sedin Technologies
Connect with me @ https://www.linkedin.com/in/psharmamaximo/

#IBM Champion 2022
#IBM Champion 2023
------------------------------

Newest Episode

Ep. 4 | System Properties in IBM Maximo

Watch Steven Shull walk through practical IBM Maximo system properties that can improve usability, query behavior, attachment handling, and the overall Maximo user experience.

Watch on YouTube Listen on Spotify