Dataset not associated to any agent

11515
Reporter: fmendez
Assignee: jcuadra
Type: SubTask
Summary: Dataset not associated to any agent
Priority: Critical
Resolution: Fixed
Status: Closed
Created: 2012-06-28 13:40:33.427
Updated: 2013-01-15 14:37:45.29
Resolved: 2012-06-28 15:20:42.769
        
Description: Several dataset are not associated to any organization, installation or node. Those can be retrieved using the query:
select ds.id as dsid, s.id sid,s.url,s.service_type_id as stype
from agent ds
join agent_relation ar on ar.to_agent_id = ds.id and ar.deleted is not null
join service s on s.agent_id = ds.id and s.deleted is null
where ds.type = 14020 and
ds.id not in (select ar2.to_agent_id from agent_relation ar2 where ar2.deleted is null)
and ds.deleted is null
order by s.id

All of them share the url 'http://data.nbn.org.uk/export/gbif/...']]>
    

Author: jcuadra@gbif.org
Comment: fixed now. 
Created: 2012-06-28 15:07:12.605
Updated: 2012-06-28 15:07:12.605