Error deleting Hierarchy leaf nodes

[Former Member]

Hi SDNers,

I have hierarchy table whose values I want to delete.

If I check in the Main table, none of the records are assigned the hierarchy values. But if I try to delete it, i am getting the error "one or more values are set to records in another table" !!

If I select all the records in the main table, and try to modify the heirarchy field value.. the error is "Records cannot be modified because their data is out of date"

I have tried unloading n loading again with update indices.. but same error!!

Note: In the hierarchy table one of the leaf node i want to delete is greyed out!!

Thanks,

Priti

[former_member208981]

Thanks all.. not sure what the problem was.

[Former Member]

Hi Priti

Please also check if you are using the Hierachy node/values in any of the Local searches/Named Searches or Masks.

If yes it has to be deleted from these tables before actually deleting the hierarchy record.

Thanks-Ravi

[former_member208981]

Hi Ravi,

Thanks for the reply.

There are no masks, local searches, namesd search in the repositroy.

Thanks,

Priti

[Former Member]

Hi Priti,

If I check in the Main table, none of the records are assigned the hierarchy values. But if I try to delete it, i am getting the error "one or more values are set to records in another table" !!

I faced the similar kind of error, on carefully evaluating the repository in our case i found that this hierarchy values are assigned to a field in Qualified table. So i would suggest you to please check all the other sub-tables (flat tables, Qualified tables etc) where may be a field in any of this sub-table is look-up to this hierarchy table.

Regards,

Mandeep Saini

[Former Member]

Hi Priti

Please check for other sub tables if the hierarchy value is used. Check for the Qualified and tuples as well using free form searches.

Its painful.. but no other way.

Otherwise delete the field itself and recreate.

thanks-Ravi

[former_member208981]

Hi Mandeep / Ravi,

Thanks for the replies.

The hierarchy field is not at all assigned to any other field.

Deleting the field itself and recreating is not an option, as it will affect the UI's.

Thanks,

Priti

[Former Member]

Are you logging onto MDM with a login that is constrained?

Do you have alias's created in the hierarchy?

If you add a new leaf node, can it be deleted?

What does Verify -> Check say about the repository?

Anything interesting in the server's log file?

[Former Member]

Hi Prithi,

Just check whether that hierarchy record in protected mode or not.

For this just go to hierarchy table in Record mode

right click on that record

select protection and sleect unprotect .

This may be one of the reason.

Please check at yr end and revert back with yr results.

Thanks,

Sudhanshu

[former_member208981]

Hi Sudhanshu,

Thanks for the reply.

I have checked it:

The records are not protected, not checked out, not part of workflow, not locked.

Any more suggestions..

Thanks,

Priti