Skip to Content

How to delete PACKAGE from HANA studio

1.Unable to delete package from HANA studio

/wp-content/uploads/2013/05/p1_212444.png

2. While deleting from HANA studio it will showing inactive object present in package and refusing to delete the package.

     You can find out inactive object using below sql queries


/wp-content/uploads/2013/05/p2_212446.png

SELECT * FROM _SYS_REPO.INACTIVE_OBJECT WHERE PACKAGE_ID=’test’

3. Once you have found the inactive object using above query

    You can delete it using below query

/wp-content/uploads/2013/05/p3_212447.png

Delete FROM _SYS_REPO.INACTIVE_OBJECT WHERE PACKAGE_ID=’test’

4. Once you have deleted inactive object you can delete the package from HANA studio.

/wp-content/uploads/2013/05/p4_212448.png

Best Regards,

Atul

To report this post you need to login first.

13 Comments

You must be Logged on to comment or reply to a post.

  1. Shreepad Patil

    Hi Atul,

    Nice Document..

    I have a set of question though

    What happens to the data in the related tables like other INACTIVE_* tables, wouldn’t it get inconsistent once the data in INACTIVE_OBJECT is deleted?

    How should one handle this?

    Shreepad

    (0) 
  2. Reza Ahoui

    Thanks for the post,

    May I know which user you use to execute the sql statements? Do you know what rights are required prior the run?

    (0) 
  3. Lars Breddemann

    Hi Atul

    This way with fiddling with the contents of the repository tables is neither supported nor recommended and will leave the repository in an inconsistent state.

    What about all the already activated objects? What about the text data and the cross references?

    So please don’t recommend this technique as it could easily lead to a completely unusable repository.

    – Lars

    (0) 
    1. Shreepad Patil

      Hi Lars,

      Is there any standard way to delete the packages which have inactive objects. It is required sometimes of the administrator to delete a package which is no longer used. But due to this error one cannot delete the package.

      Shreepad

      (0) 
    2. atul jain Post author

      Hi Lars,

      Yes You are right here ,it is not recommended way of doing but it is a one work around .

      Best Regards,

      Atul

      (0) 
      1. Lars Breddemann

        Hi all

        the mentioned SAP knowledge base article does describe a workaround and some additional checks that need to be performed before anything gets deleted.

        Unfortunately it doesn’t warn properly of the possible damage that could be done to the repository.

        In any case: if you face such an inconsistency of the repository, please do open a support incident with SAP. This is not as the system should behave and therefore to be considered a bug.

        – Lars

        (0) 
  4. Florian Wittmann

    I fully agree with Lars, but we had the same issue and no other chance to delete certain inactive objects, not even the owner of these objects was able to see/delete them. A better solution would be highly appreciated.

    Thanks

    Florian

    (0) 
  5. Prasad Patil

    Please own the inactive objects from others using change Switch Ownership option  to your name and then you can able see those object under above mentioned test package. Then you can delete the inactive objects.

    Regards,

    Prasad

    (0) 

Leave a Reply