Not able to see the output when search is clicked
Hi, In my SOLR, I have a query based data-config written and was able to manage below steps but i was not able to see the output 1) Register Data Import Request handler in Solr-config.xml 2) Modify Data-Config.xml for the appropriate query to get data imported from which includes making use of Jtds Driver for Sql server 3) Modify SolrConfig.xml file for registering db-data-config.xml in Request Handler item 4) Modify schema.xml for the output result. Right now we are facing issues here.please let me attach 2 files 1) schema.xml 2) db-data-config.xml. Schema.xml ?xml version=1.0 encoding=UTF-8 ? schema name=example version=1.2 types fieldType name=string class=solr.StrField sortMissingLast=true omitNorms=true / fieldType name=int class=solr.TrieIntField precisionStep=0 omitNorms=true positionIncrementGap=0 / fieldType name=date class=solr.TrieDateField omitNorms=true precisionStep=0 positionIncrementGap=0 / fieldType name=text class=solr.TextField positionIncrementGap=100 analyzer type=index tokenizer class=solr.WhitespaceTokenizerFactory / filter class=solr.StopFilterFactory ignoreCase=true words=stopwords.txt enablePositionIncrements=true / filter class=solr.WordDelimiterFilterFactory generateWordParts=1 generateNumberParts=1 catenateWords=1 catenateNumbers=1 catenateAll=0 splitOnCaseChange=1 / filter class=solr.LowerCaseFilterFactory / filter class=solr.SnowballPorterFilterFactory language=English protected=protwords.txt / /analyzer analyzer type=query tokenizer class=solr.WhitespaceTokenizerFactory / filter class=solr.SynonymFilterFactory synonyms=synonyms.txt ignoreCase=true expand=true / filter class=solr.StopFilterFactory ignoreCase=true words=stopwords.txt enablePositionIncrements=true / filter class=solr.WordDelimiterFilterFactory generateWordParts=1 generateNumberParts=1 catenateWords=0 catenateNumbers=0 catenateAll=0 splitOnCaseChange=1 / filter class=solr.LowerCaseFilterFactory / filter class=solr.SnowballPorterFilterFactory language=English protected=protwords.txt / /analyzer /fieldType /types fields field name=FileId type=string indexed=true stored=true required=true / field name=Title type=string indexed=true stored=true required=true / /fields uniqueKeyFileId/uniqueKey defaultSearchFieldFileId/defaultSearchField solrQueryParser defaultOperator=AND / /schema db-data-config.xml dataConfig dataSource type=JdbcDataSource driver=net.sourceforge.jtds.jdbc.Driver url=jdbc:jtds:sqlserver://17.30.199.667:1433;databaseName= user= password=XXX / document entity name=Files query=Select FileID,Title from files field column=FileID name=FileID / field column=Title name=Title / /entity /document /dataConfig 5) Make full import http request for data to get indexed into solr server. Even though i see that all the rows are indexed but not able to find results when search is clicked on the admin page Thanks Raj Deep Benefitfocus is the largest benefits technology provider in the U.S. More than 15 million consumers, 300,000 employers and 60,000 brokers use our cloud-based platform to shop, enroll, manage and exchange all their benefits in one place. From consumer engagement and education to enrollment, communication and billing, Benefitfocus is helping companies find a better way to manage their benefits. For more information, visit www.benefitfocus.com Benefitfocus  All Your Benefits. One Place. CONFIDENTIALITY NOTICE: This message and any attachments are for the use of the intended individuals and may contain information that is confidential and exempt from disclosure under law. If you are not the intended recipient, any further use, distribution, or disclosure of this message or attachments is strictly prohibited. If you have received this communication in error, please contact the sender or bfpostmas...@benefitfocus.com immediately and delete this message and any attachments from your system. (01/2012) dataConfig dataSource type=JdbcDataSource driver=net.sourceforge.jtds.jdbc.Driver url=jdbc:jtds:sqlserver://17.30.199.667:1433;databaseName= user= password=XXX / document entity name=Files query=Select FileID,Title from files field column=FileID name=FileID / field column=Title name=Title / /entity /document /dataConfig ?xml version=1.0 encoding=UTF-8 ? schema name=example version=1.2 types fieldType name=string class=solr.StrField sortMissingLast=true omitNorms=true / fieldType name=int class=solr.TrieIntField precisionStep=0 omitNorms=true
Re: Not able to see the output when search is clicked
On Wed, Jan 11, 2012 at 4:31 PM, Rajdeep Alapati rajdeep.alap...@benefitfocus.com wrote: [...] 5) Make full import http request for data to get indexed into solr server. Even though i see that all the rows are indexed but not able to find results when search is clicked on the admin page Sorry, what do you mean by when search is clicked on the admin page? What are you entering in the text input box? Please, cut and paste the exact URL that you are taken to after clicking. Regards, Gora
RE: Not able to see the output when search is clicked
Hi Mohanty, I have entered *:* in the search box and the url it redirected to was http://localhost:8983/solr/select/?q=*%3A*version=2.2start=0rows=10indent=on; and the output was the below content where i expected 3 rows in 3 items Thanks Raj Deep Alapati ?xml version=1.0 encoding=UTF-8 ? - response - lst name=responseHeader int name=status0/int int name=QTime0/int /lst - lst name=initArgs - lst name=defaults str name=configdb-data-config.xml/str /lst /lst str name=statusidle/str str name=importResponse / - lst name=statusMessages str name=Total Requests made to DataSource1/str str name=Total Rows Fetched3/str str name=Total Documents Skipped0/str str name=Full Dump Started2012-01-10 06:24:14/str str name=Indexing completed. Added/Updated: 3 documents. Deleted 0 documents./str str name=Committed2012-01-10 06:24:16/str str name=Optimized2012-01-10 06:24:16/str str name=Total Documents Processed3/str str name=Time taken0:0:2.578/str /lst str name=WARNINGThis response format is experimental. It is likely to change in the future./str /response From: Gora Mohanty [g...@mimirtech.com] Sent: 11 January 2012 17:15 To: solr-user@lucene.apache.org Subject: Re: Not able to see the output when search is clicked On Wed, Jan 11, 2012 at 4:31 PM, Rajdeep Alapati rajdeep.alap...@benefitfocus.com wrote: [...] 5) Make full import http request for data to get indexed into solr server. Even though i see that all the rows are indexed but not able to find results when search is clicked on the admin page Sorry, what do you mean by when search is clicked on the admin page? What are you entering in the text input box? Please, cut and paste the exact URL that you are taken to after clicking. Regards, Gora Benefitfocus is the largest benefits technology provider in the U.S. More than 15 million consumers, 300,000 employers and 60,000 brokers use our cloud-based platform to shop, enroll, manage and exchange all their benefits in one place. From consumer engagement and education to enrollment, communication and billing, Benefitfocus is helping companies find a better way to manage their benefits. For more information, visit www.benefitfocus.com Benefitfocus  All Your Benefits. One Place. CONFIDENTIALITY NOTICE: This message and any attachments are for the use of the intended individuals and may contain information that is confidential and exempt from disclosure under law. If you are not the intended recipient, any further use, distribution, or disclosure of this message or attachments is strictly prohibited. If you have received this communication in error, please contact the sender or bfpostmas...@benefitfocus.com immediately and delete this message and any attachments from your system. (01/2012)
Re: Not able to see the output when search is clicked
Several questions: 1 did you commit after the full import? 2 have you tried looking at the interactive DIH console? See: http://wiki.apache.org/solr/DataImportHandler#interactive 3 Do your Solr logs show anything? Best Erick On Wed, Jan 11, 2012 at 7:27 AM, Rajdeep Alapati rajdeep.alap...@benefitfocus.com wrote: Hi Mohanty, I have entered *:* in the search box and the url it redirected to was http://localhost:8983/solr/select/?q=*%3A*version=2.2start=0rows=10indent=on; and the output was the below content where i expected 3 rows in 3 items Thanks Raj Deep Alapati ?xml version=1.0 encoding=UTF-8 ? - response - lst name=responseHeader int name=status0/int int name=QTime0/int /lst - lst name=initArgs - lst name=defaults str name=configdb-data-config.xml/str /lst /lst str name=statusidle/str str name=importResponse / - lst name=statusMessages str name=Total Requests made to DataSource1/str str name=Total Rows Fetched3/str str name=Total Documents Skipped0/str str name=Full Dump Started2012-01-10 06:24:14/str str name=Indexing completed. Added/Updated: 3 documents. Deleted 0 documents./str str name=Committed2012-01-10 06:24:16/str str name=Optimized2012-01-10 06:24:16/str str name=Total Documents Processed3/str str name=Time taken0:0:2.578/str /lst str name=WARNINGThis response format is experimental. It is likely to change in the future./str /response From: Gora Mohanty [g...@mimirtech.com] Sent: 11 January 2012 17:15 To: solr-user@lucene.apache.org Subject: Re: Not able to see the output when search is clicked On Wed, Jan 11, 2012 at 4:31 PM, Rajdeep Alapati rajdeep.alap...@benefitfocus.com wrote: [...] 5) Make full import http request for data to get indexed into solr server. Even though i see that all the rows are indexed but not able to find results when search is clicked on the admin page Sorry, what do you mean by when search is clicked on the admin page? What are you entering in the text input box? Please, cut and paste the exact URL that you are taken to after clicking. Regards, Gora Benefitfocus is the largest benefits technology provider in the U.S. More than 15 million consumers, 300,000 employers and 60,000 brokers use our cloud-based platform to shop, enroll, manage and exchange all their benefits in one place. From consumer engagement and education to enrollment, communication and billing, Benefitfocus is helping companies find a better way to manage their benefits. For more information, visit www.benefitfocus.com Benefitfocus All Your Benefits. One Place. CONFIDENTIALITY NOTICE: This message and any attachments are for the use of the intended individuals and may contain information that is confidential and exempt from disclosure under law. If you are not the intended recipient, any further use, distribution, or disclosure of this message or attachments is strictly prohibited. If you have received this communication in error, please contact the sender or bfpostmas...@benefitfocus.com immediately and delete this message and any attachments from your system. (01/2012)
Re: Not able to see the output when search is clicked
On Wed, Jan 11, 2012 at 5:57 PM, Rajdeep Alapati rajdeep.alap...@benefitfocus.com wrote: Hi Mohanty, I have entered *:* in the search box and the url it redirected to was http://localhost:8983/solr/select/?q=*%3A*version=2.2start=0rows=10indent=on; OK, this looks fine: I was just wondering if you had missed the *:* and the output was the below content where i expected 3 rows in 3 items That output is from the import, and not from the query. It does show that the data import completed successfully, committed, and optimised the index. Maybe, your fields are not set up correctly. Could you share your schema.xml, and the DIH configuration file, data-config.xml? Preferably, use pastebin.com for these. Regards, Gora
Mohanty:RE: Not able to see the output when search is clicked
Hi Mohanty, Can you please guess what is happening on my side. Any help would be great Thanks Raj Deep Alapati From: Gora Mohanty [g...@mimirtech.com] Sent: 11 January 2012 17:15 To: solr-user@lucene.apache.org Subject: Re: Not able to see the output when search is clicked On Wed, Jan 11, 2012 at 4:31 PM, Rajdeep Alapati rajdeep.alap...@benefitfocus.com wrote: [...] 5) Make full import http request for data to get indexed into solr server. Even though i see that all the rows are indexed but not able to find results when search is clicked on the admin page Sorry, what do you mean by when search is clicked on the admin page? What are you entering in the text input box? Please, cut and paste the exact URL that you are taken to after clicking. Regards, Gora Benefitfocus is the largest benefits technology provider in the U.S. More than 15 million consumers, 300,000 employers and 60,000 brokers use our cloud-based platform to shop, enroll, manage and exchange all their benefits in one place. From consumer engagement and education to enrollment, communication and billing, Benefitfocus is helping companies find a better way to manage their benefits. For more information, visit www.benefitfocus.com Benefitfocus  All Your Benefits. One Place. CONFIDENTIALITY NOTICE: This message and any attachments are for the use of the intended individuals and may contain information that is confidential and exempt from disclosure under law. If you are not the intended recipient, any further use, distribution, or disclosure of this message or attachments is strictly prohibited. If you have received this communication in error, please contact the sender or bfpostmas...@benefitfocus.com immediately and delete this message and any attachments from your system. (01/2012)
Re: Mohanty:RE: Not able to see the output when search is clicked
On Thu, Jan 12, 2012 at 12:49 PM, Rajdeep Alapati rajdeep.alap...@benefitfocus.com wrote: Hi Mohanty, Can you please guess what is happening on my side. Any help would be great [...] People have followed up to you in your original thread. Could you please respond there, and provide the information asked for? Regards, Gora