Re3gistry 2.5.0: How to remove entry

[TeijoKal]

I have re3gistry 2.5.0 in use. But the problem is that there is two entries in data that are not working. Restapi is not showing the data of that entries and webapp application does not show the data of those entries.

If i will remove those entries from database which tables i should update ??

[TeijoKal]

My situation is as follows:

And if i choose the first item 'Alueluokitusjärjestelmä' the result is the following

So it stucks here. All the other entries are working properly.

[unaibrrgn]

Dear @TeijoKal,

these are the sentences that delete a single entry. Execute the three sentences for each item you want to delete. Fill the gaps with the items UUID.

1. First sentence: DELETE FROM public.reg_localization where reg_item =' ';
2. Second sentence: DELETE FROM public.reg_relation where reg_item_subject =' ';
3. Third sentence: DELETE FROM public.reg_item where uuid =' ';

Regards, Unai.

[TeijoKal]

Ok. Now i removed the entries from tables reg_localization, reg_relation and reg_item. Also needed to remove entries in other related tables. But now the problem is that i want to make a new entry to register using the same id. But i got only an error in the log:

The local id specified for the item is already available in the system.

[TeijoKal]

It worked after i remade SOLR indexing and Cache all. After that the removed id could be used again.