Hello again, I am asking once more in case someone missed my last email. It will be really helpful if anyone can point me to the right direction.
I did the following since my last email. I edited dstat.cfg and changed start.year to 2001 and start.month to 11. I then cleared /[dspace]/reports and executed /dspace stat-initial/. Still the same problem. Many thanks, Evelthon On 11/19/2011 11:58 PM, Evelthon Prodromou wrote: > Hello everyone, > > I am facing an issue with dspace 17.0 and monthly reports. We are moving > collections from greenstone to dspace. The monthly reports worked fine > up to 02/2011. Seems like whenever a stat-* command is run it returns > the error below. > ----- > Exception: ERROR: more than one row returned by a subquery used as an > expression > org.postgresql.util.PSQLException: ERROR: more than one row returned by > a subquery used as an expression > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at > org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:284) > at > org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java:330) > at > org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1249) > at > org.dspace.app.statistics.LogAnalyser.processLogs(LogAnalyser.java:498) > at > org.dspace.app.statistics.CreateStatReport.statInitial(CreateStatReport.java:259) > at > org.dspace.app.statistics.CreateStatReport.main(CreateStatReport.java:129) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183) > > ----- > Since we have not yet gone public on dspace, it is of no problem to > just clear everything out and start our monthly reports from scratch. > Any pointers on how can that be accomplished? > > Thanks > > > > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure > contains a definitive record of customers, application performance, > security threats, fraudulent activity, and more. Splunk takes this > data and makes sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-novd2d > > > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech
<<attachment: prodromou_evelthon.vcf>>
------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d
_______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech