Bad data in CLB

15960
Reporter: trobertson
Type: Bug
Summary: Bad data in CLB
Priority: Critical
Resolution: Fixed
Status: Resolved
Created: 2014-06-17 17:59:44.264
Updated: 2014-06-17 18:58:16.953
Resolved: 2014-06-17 18:58:16.923
        
Description: Please fix data asap

WARN  [2014-06-17 17:55:05,870+0200] [http-bio-8080-exec-38] org.gbif.mybatis.type.UriTypeHandler: Invalid URI http://wp6-cichorieae.e-taxonomy.eu/portal/?q=cdm_dataportal/taxon/{ID}
java.net.URISyntaxException: Illegal character in query at index 67: http://wp6-cichorieae.e-taxonomy.eu/portal/?q=cdm_dataportal/taxon/{ID}
	at java.net.URI$Parser.fail(URI.java:2829) ~[na:1.7.0_51]
	at java.net.URI$Parser.checkChars(URI.java:3002) ~[na:1.7.0_51]
	at java.net.URI$Parser.parseHierarchical(URI.java:3092) ~[na:1.7.0_51]
	at java.net.URI$Parser.parse(URI.java:3034) ~[na:1.7.0_51]
	at java.net.URI.(URI.java:595) ~[na:1.7.0_51]
	at org.gbif.mybatis.type.UriTypeHandler.toURI(UriTypeHandler.java:43) [gbif-common-mybatis-0.10.jar:0.10]
	at org.gbif.mybatis.type.UriTypeHandler.getNullableResult(UriTypeHandler.java:28) [gbif-common-mybatis-0.10.jar:0.10]
	at org.gbif.mybatis.type.UriTypeHandler.getNullableResult(UriTypeHandler.java:18) [gbif-common-mybatis-0.10.jar:0.10]
	at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:51) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getPropertyMappingValue(DefaultResultSetHandler.java:392) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyPropertyMappings(DefaultResultSetHandler.java:366) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:336) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:289) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:264) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:234) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:152) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:57) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:115) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98) [mybatis-3.2.3.jar:3.2.3]
	at sun.reflect.GeneratedMethodAccessor714.invoke(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_51]
	at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_51]
	at org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invoke(SqlSessionManager.java:282) [mybatis-3.2.3.jar:3.2.3]
	at com.sun.proxy.$Proxy160.selectList(Unknown Source) [na:na]
	at org.apache.ibatis.session.SqlSessionManager.selectList(SqlSessionManager.java:171) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:114) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:58) [mybatis-3.2.3.jar:3.2.3]
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:43) [mybatis-3.2.3.jar:3.2.3]
	at com.sun.proxy.$Proxy556.listRelated(Unknown Source) [na:na]
	at org.gbif.checklistbank.service.mybatis.NameUsageServiceMyBatis.listRelated(NameUsageServiceMyBatis.java:182) [checklistbank-mybatis-service-2.7.jar:2.7]
]]>
    

Author: mdoering@gbif.org
Comment: URLs of this kind removed from excalibur prod_b_clb , but I doubt this indeed caused trouble. 
Created: 2014-06-17 18:58:12.185
Updated: 2014-06-17 18:58:12.185