Sorry, I can't think of a reason why dc.date.accessioned_dt would be missing from your Solr search core if you have dc.date.accessioned values in the metadata.
Dropping and restoring the DB will not help with this issue - it does not change DB contents. If the values are in the metadata, the problem must be either with the schema of the Solr search core (which you sent me and seems to be correct) or the way the records are loaded into the Solr search core. One last thing you can try is to 1) stop tomcat 2) manually delete the Solr seach core data [1] 3) start tomcat 4) run index-discovery -b [1] https://wiki.duraspace.org/display/DSPACE/Solr#Solr-ManuallydeleteSolrindexfiles Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette On Wed, Aug 15, 2018 at 3:44 PM euler <esne...@seafdec.org.ph> wrote: > > Hi helix, > > I've tried several times to reindex (index-discovery -b) but I still have > zero values when doing solr query for breakdown of submitted items per month. > I am very sure that I have the dc.date.accessioned metadata field in all of > my items. I'm wondering why I have the correct values when doing it in my > local instance. In my local instance, I restored the pgdump of our production > server and then reindex. Then I tested the solr query and it's working. I > also tried restoring (in my local instance) by using the command dspace > packager -r -a -f -t AIP and after it finished reindexing, the solr query > also worked. So my question now is, what should I do in our production server > to make the solr query work? I'm worried that restoring the entire site using > packager -r -a -f -t is a little bit extreme just to make this work? Or is it > safe to drop the dspace database and then restore it using the backup pgdump? > Will it mess up other data in my solr core? > > Thanks, > euler > > On Tuesday, August 14, 2018 at 7:43:05 PM UTC+8, helix84 wrote: >> >> It seems that you're using the schema from DSpace unmodified, the only >> change being the default query operator from OR to AND. This schema >> creates the *_dt indexes for you from date fields. If, for some >> reason, they are not created, try a full reindex. Otherwise the reason >> will be that you simply don't have the dc.date.accessioned metadata >> field filled in in any of your items. Those should be filled in >> automatically by DSpace if you're creating items via input forms, CSV >> import or other standard DSpace methods. They may be missing if you're >> using some custom import methods. >> >> Your solution is either to start filling out this field for new >> records or to facet by another date field that you're using >> (dc.date.issued). >> >> >> Regards, >> ~~helix84 >> >> Compulsory reading: DSpace Mailing List Etiquette >> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette >> >> >> >> On Tue, Aug 14, 2018 at 1:27 PM euler <esn...@seafdec.org.ph> wrote: >> > >> > Hi helix, >> > >> > Below is an example record from [1]. Attached is the schema.xml [2]. Thank >> > you so much for your time and attention to this. >> > >> > Best regards, >> > euler >> > >> > <doc> >> > <arr name="dc.contributor.editor_stored"> >> > <str> >> > Juario, Jesus V. ||| 25d39231-ff36-4279-a9d7-77c595acd0d9 ||| null ||| >> > 25d39231-ff36-4279-a9d7-77c595acd0d9 ||| >> > </str> >> > <str> >> > Ferraris, R. P. ||| cf922f2a-122b-4d83-b01a-79c6ab702d0a ||| null ||| >> > cf922f2a-122b-4d83-b01a-79c6ab702d0a ||| >> > </str> >> > <str> >> > Benitez, L. V. ||| f3e5c684-9c35-443b-8864-be239a5944fe ||| null ||| >> > f3e5c684-9c35-443b-8864-be239a5944fe ||| >> > </str> >> > </arr> >> > <arr name="author"> >> > <str>Fortes, Romeo D.</str> >> > <str>97876fc9-2d1b-453c-9f75-a4e7965f8b34</str> >> > </arr> >> > <str name="dc.contributor.author_sort">Fortes, Romeo D.</str> >> > <arr name="dc.citation.spage"> >> > <str>107</str> >> > </arr> >> > <arr name="dc.subject_mlt"> >> > <str>Chanos chanos</str> >> > <str>Philippines</str> >> > </arr> >> > <arr name="dc.publisher.en"> >> > <str> >> > Published by Island Pub. House in association with the Aquaculture Dept., >> > Southeast Asian Fisheries Development Center and the International >> > Development Research Centre >> > </str> >> > </arr> >> > <date name="dc.date.issued_dt">1984-01-01T00:00:00Z</date> >> > <arr name="editor_keyword"> >> > <str>Juario, Jesus V.</str> >> > <str>25d39231-ff36-4279-a9d7-77c595acd0d9</str> >> > <str> >> > 25d39231-ff36-4279-a9d7-77c595acd0d9###25d39231-ff36-4279-a9d7-77c595acd0d9 >> > </str> >> > <str>Ferraris, R. P.</str> >> > <str>cf922f2a-122b-4d83-b01a-79c6ab702d0a</str> >> > <str> >> > cf922f2a-122b-4d83-b01a-79c6ab702d0a###cf922f2a-122b-4d83-b01a-79c6ab702d0a >> > </str> >> > <str>Benitez, L. V.</str> >> > <str>f3e5c684-9c35-443b-8864-be239a5944fe</str> >> > <str> >> > f3e5c684-9c35-443b-8864-be239a5944fe###f3e5c684-9c35-443b-8864-be239a5944fe >> > </str> >> > </arr> >> > <arr name="dc.language.iso"> >> > <str>en</str> >> > </arr> >> > <str name="handle">10862/170</str> >> > <str name="search.uniqueid">2-154</str> >> > <arr name="subject"> >> > <str>Chanos chanos</str> >> > <str>Chanos chanos</str> >> > <str>Philippines</str> >> > <str>Philippines</str> >> > <str>Aquaculture techniques</str> >> > <str>Aquaculture techniques</str> >> > <str>Brackishwater aquaculture</str> >> > <str>Brackishwater aquaculture</str> >> > <str>Fish culture</str> >> > <str>Fish culture</str> >> > <str>Pond culture</str> >> > <str>Pond culture</str> >> > </arr> >> > <arr name="subject_keyword"> >> > <str>Chanos chanos</str> >> > <str>Chanos chanos</str> >> > <str>Chanos chanos###39259</str> >> > <str>Chanos chanos</str> >> > <str>Philippines</str> >> > <str>Philippines</str> >> > <str>Philippines###5783</str> >> > <str>Philippines</str> >> > <str>Aquaculture techniques</str> >> > <str>Aquaculture techniques</str> >> > <str>Aquaculture techniques###Aquaculture techniques</str> >> > <str>Aquaculture techniques</str> >> > <str>Brackishwater aquaculture</str> >> > <str>Brackishwater aquaculture</str> >> > <str> >> > Brackishwater aquaculture###Brackishwater aquaculture >> > </str> >> > <str>Brackishwater aquaculture</str> >> > <str>Fish culture</str> >> > <str>Fish culture</str> >> > <str>Fish culture###Fish culture</str> >> > <str>Fish culture</str> >> > <str>Pond culture</str> >> > <str>Pond culture</str> >> > <str>Pond culture###Pond culture</str> >> > <str>Pond culture</str> >> > </arr> >> > <int name="search.resourceid">154</int> >> > <arr name="bi_2_dis_partial"> >> > <str>97876fc9-2d1b-453c-9f75-a4e7965f8b34</str> >> > <str>Fortes, Romeo D.</str> >> > </arr> >> > <arr name="dc.type.en"> >> > <str>Conference paper</str> >> > </arr> >> > <int name="search.resourcetype">2</int> >> > <arr name="editor_ac"> >> > <str>juario, jesus v. ||| Juario, Jesus V.</str> >> > <str> >> > 25d39231-ff36-4279-a9d7-77c595acd0d9 ||| >> > 25d39231-ff36-4279-a9d7-77c595acd0d9 >> > </str> >> > <str>ferraris, r. p. ||| Ferraris, R. P.</str> >> > <str> >> > cf922f2a-122b-4d83-b01a-79c6ab702d0a ||| >> > cf922f2a-122b-4d83-b01a-79c6ab702d0a >> > </str> >> > <str>benitez, l. v. ||| Benitez, L. V.</str> >> > <str> >> > f3e5c684-9c35-443b-8864-be239a5944fe ||| >> > f3e5c684-9c35-443b-8864-be239a5944fe >> > </str> >> > </arr> >> > <arr name="dc.date.available"> >> > <str>2011-06-08T09:47:49Z</str> >> > </arr> >> > <arr name="dc.subject"> >> > <str>Chanos chanos</str> >> > <str>Philippines</str> >> > </arr> >> > <arr name="type"> >> > <str>Conference paper</str> >> > </arr> >> > <arr name="dc.date.issued_stored"> >> > <str>1984-01-01 ||| null ||| null ||| null ||| </str> >> > </arr> >> > <arr name="location.coll"> >> > <str>14</str> >> > </arr> >> > <str name="dateIssued.year_sort">1984</str> >> > <arr name="title_keyword"> >> > <str> >> > Milkfish culture techniques generated and developed by the Brackishwater >> > Aquaculture Center >> > </str> >> > </arr> >> > <arr name="subject_acid"> >> > <str>chanos chanos ||| Chanos chanos###39259</str> >> > <str>philippines ||| Philippines###5783</str> >> > <str> >> > aquaculture techniques ||| Aquaculture techniques###Aquaculture techniques >> > </str> >> > <str> >> > brackishwater aquaculture ||| Brackishwater aquaculture###Brackishwater >> > aquaculture >> > </str> >> > <str>fish culture ||| Fish culture###Fish culture</str> >> > <str>pond culture ||| Pond culture###Pond culture</str> >> > </arr> >> > <arr name="bi_4_dis_filter"> >> > <str> >> > brackishwater aquaculture ||| Brackishwater aquaculture###Brackishwater >> > aquaculture >> > </str> >> > <str>philippines ||| Philippines###5783</str> >> > <str>chanos chanos ||| Chanos chanos###39259</str> >> > <str> >> > aquaculture techniques ||| Aquaculture techniques###Aquaculture techniques >> > </str> >> > <str>fish culture ||| Fish culture###Fish culture</str> >> > <str>pond culture ||| Pond culture###Pond culture</str> >> > </arr> >> > <arr name="bi_2_dis_authority_filter"> >> > <str>97876fc9-2d1b-453c-9f75-a4e7965f8b34</str> >> > </arr> >> > <arr name="dateIssued"> >> > <str>1984-01-01</str> >> > </arr> >> > <arr name="dc.title_hl"> >> > <str> >> > Milkfish culture techniques generated and developed by the Brackishwater >> > Aquaculture Center >> > </str> >> > </arr> >> > <date name="SolrIndexer.lastIndexed">2018-08-14T08:52:40Z</date> >> > <arr name="dc.citation.epage"> >> > <str>119</str> >> > </arr> >> > <arr name="editor_filter"> >> > <str> >> > 25d39231-ff36-4279-a9d7-77c595acd0d9 ||| >> > 25d39231-ff36-4279-a9d7-77c595acd0d9###25d39231-ff36-4279-a9d7-77c595acd0d9 >> > </str> >> > <str> >> > cf922f2a-122b-4d83-b01a-79c6ab702d0a ||| >> > cf922f2a-122b-4d83-b01a-79c6ab702d0a###cf922f2a-122b-4d83-b01a-79c6ab702d0a >> > </str> >> > <str> >> > f3e5c684-9c35-443b-8864-be239a5944fe ||| >> > f3e5c684-9c35-443b-8864-be239a5944fe###f3e5c684-9c35-443b-8864-be239a5944fe >> > </str> >> > </arr> >> > <arr name="location.comm"> >> > <str>8</str> >> > <str>4</str> >> > <str>1</str> >> > </arr> >> > <str name="bi_sort_2_sort">1984</str> >> > <arr name="dc.contributor.editor"> >> > <str>Juario, Jesus V.</str> >> > <str>Ferraris, R. P.</str> >> > <str>Benitez, L. V.</str> >> > </arr> >> > <arr name="dateIssued.year"> >> > <int>1984</int> >> > </arr> >> > <arr name="dc.title"> >> > <str> >> > Milkfish culture techniques generated and developed by the Brackishwater >> > Aquaculture Center >> > </str> >> > </arr> >> > <arr name="dc.contributor.author_stored"> >> > <str> >> > Fortes, Romeo D. ||| 97876fc9-2d1b-453c-9f75-a4e7965f8b34 ||| null ||| >> > 97876fc9-2d1b-453c-9f75-a4e7965f8b34 ||| >> > </str> >> > </arr> > > -- > All messages to this mailing list should adhere to the DuraSpace Code of > Conduct: https://duraspace.org/about/policies/code-of-conduct/ > --- > You received this message because you are subscribed to the Google Groups > "DSpace Technical Support" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to dspace-tech+unsubscr...@googlegroups.com. > To post to this group, send email to dspace-tech@googlegroups.com. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
