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

Reply via email to