Greetings! I would like to ask two questions: I`m trying to run stat-initial, but i get the following error:
Exception in thread "main" 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:93) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:291) at org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java:372) at org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1280) at org.dspace.app.statistics.LogAnalyser.processLogs(LogAnalyser.java:540) at org.dspace.app.statistics.CreateStatReport.statInitial(CreateStatReport.java:289) at org.dspace.app.statistics.CreateStatReport.main(CreateStatReport.java:160) The other question would be regarding subscriptins. I tried some tests, added a couple of items to a collection, to which I`m subscribed and run the sub-daily... I received the email with one day delay. Now I tried to repeat the test, waited two days before running sub-daily, but now I did not get any email. I wanted to test if the cronjobs are working or not... But now I can`t decide if the cronjob or the command is not working. Could someone please provide some info on the subscriptions? How does it work and how could I test is successfully if there are working or not? Thank you very much for your time! Best regards, Bodnár Róbert Librarian-Dspace administrator "Lucian Blaga" Central University Library http://dspace.bcucluj.ro ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech