Hi all!
We have an installation with Dspace 1.5.1, postgresql 7.4.13
When we invoke the following scripts
[bin]# ./stat-initial
[bin]# ./stat-monthly
We have the same result
Exception in thread "main" org.postgresql.util.PSQLException: ERROR: invalid
input syntax for type timestamp: "2007"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorI
mpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.ja
va:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2St
atement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statem
ent.java:258)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP
reparedStatement.java:93)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP
reparedStatement.java:93)
at
org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:222)
at
org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java:30
3)
at
org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1270)
at
org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1299)
at
org.dspace.app.statistics.LogAnalyser.processLogs(LogAnalyser.java:541)
at
org.dspace.app.statistics.CreateStatReport.statMonthly(CreateStatReport.java
:214)
at
org.dspace.app.statistics.CreateStatReport.main(CreateStatReport.java:154)
I have seen similar problem on this thread
http://dspace.2283337.n4.nabble.com/Statistics-error-stat-monthly-td3283250.
html
http://www.mail-archive.com/[email protected]/msg06143.html
but I havent see the solution. Any ideas?
On our installation have the same result
dspace=# SELECT COUNT(*) AS num FROM item WHERE in_archive =
dspace-# true AND withdrawn = false AND item_id IN ( SELECT item_id FROM
dspace(# metadatavalue WHERE metadata_field_id = ( SELECT metadata_field_id
dspace(# FROM metadatafieldregistry WHERE element = 'date' AND qualifier =
dspace(# 'accessioned') AND text_value::timestamp > '2008-12-01'::timestamp
dspace(# AND text_value::timestamp < '2008-12-31'::timestamp );
ERROR: invalid input syntax for type timestamp: "2007"
This query , shows part of these results
SELECT * FROM item WHERE in_archive = true AND withdrawn =
false AND item_id IN (SELECT item_id FROM metadatavalue WHERE
metadata_field_id = (SELECT metadata_field_id FROM metadatafieldregistry
WHERE element = 'date' AND qualifier = 'accessioned'));
item_id | submitter_id | in_archive | withdrawn | last_modified
| owning_collection
---------+--------------+------------+-----------+--------------------------
--+-------------------
826 | 1 | t | f | 2009-02-16
12:11:05.694+01 | 309
16946 | 482 | t | f | 2011-04-11
19:10:07.243+02 | 1357
2928 | 154 | t | f | 2009-03-06
02:46:29.089+01 | 683
2662 | 24 | t | f | 2008-12-15
08:59:14.395+01 | 473
2594 | 24 | t | f | 2008-12-15 09:08:10.66+01
| 473
.
Thanks in advance
cid:f0154016-8e66-4c6b-9255-4e7524133341
Evelio Martínez
Director proyectos software.
CISA, CCNA
Dept. de Tecnologías y Sistemas de Información
C/ Garcilaso, 15-bajo
46003 Valencia
Telf: 96 369 41 23 / 677 405 909
Fax: 96 369 34 39
www.masmedios.com
cid:f0154016-8e66-4c6b-9255-4e7524133341
cid:65691c43-2689-4f20-9b5d-5425927026a4
Este correo electrónico y, en su caso, cualquier fichero anexo al mismo,
puede contener información de carácter confidencial exclusivamente dirigida
a su(s) destinatario(s). De acuerdo con la LOPD, MASmedios informa de que
los datos personales contenidos quedarán sometidos a un tratamiento del que
aquélla es responsable. Los interesados consienten el tratamiento de sus
datos para estos fines, pudiendo ejercitar sus derechos de acceso,
rectificación, cancelación y oposición dirigiéndose por escrito a MASmedios
para la gestión de la información, calle Garcilaso 15-B 46003 Valencia o en
<mailto:[email protected]> [email protected]
<<image001.png>>
<<image002.gif>>
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA Learn about the latest advances in developing for the BlackBerry® mobile platform with sessions, labs & more. See new tools and technologies. Register for BlackBerry® DevCon today! http://p.sf.net/sfu/rim-devcon-copy1
_______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
