PersistenceException: ExtendedPropertyMapper.selectByAgentKey returned more than one row

11802
Reporter: mdoering
Assignee: jcuadra
Type: Bug
Summary: PersistenceException:  ExtendedPropertyMapper.selectByAgentKey returned more than one row
Priority: Critical
Resolution: Fixed
Status: Closed
Created: 2012-08-31 12:29:12.237
Updated: 2013-12-16 17:50:27.92
Resolved: 2012-11-07 14:47:32.499
        
Description: http://jawa.gbif.org:8080/registry-ws/dataset/72453ca0-328a-11df-855a-b8a03c50a862

PersistenceException:
### Error querying database.  Cause: org.apache.ibatis.executor.ExecutorException: Statement org.gbif.registry.mybatis.mapper.ExtendedPropertyMapper.selectByAgentKey returned more than one row]]>
    

Author: jcuadra@gbif.org
Created: 2012-11-07 14:47:32.525
Updated: 2012-11-07 14:47:32.525
        
This was caused by bad data from the DB. An agent and an extended_property should have a 1:1 relationship (confirmed by Fede). The metadata sync is not creating multiple extended_properties for each agent.

Suggestion is to keep jawa's registry DB up to date with the live registry.