Maximo Open Forum

 View Only

  • 1.  How to delete deprecated view from maximo

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

    Posted 06-23-2023 09:32

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

    Original Message


Related Content