Uploaded image for project: 'DSpace'
  1. DSpace
  2. DS-1795

When run command dspace "dspace stat-initial"

    XMLWordPrintable

    Details

    • Attachments:
      0
    • Comments:
      9
    • Documentation Status:
      Not Required

      Description

      After install dspace 4.0RC
      Run command dspace stat-initial from /dspace/bin
      dspace show:
      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

      ----------------------------------------------------------
      This is log file with DEBUG

      2013-11-17 09:44:21,831 DEBUG net.sf.ehcache.config.ConfigurationHelper @ No CacheManagerEventListenerFactory class specified. Skipping...
      2013-11-17 09:44:21,862 DEBUG net.sf.ehcache.config.ConfigurationHelper @ No BootstrapCacheLoaderFactory class specified. Skipping...
      2013-11-17 09:44:21,862 DEBUG net.sf.ehcache.config.ConfigurationHelper @ No CacheExceptionHandlerFactory class specified. Skipping...
      2013-11-17 09:44:22,487 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "SELECT COUNT AS num FROM item WHERE in_archive = true AND withdrawn = false AND item_id IN ( SELECT item_id FROM metadatavalue WHERE metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry WHERE element = 'date' AND qualifier = 'accessioned') AND text_value LIKE '___T::_Z' AND text_value::timestamp > '2005-01-01'::timestamp AND text_value::timestamp < '2005-01-31'::timestamp ) " with parameters:
      2013-11-17 09:44:22,519 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "SELECT COUNT AS num FROM item WHERE in_archive = true AND withdrawn = false AND item_id IN ( SELECT item_id FROM metadatavalue WHERE metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry WHERE element = 'date' AND qualifier = 'accessioned') AND text_value LIKE '___T::_Z' AND text_value::timestamp > '2005-01-01'::timestamp AND text_value::timestamp < '2005-01-31'::timestamp ) AND item_id IN ( SELECT item_id FROM metadatavalue WHERE text_value LIKE '%Thesis or Dissertation%' AND metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry WHERE element = 'type' AND qualifier IS NULL) ) " with parameters:

      Reporter: Nguyen Hung Thanh
      E-mail: nghungthanh@gmail.com

        Attachments

          Activity

            People

            • Assignee:
              mwood Mark H. Wood
              Reporter:
              no-reply Anonymous (No Reply)
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: