geoname hierarchy, parent must exist

number of errors=1
number of warnings=0
Group=chkGrpHierarchy

select parentid,childid,creationtime,createdbyuserid,type from geoname_hierarchy where not exists (select 1 from geoname where geonameid=parentid)

parentid	childid	creationtime	createdbyuserid	type	
2862215	2844654	2014-06-09 17:16:49.330379	null	null