Hi,
When running the cron script stat-monthly on dspace 1.8.2, I get an error:
Exception: ORA-01861: literal does not match format string
When going to debug mode, this is the SQL script that fails to run:
SELECT COUNT(*) AS num FROM item WHERE in_archive = 1 AND withdrawn = 0 AND
item_id IN ( SELECT /*+ ORDERED_PREDICATES */ item_id FROM metadatavalue WHERE
metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry
WHERE element = 'date' AND qualifier = 'accessioned') AND TO_TIMESTAMP(
TO_CHAR(text_value), 'yyyy-mm-dd"T"hh24:mi:ss"Z"' ) > TO_DATE('2012-09-01',
'yyyy-MM-dd') AND TO_TIMESTAMP( TO_CHAR(text_value),
'yyyy-mm-dd"T"hh24:mi:ss"Z"' ) < TO_DATE('2012-09-30', 'yyyy-MM-dd') )
I was kindly told that the query itself is constructed in
dspace-api/src/main/java/org/dspace/app/statistics/LogAnalyser.java starting
from line 1238 and the error surely pertains to conversion of date to string.
However, I don't know why it is failing to run.
Can anyone help?
Thanks
Ian
------------
Ian Wellaway
Senior System Support & Development Officer - Enterprise Applications
(Wednesdays only)
&
Technical Developer, Open Exeter - Infrastructure Systems (Monday-Tuesday,
Thursday-Friday)
Exeter IT
Room 54
Laver Building
University of Exeter
EX4 4QE
UK
tel +44 1392 722852
------------------------------------------------------------------------------
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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
