April 12, 2012

How to delete a Maximo application

Maximo does not allow to delete applications from the Application Designer. However, there is a trick well hidden in the Application Developer Guide to accomplish this task using a SQL client. Note that only user defined application should be deleted. Out-of-the-box applications can be hidden using the standard Maximo security mechanism.

It is better to backup the Maximo database and shut down the application server before proceeding.
To delete an application, open a database editor and complete the following steps:
  1. Open an SQL client and connect to MAXIMO database.
  2. Type the following commands, replacing the variable with the name of the application you want to delete. Enter the application name in all uppercase. For example, if the name of the application you want to delete is TEST, replace APPNAME with TEST in all the commands.
delete from maxapps where app='APPNAME';
delete from maxpresentation where app='APPNAME';
delete from sigoption where app='APPNAME';
delete from applicationauth where app='APPNAME';
delete from maxlabels where app='APPNAME';
delete from maxmenu where moduleapp='APPNAME' and menutype!='Module';
delete from maxmenu where elementtype='APP' and keyvalue='APPNAME';
delete from appdoctype where app= 'APPNAME';

Remember to commit the transactions.
When using this procedure I discovered that there are other two tables that must be cleaned.
delete from sigoptflag where app='APPNAME';
delete from wfapptoolbar where appname='APPNAME';

5 comments:

  1. Perfect timing, I was just wondering this the other day!

    ReplyDelete
  2. Hi Bruno The last 2 statements are applicable to Maximo 7114 as well. I have used it with Maximo 7114

    ReplyDelete
  3. Thanks MaxSuri I have updated the post.

    ReplyDelete
  4. Bruno is there any simple query which can give us all custom apps within maximo?

    ReplyDelete
    Replies
    1. Try this
      https://www.ibm.com/developerworks/community/blogs/a9ba1efe-b731-4317-9724-a181d6155e3a/entry/what_customizations_were_made_to_my_maximo_asset_management_environment

      Delete