Hi andreslopez
Counters are special records that are used to track unique section IDs (section_id).
Each section in Dédalo has a counter record in the counters table: 'matrix_counter' for local counters and 'matrix_counter_dd' for shared counters.
This issue occurs when you have a unsync situation between Hierarchies and counters.
This may be because you created a hierarchy and then deleted it.
Actions to be taken in these cases:
1 - If you encounter this error while navigating, make sure that all affected hierarchies have been deactivated if you are not using them. For example, 'af0' is for the 'Islamic Republic of Afghanistan' toponymy hierarchy (TLD af).
2- If you encounter this error in the maintenance panel (it seems to be your case):
This is because the origin of the counter cannot be determined, as the TLD no longer exists.
You can access the matrix_counter table using a PostgreSQL editor (Admin Neo, for example) and safely delete the record for that counter (if it is needed in the future, it will be regenerated).
(Ensure that you only delete unused counters)
DELETE FROM "matrix_counter" WHERE "tipo" = 'af0';
We will take this into account in future releases, to allow to do it from the maintenance panel directly.
I hope this helps you.
Best
