Hi Zaya,
It might be easier to track this problem down with debug-level logging. To do
this, edit your [dspace]/config/log4j.properties and change
log4j.rootCategory=INFO, A1 to log4j.rootCategory=DEBUG, A1. Then restart
Dspace. Now you’ll be able to see all the SQL queries in your log, which should
shed some more light on why the one being used by stat-initial is upsetting
PostgreSQL.
Cheers,
Kim
From: Zaya Kh [mailto:[email protected]]
Sent: Wednesday, 4 February 2009 1:23 a.m.
To: dspace-tech
Subject: [Dspace-tech] Statistics error?
Hello again,
I have a question? When I start DSpace's statistics this error show me.
[r...@localhost bin]# ./stat-initial
Exception in thread "main" org.postgresql.util.PSQLException: ERROR: syntax
error at or near "FROM"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:209)
at
org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java: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:162)
[r...@localhost bin]#
Can you advice me?
Best regard, Zoloo
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
