Hi helix, I followed your instruction to delete the Solr search core data which is located in [dspace]/solr/search/data after I stopped tomcat. After starting tomcat and issuing the index-discovery -b command, I waited a couple of minutes just to make sure that there were items already written in the index, I accessed http://localhost:8080/solr/search/select?indent=on&q=*:* to see if there are dc.date.accessioned_dt field in the result but sadly there were none. I'm getting really frustrated about this. Our server is running version 5.5 by the way. Right now the server is still reindexing but sadly no dc.date.accessioned_dt field.
Below is a record showing the available fields when I accessed http://localhost:8080/solr/search/select?indent=on&q=*.*. Note that there is a dc.date.accessioned field but no dc.date.accessioned_dt field. This XML file does not appear to have any style information associated with it. The document tree is shown below. <response> <lst name="responseHeader"> <int name="status">0</int> <int name="QTime">0</int> <lst name="params"> <str name="indent">true</str> <str name="q">*:*</str> <str name="rows">1</str> </lst> </lst> <result name="response" numFound="919" start="0"> <doc> <arr name="dc.title_mlt">...</arr> <arr name="author">...</arr> <arr name="author_keyword">...</arr> <arr name="dc.publisher">...</arr> <str name="dc.contributor.author_sort">Primavera, Jurgenne H.</str> <arr name="dc.citation.conferenceTitle">...</arr> <arr name="dc.publisher.en">...</arr> <date name="dc.date.issued_dt">2006-01-01T00:00:00Z</date> <arr name="dc.format.extent">...</arr> <str name="handle">10862/2944</str> <arr name="dc.language.iso">...</arr> <str name="search.uniqueid">2-3398</str> <arr name="dc.contributor.author">...</arr> <arr name="subject">...</arr> <arr name="subject_keyword">...</arr> <arr name="dc.subject.asfa.en">...</arr> <arr name="type_filter">...</arr> <int name="search.resourceid">3398</int> <arr name="subject_authority">...</arr> <arr name="bi_4_dis_partial">...</arr> <arr name="type_keyword">...</arr> <arr name="bi_2_dis_partial">...</arr> <arr name="bi_2_dis_filter">...</arr> <arr name="dc.subject.lcsh">...</arr> <str name="bi_sort_3_sort">2016-03-08T09:28:38Z</str> <str name="withdrawn">false</str> <arr name="subject_ac">...</arr> <arr name="dc.type.en">...</arr> <arr name="dateIssued_ac">...</arr> <arr name="dc.type">...</arr> <int name="search.resourcetype">2</int> <arr name="bi_4_dis_value_filter">...</arr> *<arr name="dc.date.accessioned">* *<str>2016-03-08T09:28:38Z</str>* *</arr>* <arr name="dc.date.available"> <str>2016-03-08T09:28:38Z</str> </arr> <arr name="author_filter">...</arr> <arr name="dc.identifier.citation">...</arr> <str name="bi_sort_1_sort">...</str> <arr name="read">...</arr> <arr name="dc.contributor.author_mlt">...</arr> <arr name="type">...</arr> <arr name="dc.description.en">...</arr> <arr name="dc.format.extent.en">...</arr> <arr name="dc.contributor.author_hl">...</arr> <arr name="dc.date.issued">...</arr> <arr name="dc.date.issued_stored">...</arr> <arr name="bi_4_dis_authority_filter">...</arr> <arr name="dc.title_stored">...</arr> <arr name="title_ac">...</arr> <arr name="author_authority">...</arr> <arr name="location.coll">...</arr> <arr name="dateIssued_keyword">...</arr> <arr name="subject_tax_0_filter">...</arr> <arr name="dc.title.en">...</arr> <arr name="author_ac">...</arr> <str name="dateIssued.year_sort">2006</str> <arr name="title_keyword">...</arr> <arr name="dc.language.iso.en">...</arr> <arr name="dc.identifier.uri">...</arr> <arr name="subject_acid">...</arr> <arr name="dc.identifier.isbn">...</arr> <arr name="subject_filter">...</arr> <arr name="publication_grp">...</arr> <arr name="bi_4_dis_filter">...</arr> <arr name="bi_2_dis_authority_filter">...</arr> <arr name="dc.title_hl">...</arr> <arr name="dateIssued">...</arr> <arr name="dc.citation.conferenceTitle.en">...</arr> <arr name="type_ac">...</arr> <date name="SolrIndexer.lastIndexed">2018-08-15T14:43:38Z</date> <arr name="location.comm">...</arr> <arr name="dc.description">...</arr> <str name="dc.title_sort">...</str> <arr name="author_acid">...</arr> <str name="discoverable">true</str> <str name="bi_sort_2_sort">2006</str> <arr name="dc.identifier.citation.en">...</arr> <arr name="dc.subject.asfa_mlt">...</arr> <arr name="dc.subject.lcsh.en">...</arr> <arr name="dc.title">...</arr> <arr name="dateIssued.year">...</arr> <arr name="dc.contributor.author_stored">...</arr> <arr name="dc.subject.asfa">...</arr> <arr name="location">...</arr> <arr name="title">...</arr> <arr name="stream_source_info">...</arr> <arr name="stream_content_type">...</arr> <arr name="stream_size">...</arr> <arr name="Content-Encoding">...</arr> <arr name="stream_name">...</arr> <arr name="Content-Type">...</arr> <arr name="fulltext">...</arr> <arr name="fulltext_hl">...</arr> <long name="_version_">1608876523958304768</long> </doc> </result> </response> Thanks and best regards, euler On Wednesday, August 15, 2018 at 9:55:43 PM UTC+8, helix84 wrote: > > 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 <[email protected] <javascript:>> > 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 <[email protected]> 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 [email protected] <javascript:>. > > To post to this group, send email to [email protected] > <javascript:>. > > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
