Hi all
Can anyone point me in the right direction to get the statistics
(stat-initial etc) working in 1.5.
When I run stat-initial, I get:
Exception in thread "main" org.postgresql.util.PSQLException: ERROR:
syntax error at or near "FROM"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
torImpl.java:1512)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1297)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:430)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:346)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St
atement.java:250)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:92)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:92)
at
org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:209)
at
org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.jav
a:279)
at
org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1273)
at
org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1302)
at
org.dspace.app.statistics.LogAnalyser.processLogs(LogAnalyser.java:543)
at
org.dspace.app.statistics.CreateStatReport.statInitial(CreateStatReport.
java:291)
at
org.dspace.app.statistics.CreateStatReport.main(CreateStatReport.java:16
2)
Don't really know where to start with this one.
In fact, I don't really know where to start with the stats reports in
general - I find the wording of the documentation ambiguous and
confusing.
Are stat-initial and stat-report-initial scripts that you would only run
once in the beginning and then do nightly runs of the other four
scripts?
The system seems to have changed since 1.4 eg:
1.4 dstat.cfg - contains dspace.log parameter
1.5 dstat.cft - contains host.name, host.url, start.year, start.month
parameters
There are other anomalies, for example the stat-initial script in 1.5
states:
"This script starts from the year and month specified below.."
But I don't see any year or month specified??
Etc etc, I'll stop whinging now. I'm doing a server migration and a
1.4->1.5 upgrade at the same time and it has been quite a painful
process. It would be great if someone could provide a straightforward
explanation of how to initialise the stats and then keep them running
daily? Or any ideas regarding the above exception.
Thanks a million
Gary
Gary Browne
Development Programmer
Library IT Services
University of Sydney
ph: 9351-5946
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
