Error while deleting the package

[former_member182277]

Hello folks,

When I deleting the package, sometime I am getting the following error. Package is empty no views are created and the create are deleted.

Please find the error screenshot attached.

Thanks in advance.

Regards,Neha

[hai_murali_here · Accepted solution]

Hi Neha,

This could be a temporary issue.Restart the Modeler and then check the same.

And also go to _SYS_REPO.OBJECT_HISTORY table and check whether you have any views belongs to the package you are trying to delete.

Rgds,Murali

[former_member182277 · Accepted solution]

Hello Murli,

Thank you..

I delete the entries in the Object)history but the problem is same.

But i have delete the entries from other table like package_catalog and inactive_object.

After that package is deleted.

Regards,Neha

[former_member182277 · Accepted solution]

could you please provide the SQL Syntax to delete the particular entry instead of deleting all the entries.

Regards,Neha

[hai_murali_here · Accepted solution]

I am little confused here.

Are you looking for this

Delete from "_SYS_REPO"."INACTIVE_OBJECT" where PACKAGE_ID='<Name of the Package>'

Rgds,Murali

[Former Member]

You will have to delete the package from all related tables in _SYS_REPO since you would have given grant permissions to this user.

You will have to try these commands before you delete the package in Modeler.

delete from "_SYS_REPO"."INACTIVE_OBJECT" where PACKAGE_ID='package_name'

delete from "_SYS_REPO"."PACKAGE_CATALOG" where PACKAGE_ID='package_name'

delete from "_SYS_REPO"."ACTIVE_OBJECT" where PACKAGE_ID='package_name'

delete from "_SYS_REPO"."ACTIVE_OBJECTCROSSREF" where FROM_PACKAGE_ID='package_name'

delete from "_SYS_REPO"."ACTIVE_OBJECT_TEXT" where PACKAGE_ID='package_name'

delete from "_SYS_REPO"."ACTIVE_OBJECT_TEXT_CONTENT" where PACKAGE_ID='package_name'

delete from "_SYS_REPO"."CHANGE_ENTRIES" where PACKAGE_ID='package_name'

[lbreddemann]

Hi there!

I highly recommend not to change data manually in the repository tables.

Little mistakes and glitches in the SQL commands may lead to really unpleasant loss of modelling data.

Instead, please do have a support message open for this.

If there is the possibility (and apparently there is) that the repository becomes inconsistent and needs clean up - then development should come up with a proper fool-proof way to do that.

cheers, Lars