On Mon, Jun 18, 2012 at 1:29 PM, Domingo Iglesias <[email protected]> wrote: > 2012-06-18 10:45:39,775 DEBUG org.dspace.storage.rdbms.DatabaseManager > @ Running query "SELECT DISTINCT handle.handle, handle.resource_id, > item.withdrawn, item.last_modified FROM handle, item, collection2item > WHERE handle.resource_type_id=2 AND handle.resource_id=item.item_id > AND collection2item.collection_id= ? AND > collection2item.item_id=handle.resource_id AND item.last_modified >= > ? AND item.last_modified <= ? ORDER BY handle.resource_id" with > parameters: 341,0001-01-01 01:00:00.0,10000-01-01 00:59:59.999
Oracle doesn't like this date (I don't know the reason why), which is probably constructed by DSpace in case there's no date range given in the OAI-PMH query. The start and end date must be given as parameters to the harvest() function, because if they were null, the query wouldn't contain the clauses with item.last_modified. > 2012-06-18 10:45:39,777 WARN org.dspace.app.oai.DSpaceOAICatalog @ > anonymous::database_error: > java.sql.SQLException: Year out of range. The query is constructed here: > at org.dspace.search.Harvest.harvest(Harvest.java:195) I tried to look where the dates come from and they're logged here in > at > org.dspace.app.oai.DSpaceOAICatalog.listRecords(DSpaceOAICatalog.java:445) > 2012-06-18 10:45:38,976 INFO org.dspace.app.oai.DSpaceOAICatalog @ > anonymous:no_context:oai_request:verb=listRecords,from=0001-01-01T00\colon;00\colon;00Z,until=9999-12- > 31T23\colon;59\colon;59Z,set=hdl_123456789_3521,metadataPrefix=oai_dc so they must come from the OAI server from OCLC: > at ORG.oclc.oai.server.verb.ListRecords.construct(ListRecords.java:180) Seems like you have found a bug in DSpace. Could you file a Jira issue at <https://jira.duraspace.org/browse/>? That way you'll be informed of its status. This is just a guess, but could you test for me if upgrading the OAICat module to the latest version solves this problem? 1) Download the latest OAICat from here: <http://code.google.com/p/oaicat/downloads/list> 2) Change the version of oaicat in the main dspace pom.xml from 1.5.48 to 1.5.59: <dependency> <groupId>org.dspace</groupId> <artifactId>oaicat</artifactId> <version>1.5.48</version> </dependency> 3) mvn install:install-file -DgroupId=org.dspace -DartifactId=oaicat -Dversion=1.5.59 -Dpackaging=jar -Dfile=oaicat-1.5.59.jar Regards, ~~helix84 ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
