Issue 11489

Registry DB contains wrong relations: organization PUBLISHES dataset

11489
Reporter: fmendez
Assignee: fmendez
Type: Bug
Summary: Registry DB contains wrong relations: organization PUBLISHES dataset
Priority: Minor
Resolution: Fixed
Status: Closed
Created: 2012-06-26 11:45:05.243
Updated: 2013-12-16 17:50:56.745
Resolved: 2013-07-30 09:33:04.175
        
Description: This relations can be retrieve using the query:

SELECT ar.* FROM agent_relation ar
JOIN agent fromAgent ON ar.from_agent_id = fromAgent.id AND fromAgent.type != 14100
JOIN agent toAgent ON ar.to_agent_id = toAgent.id
WHERE ar.deleted IS NULL AND ar.relation_type_id = 15020

Only technical installations sould be "publishing" datasets]]>
    


Author: fmendez@gbif.org
Comment: This is caused by data "error" in live registry, there's a relation: Flanders Marine Institute PUBLISHES World Register of Marine Species. A "publishes" relation shouldn't exist between a organization and a dataset.
Created: 2012-07-10 16:12:02.627
Updated: 2012-07-10 16:12:02.627


Author: fmendez@gbif.org
Comment: this issue was fixed a long time ago
Created: 2013-07-30 09:33:04.215
Updated: 2013-07-30 09:33:04.215