What is the proper way to drop the Liferay tables in UMP?

book

Article ID: 38215

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction



What is the appropriate way to drop the Liferay tables from the UIM/UMP Database in UMP 8.x?

 

Environment

Release: CNMSPP99000-7.6-Unified Infrastructure Mgmt-Server Pack-- On Prem
Component:

Resolution

At times, Support may ask you to drop the Liferay tables from your UIM database to correct a problem with UMP.

There are multiple versions of the "drop tables" script which have been distributed in the past; some of these scripts may only work with UMP 6.x or 7.x.

The following script will work with all versions of UMP; some tables may generate "table does not exist" errors but these can be ignored.

Note that wasp should be deactivated before dropping the tables.  Do not drop the tables unless explicitly instructed to do so by CA Support.

 

drop table Account_;

drop table Address;

drop table AnnouncementsDelivery;

drop table AnnouncementsEntry;

drop table AnnouncementsFlag;

drop table AssetCategory;

drop table AssetCategoryProperty;

drop table AssetEntries_AssetCategories;

drop table AssetEntries_AssetTags;

drop table AssetEntry;

drop table AssetLink;

drop table AssetTag;

drop table AssetTagProperty;

drop table AssetTagStats;

drop table AssetVocabulary;

drop table BlogsEntry;

drop table BlogsStatsUser;

drop table BookmarksEntry;

drop table BookmarksFolder;

drop table BrowserTracker;

drop table CalEvent;

drop table ClassName_;

drop table ClusterGroup;

drop table Company;

drop table Contact_;

drop table Counter;

drop table Country;

drop table CyrusUser;

drop table CyrusVirtual;

drop table DDLRecord;

drop table DDLRecordSet;

drop table DDLRecordVersion;

drop table DDMContent;

drop table DDMStorageLink;

drop table DDMStructure;

drop table DDMStructureLink;

drop table DDMTemplate;

drop table DLContent;

drop table DLFileEntry;

drop table DLFileEntryMetadata;

drop table DLFileEntryType;

drop table DLFileEntryTypes_DDMStructures;

drop table DLFileEntryTypes_DLFolders;

drop table DLFileRank;

drop table DLFileShortcut;

drop table DLFileVersion;

drop table DLFolder;

drop table DLSync;

drop table EmailAddress;

drop table ExpandoColumn;

drop table ExpandoRow;

drop table ExpandoTable;

drop table ExpandoValue;

drop table Groups_Orgs;

drop table Groups_Permissions;

drop table Groups_Roles;

drop table Groups_UserGroups;

drop table Group_;

drop table IGFolder;

drop table IGImage;

drop table Image;

drop table JournalArticle;

drop table JournalArticleImage;

drop table JournalArticleResource;

drop table JournalContentSearch;

drop table JournalFeed;

drop table JournalStructure;

drop table JournalTemplate;

drop table Layout;

drop table LayoutBranch;

drop table LayoutPrototype;

drop table LayoutRevision;

drop table LayoutSet;

drop table LayoutSetBranch;

drop table LayoutSetPrototype;

drop table ListType;

drop table Lock_;

drop table MBBan;

drop table MBCategory;

drop table MBDiscussion;

drop table MBMailingList;

drop table MBMessage;

drop table MBMessageFlag;

drop table MBStatsUser;

drop table MBThread;

drop table MBThreadFlag;

drop table MDRAction;

drop table MDRRule;

drop table MDRRuleGroup;

drop table MDRRuleGroupInstance;

drop table MembershipRequest;

drop table Organization_;

drop table OrgGroupPermission;

drop table OrgGroupRole;

drop table OrgLabor;

drop table PasswordPolicy;

drop table PasswordPolicyRel;

drop table PasswordTracker;

drop table Permission_;

drop table Phone;

drop table PluginSetting;

drop table PollsChoice;

drop table PollsQuestion;

drop table PollsVote;

drop table PortalPreferences;

drop table Portlet;

drop table PortletItem;

drop table PortletPreferences;

drop table QUARTZ_BLOB_TRIGGERS;

drop table QUARTZ_CALENDARS;

drop table QUARTZ_CRON_TRIGGERS;

drop table QUARTZ_FIRED_TRIGGERS;

drop table QUARTZ_JOB_DETAILS;

drop table QUARTZ_JOB_LISTENERS;

drop table QUARTZ_LOCKS;

drop table QUARTZ_PAUSED_TRIGGER_GRPS;

drop table QUARTZ_SCHEDULER_STATE;

drop table QUARTZ_SIMPLE_TRIGGERS;

drop table QUARTZ_SIMPROP_TRIGGERS;

drop table QUARTZ_TRIGGERS;

drop table QUARTZ_TRIGGER_LISTENERS;

drop table RatingsEntry;

drop table RatingsStats;

drop table Region;

drop table Release_;

drop table Repository;

drop table RepositoryEntry;

drop table ResourceAction;

drop table ResourceBlock;

drop table ResourceBlockPermission;

drop table ResourceCode;

drop table ResourcePermission;

drop table ResourceTypePermission;

drop table Resource_;

drop table Roles_Permissions;

drop table Role_;

drop table SCFrameworkVersion;

drop table SCFrameworkVersi_SCProductVers;

drop table SCLicense;

drop table SCLicenses_SCProductEntries;

drop table SCProductEntry;

drop table SCProductScreenshot;

drop table SCProductVersion;

drop table ServiceComponent;

drop table Shard;

drop table ShoppingCart;

drop table ShoppingCategory;

drop table ShoppingCoupon;

drop table ShoppingItem;

drop table ShoppingItemField;

drop table ShoppingItemPrice;

drop table ShoppingOrder;

drop table ShoppingOrderItem;

drop table SocialActivity;

drop table SocialActivityAchievement;

drop table SocialActivityCounter;

drop table SocialActivityLimit;

drop table SocialActivitySetting;

drop table SocialEquityAssetEntry;

drop table SocialEquityHistory;

drop table SocialEquityLog;

drop table SocialEquitySetting;

drop table SocialEquityUser;

drop table SocialRelation;

drop table SocialRequest;

drop table Subscription;

drop table TasksProposal;

drop table TasksReview;

drop table Team;

drop table Ticket;

drop table UserGroup;

drop table UserGroupGroupRole;

drop table UserGroupRole;

drop table UserGroups_Teams;

drop table UserIdMapper;

drop table UserNotificationEvent;

drop table Users_Groups;

drop table Users_Orgs;

drop table Users_Permissions;

drop table Users_Roles;

drop table Users_Teams;

drop table Users_UserGroups;

drop table UserTracker;

drop table UserTrackerPath;

drop table User_;

drop table VirtualHost;

drop table Vocabulary;

drop table WebDAVProps;

drop table Website;

drop table WikiNode;

drop table WikiPage;

drop table WikiPageResource;

drop table WorkflowDefinitionLink;

drop table WorkflowInstanceLink;

drop table WorkflowInstanceLink;

drop table WSRP_WSRPConsumer;

drop table WSRP_WSRPConsumerPortlet;

drop table WSRP_WSRPProducer;