How to delete corrupted planning application?

Error Message:  delete application failed.
Solution:
Delete the app from shared services.
Delete the app from essbase (using EAS)
Go into the planning system relational tables

Table HSPSYS_APPLICATION, delete row relating to planning app, note the app_id.
Table HSPSYS_APP_CLUSTER_DTL, delete row with id that you have just noted down (a record may not exist so just ignore this step)
Table HSPSYS_PROPERTIES, delete records with id that you noted down.
Table HSPSYS_DATASOURCES, update app_id to -1 for the datasource you use for the planning app. (if you don't want to use the datasource again just delete the record)

Restart Planning.
Drop/Recreate the schema for the planning application, this is so the schema can be used again when you recreate the application.
Start again.

query:

select * from HSPSYS_APPLICATION;

delete from HSPSYS_APPLICATION where APP_ID=3

select * from HSPSYS_APP_CLUSTER_DTL;

select * from HSPSYS_PROPERTIES;

delete from HSPSYS_PROPERTIES where PROPERTY_ID=3;

select * from HSPSYS_DATASOURCE

update HSPSYS_DATASOURCE set DATASOURCE_ID=-1 where DATASOURCE_ID=1

or

delete from HSPSYS_DATASOURCE where DATASOURCE_ID=-1