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

[Former Member]

For me, deleting of HANA XS Dev Content is still not possible in a "correct" manner.

So although in the HANA web IDE Editor it is very annoying to delete every single file, and after that delete the whole package.

Also the advice of Thomas Jung is not working for me, and the SAP Note 1832961 is not working if your project was previously connected to different repositorys.

I wrote this script, use it carefull and on your own risk, it is manipulating system tables!

After you have to delete all table entries under schema public and _SYS_BIC delete the remaining objects like table types procedures, _SYS_BIC runtime objects,....

delete  from "_SYS_REPO"."ACTIVE_CONTENT_TEXT" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."ACTIVE_CONTENT_TEXT_CONTENT" where "PACKAGE_ID" like '%<package_name>%';

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

delete from "_SYS_REPO"."ACTIVE_OBJECTCROSSREF" where "FROM_PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."ACTIVE_OBJECT_TEXT" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."ACTIVE_OBJECT_TEXT_CONTENT" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."ACTIVE_TAGS" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."CHANGE_ENTRIES" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."CONTENT_TEXT_HISTORY" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."INACTIVE_CONTENT_TEXT" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."INACTIVE_CONTENT_TEXT_CONTENT" where "PACKAGE_ID" like '%<package_name>%';

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

delete from "_SYS_REPO"."INACTIVE_OBJECTCROSSREF" where "FROM_PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."INACTIVE_OBJECT_TEXT" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."INACTIVE_OBJECT_TEXT_CONTENT" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."OBJECT_HISTORY" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."OBJECT_TEXT_HISTORY" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."PACKAGE_CATALOG" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."PACKAGE_TEXT" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."PACKAGE_TEXT_CONTENT" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."RUNTIME_OBJECTS" where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."HISTORICAL_OBJECTCROSSREF"where "FROM_PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."ACTIVATION_HELPER"where "PACKAGE_ID" like '%<package_name>%';

delete  from "_SYS_REPO"."ACTIVATION_HELPER2"where "PACKAGE_ID" like '%<package_name>%';

select * from OBJECTS where OBJECT_NAME like '%<package_name>%';

select * from OBJECT_DEPENDENCIES  where BASE_OBJECT_NAME like '%<package_name>%';

select * from OBJECT_DEPENDENCIES  where DEPENDENT_OBJECT_NAME like '%<package_name>%';

select * from PROCEDURES where PROCEDURE_NAME like '%<package_name>%';

select * from PROCEDURE_PARAMETERS where PROCEDURE_NAME like '%<package_name>%';

select * from TABLES where TABLE_NAME like '%<package_name>%' or TABLE_NAME like '%training%';

select * from VIEWS where VIEW_NAME like '%<package_name>%';

select * from SYNONYMS where SYNONYM_NAME like '%<package_name>%';

[Former Member]

it is possible  with the HANA editor or IDE

e.g.

http://[hana system]:80[instance number]/sap/hana/xs/ide/

see:

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

Had this problem too, but now it works.

[Former Member]

Hi David,

Did this solution work for you?

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

For me its working fine.

Hope you are fine.

Best regards.

Fahad