AIP Console - Information - How to Delete an Application from AIP Console Databases

Purpose

This page will help you to delete an application completely from AIP Console

if you are unable to do the same from the GUI

or

if the application was removed from the Console GUI/ triplets deleted

and

the Delivery folder is removed but the entries still remain in the AIP Console H2 Database.

Applicable Platform

AIP Platform	Yes/No
CAST AIP 8.3

AIP Console Version	Yes/No
AIP Console 1.8.x or greater

Action Plan

For the application_guid below, it usually can be seen in the console URL for application actions, though you can also get it from : AIP Console - Information - V2 - How to get an application GUID for an application AIP Console

The below queries need to be run on the AIP Node H2 Database.

Delete Application Queries

--query1
SELECT ANALYSIS_RESULT_GUID FROM ANALYSIS WHERE VERSION_GUID IN (SELECT GUID FROM VERSION WHERE APPLICATION_GUID = '<APPLICATION_GUID>')
--(GET THE GUID)

--query2
SELECT CONNECTION_PROFILE_GUID FROM APPLICATION WHERE GUID = '<APPLICATION_GUID>'
--(GET THE GUID)

DELETE FROM SNAPSHOT_INDICATORS
WHERE SNAPSHOT_GUID IN (SELECT GUID FROM SNAPSHOT WHERE APPLICATION_GUID = '<APPLICATION_GUID>')

DELETE FROM SNAPSHOT WHERE APPLICATION_GUID = '<APPLICATION_GUID>'

DELETE FROM ANALYSIS
WHERE VERSION_GUID IN (SELECT GUID FROM VERSION WHERE APPLICATION_GUID = '<APPLICATION_GUID>')

DELETE FROM ANALYSIS_RESULT WHERE
GUID = '<guid FROM query 1>'

DELETE FROM VERSION_OBJECTIVES
WHERE VERSION_GUID IN (SELECT GUID FROM VERSION WHERE APPLICATION_GUID = '<APPLICATION_GUID>')

DELETE FROM VERSION WHERE APPLICATION_GUID = '<APPLICATION_GUID>'

DELETE FROM EXTENSION WHERE APPLICATION_GUID = '<APPLICATION_GUID>'

DELETE FROM REF_FINDER_CONFIG WHERE APPLICATION_GUID = '<APPLICATION_GUID>'

DELETE FROM CONFIGURATION_CHANGELOG WHERE APPLICATION_GUID = '<APPLICATION_GUID>'

DELETE FROM APPLICATION_MAVEN_REPOSITORIES WHERE APPLICATION_GUID = '<APPLICATION_GUID>'

DELETE FROM APPLICATION WHERE GUID = '<APPLICATION_GUID>'

DELETE FROM CONNECTION_PROFILE
WHERE GUID = '<guid from query 2>'

To access your h2 DB, please follow the steps in the document here - AIP Console - Information - How to Access Console and Node Databases then

Restart the Console and Node services for them to be in sync.
If the problem you are facing does not match any case listed in this page, report your problem to CAST Technical Support and provide the below Relevant input for CAST Technical Support to reproduce the issue..

Notes/comments

Ticket # 34364

Related Pages