Delete workspace and projects from repository in HANA

[Former Member]

Hello,

Can anyone suggest me best deletion steps to delete .project and .settings in HANA.

Tried scn:http://scn.sap.com/message/14020589 but doesn't helped me still gives "Repository package is not empty" also tried refactor .

i need to delete the complete package from HANA instance ,can anyone suggest for my query?

Regards,

Reddy Rajesh M.

[vivekbhoj · Accepted solution]

Hi Rajesh,

Check the below thread for the solution:

http://scn.sap.com/thread/3451037

Regards,

Vivek

[Former Member · Accepted solution]

Thanks Vivek for your kind suggestion.

But given thread mentioned about inactive objects .In my case i've UI and Java script files and i'm unable to delete them directly also tried to delete directly from workbench and in repository

but fails.see error message for reference

throws popup message :

[vivekbhoj · Accepted solution]

Hi Rajesh,

Follow the below steps as mentioned in the thread:

http://scn.sap.com/thread/3244864

show all active objects to make sure we only get the ones we see in the repository explorer and cannot delete there...

select * from "_SYS_REPO"."ACTIVE_OBJECT" where "PACKAGE_ID" like '%P02%'

delete all such objects

delete from "_SYS_REPO"."ACTIVE_OBJECT" where "PACKAGE_ID" like '%P02%'

Regards,

Vivek

[Former Member · Accepted solution]

Many Thanks Vivek for your prompt response.

Really your posts helped me a lot.

Now i'm able to delete my workbench development packages and also i tried few sql's to delete the inactive one as well.

Following are the steps i followed to delete the complete package:

Firstly you should make sure to delete all the inactive objects in your <package-name> from workbench.

Step 1:

delete from "_SYS_REPO"."INACTIVE_OBJECT" where PACKAGE_ID like '<packagename>%';

Step 2:

delete from "_SYS_REPO"."ACTIVE_OBJECT" where PACKAGE_ID like '<packagename>%';

t