'Group has overlaps' error adding section to group


	Applies To

	Product(s):	Exor Network Manager
	Version(s):	N/A
	Environment:	N/A
	Area:	Groups of Sections
	Subarea:
	Original Author:	Kristijonas Nalivaika, Bentley Technical Support Group

Problem Description

When trying to add section to group of sections in Group of Sections (NM0110) form an error message appears: “Group has overlaps.”.

Reason

Possibly the same section has been added to the same group twice (probably with different start dates but none of them end-dated) or you are trying to add a section that is already there.

Steps to Resolve

Look for repeating section uniques in the Group of Sections form for that particular group. You can also run the following SQL query as the Highways owner user and it should tell you which section(s) it thinks are in the group more than once:

select nm_ne_id_of, n2.ne_unique, count(*) from nm_members_all, nm_elements_all n1, nm_elements_all n2 where n2.ne_id = nm_ne_id_of and nm_ne_id_in = n1.ne_id and n1.ne_unique = 'YOUR_GROUP_OF_SECTIONS_UNIQUE' group by nm_ne_id_of, n2.ne_unique having count(*) > 1;

If this query shows two of the same sections added to the route - remove or end-date one of them and you should be allowed to add a new section.