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
------------------------------